How can PHP be used to populate a form field with suggestions from a database column?

To populate a form field with suggestions from a database column in PHP, you can use AJAX to fetch data from the database based on user input and then populate the form field with the suggestions. You can create a PHP script that queries the database for matching values and returns them as JSON, which can be processed by JavaScript to update the form field. 

<?php
// Connect to the database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Get user input
$input = $_GET['input'];

// Query the database for suggestions
$stmt = $pdo->prepare("SELECT column_name FROM your_table WHERE column_name LIKE :input");
$stmt->execute(['input' => '%' . $input . '%']);
$results = $stmt->fetchAll(PDO::FETCH_COLUMN);

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

Keywords

PHP form field suggestions database column autocomplete.

Related Questions