How can AJAX be effectively used to populate form fields in PHP?

To populate form fields in PHP using AJAX, you can create a JavaScript function that sends a request to a PHP script to fetch the data and then populate the form fields with the retrieved data. The PHP script will query the database or any other data source to retrieve the data and return it in a JSON format. The JavaScript function will then parse the JSON data and populate the form fields accordingly. 

// PHP script to fetch data from database and return as JSON
<?php
// Connect to database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if ($connection->connect_error) {
    die("Connection failed: " . $connection->connect_error);
}

// Fetch data from database
$query = "SELECT * FROM table_name";
$result = mysqli_query($connection, $query);

$data = array();
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}

// Close connection
mysqli_close($connection);

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

Keywords

AJAX form fields PHP data population XMLHttpRequest

Related Questions