/** * 方法功能:修改 * 说明:传递过来的$data_array必须是关联数组,例如:array('key'=>'value'), * 其中key是要修改的表的字段名称,value是要给字段重新赋的值;$where参数是条件 * @param unknown $data_array * @param unknown $where * @return boolean */ public static function update($data_array, $where) { self::initDB(); if (empty($data_array) || !is_array($data_array)) { //判断是否是数组 self::$errCode = '004'; self::$errMsg = "SuperorderAuditModel update error1"; return false; } $setting = ''; foreach ($data_array as $key => $value) { $setting .= ',`' . $key . '` = \'' . $value . '\''; //把数组内容转换为字符串格式,例如:`dept_name`='it',`dept_principal`='admin' } $setting = ltrim($setting, ','); //去除最左边的逗号 $sql = 'UPDATE `' . self::$table_name . '` SET ' . $setting . ' WHERE ' . $where; //echo $sql."\n"; return self::$dbConn->query($sql); }