How can PHP beginners handle the issue of setting only one value to 1 in a MySQL table?

When setting only one value to 1 in a MySQL table, beginners can use a simple SQL query to update the desired row to 1 and set all other rows to 0. This can be achieved by first updating all rows to 0 and then setting the specific row to 1. 

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

// Update all rows to 0
$sql = "UPDATE table_name SET column_name = 0";
$conn->query($sql);

// Set specific row to 1
$id = 1; // ID of the row to set to 1
$sql = "UPDATE table_name SET column_name = 1 WHERE id = $id";
$conn->query($sql);

$conn->close();
?>

Keywords

PHP MySQL beginners set value table

Related Questions