What are the best practices for updating database records based on checked and unchecked checkboxes in PHP?

When dealing with checkboxes in a form, it is common to update database records based on whether the checkboxes are checked or unchecked. To achieve this in PHP, you can iterate through the checkboxes in the form submission data, and update the corresponding records in the database accordingly. 

// Assuming form data is submitted via POST method
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Connect to the database
    $conn = new mysqli("localhost", "username", "password", "database");

    // Check if checkboxes are checked or unchecked and update records
    foreach ($_POST['checkbox'] as $id => $value) {
        $checked = ($value == 'on') ? 1 : 0;
        $sql = "UPDATE table SET checked = $checked WHERE id = $id";
        $conn->query($sql);
    }
    
    // Close the database connection
    $conn->close();
}

Keywords

SQL UPDATE query checkboxes PHP database records

Related Questions