How can PHP be used to update a database table based on a condition?

To update a database table based on a condition using PHP, you can use the UPDATE query with a WHERE clause. This allows you to specify the condition that must be met for the update to occur. By using PHP variables to construct the query, you can dynamically update the table based on different conditions. 

<?php
// Establish a connection 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);
}

// Define the condition
$condition = "id = 1"; // Example condition

// Define the update query
$sql = "UPDATE table_name SET column_name = 'new_value' WHERE $condition";

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

// Close the connection
$conn->close();
?>

Keywords

PHP database update condition table

Related Questions