PHP:
$params = ['id' => $id];
foreach ($data as $index => $obj) {
$paramName = 'id_'.$index;
$paramValue = 'value_'.$index;
$updateCases .= "WHEN :$paramName THEN :$paramValue ";
$params[$paramName] = array(
'type' => Query::PARAM_INT,
'value' => $obj->id
);
$params[$paramValue] = array(
'type' => Query::PARAM_INT,
'value' => $obj->value
);
}
$sql = "UPDATE table SET value = CASE id $updateCases ELSE value END WHERE id = :id";
$db->prepare($sql)->execute($params);
