How can JavaScript and AJAX be used in conjunction with PHP for updating database values?

To update database values using JavaScript, AJAX, and PHP, you can create a JavaScript function that sends an AJAX request to a PHP script. The PHP script will then update the database values based on the data sent from the JavaScript function. This allows for dynamic updating of database values without having to reload the entire page. 

<?php
// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// Get data from AJAX request
$valueToUpdate = $_POST['value'];
$id = $_POST['id'];

// Update database value
$sql = "UPDATE table_name SET column_name = '$valueToUpdate' WHERE id = $id";

if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}

$conn->close();
?>

Keywords

JavaScript AJAX PHP database values

Related Questions