yii2.0适用
function updateTableData($tableName, $data, $whereArr)
{
//更新数据组合
$set = [];
foreach ($data as $key => $val) {
if ($key != 'id') {
$set[] = "`{$key}` = '{$val}'";
}
}
$set = implode(",", $set);
//更新条件组合
$where = [];
foreach ($whereArr as $key => $val) {
$where[] = " `{$key}` = '{$val}' ";
}
$where = implode("and", $where);
$sql = "UPDATE `{$tableName}` SET {$set} WHERE {$where} ";
return Yii::$app->getDb()->createCommand($sql)->execute();
}