Update multiple columns in MySQL using PHP

A guide on how to update multiple columns in MySQL using PHP. This PHP code uses the UPDATE statement to change multiple column values in a MySQL database.

<?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 multiple columns
$sql = "UPDATE table_name SET column1='new_value1', column2='new_value2', column3='new_value3' 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 with multiple columns:

   • The SQL query UPDATE table_name SET column1='new_value1', column2='new_value2', column3='new_value3' WHERE id=1 updates the values of three columns column1, column2, and column3 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. The required functions such as mysqli and strtr are supported across these versions.