cII 框架批量更新报错Message: Undefined index: id Filename: database/DB_query_builder.php「建议收藏」

全栈程序员站长

发布于 2022-07-11 14:50:47

2450

发布于 2022-07-11 14:50:47

文章被收录于专栏：全栈程序员必看全栈程序员必看

大家好，又见面了，我是全栈君。

cII 框架批量更新报错Message: Undefined index: id Filename: database/DB_query_builder.php「建议收藏」

正确代码:修改两处1949行和1955行

protected function _update_batch($table, $values, $index)
	{
		$index_escaped = $this->protect_identifiers($index);

		$ids = array();
		foreach ($values as $key => $val)
		{
			$ids[] = $val[$index_escaped];

			foreach (array_keys($val) as $field)
			{
				if ($field !== $index)
				{
					$final[$field][] = 'WHEN '.$index_escaped.' = '.$val[$index_escaped].' THEN '.$val[$field];
				}
			}
		}

		$cases = '';
		foreach ($final as $k => $v)
		{
			$cases .= $k." = CASE \n"
				.implode("\n", $v)."\n"
				.'ELSE '.$k.' END, ';
		}

		$this->where($index_escaped.' IN('.implode(',', $ids).')', NULL, FALSE);

		return 'UPDATE '.$table.' SET '.substr($cases, 0, -2).$this->_compile_wh('qb_where');
	}