How can a foreach loop be used to update multiple data records in a database using PHP?

When updating multiple data records in a database using PHP, a foreach loop can be used to iterate through an array of data and execute an update query for each record. This allows for efficient and streamlined updating of multiple records in the database. 

// Assuming $data is an array of records to be updated
foreach ($data as $record) {
    $id = $record['id'];
    $newData = $record['new_data'];

    // Update query to update record with new data
    $sql = "UPDATE table_name SET column_name = '$newData' WHERE id = $id";
    
    // Execute the query
    $result = mysqli_query($connection, $sql);

    if (!$result) {
        echo "Error updating record with ID: $id";
    }
}

Keywords

foreach loop update multiple data records database PHP

Related Questions