How can a PHP beginner update a database value by clicking on an image?

To update a database value by clicking on an image, you can use JavaScript to send an AJAX request to a PHP script that updates the database. The PHP script will receive the data sent by the AJAX request and update the database accordingly. You can then use JavaScript to update the image or display a success message to the user. 

<?php
// Connect to the 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);
}

// Check if the image was clicked
if(isset($_POST['image_clicked'])) {
    // Update database value
    $sql = "UPDATE table_name SET column_name = new_value WHERE condition";
    
    if ($conn->query($sql) === TRUE) {
        echo "Record updated successfully";
    } else {
        echo "Error updating record: " . $conn->error;
    }
}

$conn->close();
?>

Keywords

PHP database update click event image icon

Related Questions