2023年8月3日发(作者：)

mysqlupdate修改多条数据$display_order=array(23687=>'23687ff',23684=>'23684ff');$city=array(23687=>'23687ffxx',23684=>'23684ffxx');

$ids =implode(',', array_keys($display_order)); $sql= "UPDATE table SET name= CASE id";//name

某列

foreach ($display_order as $id => $ordinal) { $sql .= sprintf(" WHEN %d THEN '%s' ", $id, $ordinal);//

拼接SQL语句

} $sql .="END,title = CASE id "; foreach ($city as $cityId => $cityVal) {

$sql .= sprintf(" WHEN %d THEN '%s' ", $cityId, $cityVal);//

拼接SQL语句

} $sql .= "END WHERE id IN ($ids)";

2023年8月3日发(作者：)

mysqlupdate修改多条数据$display_order=array(23687=>'23687ff',23684=>'23684ff');$city=array(23687=>'23687ffxx',23684=>'23684ffxx');

$ids =implode(',', array_keys($display_order)); $sql= "UPDATE table SET name= CASE id";//name

某列

foreach ($display_order as $id => $ordinal) { $sql .= sprintf(" WHEN %d THEN '%s' ", $id, $ordinal);//

拼接SQL语句

} $sql .="END,title = CASE id "; foreach ($city as $cityId => $cityVal) {

$sql .= sprintf(" WHEN %d THEN '%s' ", $cityId, $cityVal);//

拼接SQL语句

} $sql .= "END WHERE id IN ($ids)";