删除更新数据库字段

最新推荐文章于 2022-09-07 11:23:26 发布

weixin_30615767

最新推荐文章于 2022-09-07 11:23:26 发布

阅读量120

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/songyanan/p/10622433.html

版权

 /**
* 删除更新数据库字段
* @param $table
* @param $field
* @param $teacherId
* @param $idArr
* @param $sqlOptions sql条件字段 --查询
*/
public function updateField($table, $field, $teacherId, $idArray, $sqlOptions = '')
{
$is = M("{$table}")->find("$sqlOptions = ?", [$teacherId])->first();
if ($is) {
$delSql = " delete from {$table} where teacher_id = ? ";
M("{$table}")->delete();
}
$idArr = explode(',', $idArray);
$insertSql = "insert into {$table} ({$field}) values ";
array_walk($idArray, function ($val, $k) use (&$teacherId, &$insertSql, &$field) {
$fieldArr = explode(',', $field);
if (count($fieldArr) > 2) {
$insertSql .= "({$teacherId},2,{$val}),";
} else {
$insertSql .= "({$teacherId},{$val}),";
}
});
$insertSql = substr($insertSql, 0, strrpos($insertSql, ',')); \
M("{$table}")->update();
}