How can a foreach loop be utilized to update multiple fields in a database table using PHP?

When updating multiple fields in a database table using PHP, a foreach loop can be utilized to iterate through an array of field-value pairs and execute individual update queries for each pair. 

// Assuming $data is an associative array containing field-value pairs to update
foreach($data as $field => $value) {
    $sql = "UPDATE table_name SET $field = :value WHERE condition";
    $stmt = $pdo->prepare($sql);
    $stmt->bindValue(':value', $value);
    $stmt->execute();
}

Keywords

foreach loop database table update PHP fields

Related Questions