Update data in MySQL using PHP

A guide on how to update data in MySQL using PHP. This code uses the UPDATE SQL statement to change information in a MySQL database efficiently.

<?php
// Connect to MySQL
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "database_name";

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

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

// SQL query to update data
$sql = "UPDATE table_name SET column_name='new_value' WHERE id=1";

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

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

Detailed explanation:

1. Connecting to MySQL:

   • We use the mysqli object to connect to the MySQL database, supplying server, username, password, and database name.

2. UPDATE SQL statement:

   • The SQL query UPDATE table_name SET column_name='new_value' WHERE id=1 updates the value in the column_name column for the row with id=1.

3. Executing and checking the query:

   • We use $conn->query($sql) to execute the query. If successful, it prints "Record updated successfully", otherwise, it outputs the error.

4. Closing the connection:

   • After completing the operation, we use $conn->close() to close the connection to MySQL.

PHP Version:

This script is compatible with PHP versions 5.6 and above. It fully supports the functions for interacting with MySQL via the mysqli class.