How can auto suggest/auto complete functionality be implemented in PHP?

Auto suggest/auto complete functionality in PHP can be implemented by using AJAX to send asynchronous requests to the server for suggestions based on user input. The server-side PHP script will query a database or perform some other logic to fetch relevant suggestions, which are then sent back to the client for display. The client-side JavaScript will handle updating the suggestions as the user types.

<?php
// Assuming a database connection is already established

$input = $_GET['input'];

// Query the database for suggestions based on user input
$query = "SELECT suggestion FROM suggestions WHERE suggestion LIKE '%$input%'";
$result = mysqli_query($conn, $query);

$suggestions = array();
while ($row = mysqli_fetch_assoc($result)) {
    $suggestions[] = $row['suggestion'];
}

// Return suggestions as JSON
echo json_encode($suggestions);
?>