Updating Data with PHP

To update data in a database using PHP, you will need to use the SQL UPDATE statement. Below is an example of how to update data using PHP:

“`php
connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}

// Get data from form or other source
$id = $_POST[‘id’];
$newValue = $_POST[‘newValue’];

// Update data in database
$sql = “UPDATE table_name SET column_name = ‘$newValue’ WHERE id = ‘$id'”;

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

$conn->close();

?>
“`

In this example, you’ll need to replace “localhost”, “username”, “password”, “database”, “table_name”, and “column_name” with your own database details. Also, make sure to properly validate and sanitize the user input to prevent SQL injection attacks.

You can use the $_POST global variable to retrieve data from a form, but you can also get data from other sources like a URL parameter ($_GET), session data ($_SESSION), or a database query.

The SQL UPDATE statement specifies the table and column to update, and uses the WHERE clause to specify the condition for updating the data.