SQL tp3.2 批量更新 saveAll

/**
* 批量更新数据
* @param [array] $datas [更新数据]
* @param [string] $table_name [表名]
*/
public function saveAll($datas,$table_name,$pk){
$sql = ''; //Sql
$lists = []; //记录集$lists
foreach ($datas as $data) {
foreach ($data as $key=>$value) {
if($pk===$key){
$ids[]=$value;
}else{
$lists[$key].= sprintf("WHEN %u THEN '%s' ",$data[$pk],$value);
}
}
}
foreach ($lists as $key => $value) {
$sql.= sprintf("`%s` = CASE `%s` %s END,",$key,$pk,$value);
}
$sql = sprintf('UPDATE __%s__ SET %s WHERE %s IN ( %s )',strtoupper($table_name),rtrim($sql,','),$pk,implode(',',$ids));
return M()->execute($sql);
}

转载于:https://www.cnblogs.com/alexguoyihao/p/9503645.html