$table = db('config');
foreach ($datas as $k => $v) {
$table->where(['name' => $k, 'inc_type' => 'system'])->update(['value' => $v]);
echo $table->getLastSql();
}其中$datas的内容
Array
(
[site_name] => 33制教学平台
[site_url] => http://localhost:8001/admin/index/index.html
[site_ti
tle] => 33制教学平台
[site_keyword] => 33制教学平台
[site_description] => 33制教学平台
[site_logo] =>
[file] =>
[site_bah] => 33制教学平台
[copyright] => 33制教学平台
[address] => 33制教学平台
[site_tel] => 33制教学平台
[site_email] => 33制教学平台
)
输出结果是
UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system'
UPDATE `oc_config` SET `value` = 'http://localhost:8001/admin/index/index.html' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system'
UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system'UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system'
UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system' AND `name` = 'site_description' AND `inc_type` = 'system'UPDATE `oc_config` SET `value` = '' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system' AND `name` = 'site_description' AND `inc_type` = 'system' AND `name` = 'site_logo' AND `inc_type` = 'system'UPDATE `oc_config` SET `value` = '' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system' AND `name` = 'site_description' AND `inc_type` = 'system' AND `name` = 'site_logo' AND `inc_type` = 'system' AND `name` = 'file' AND `inc_type` = 'system'UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system' AND `name` = 'site_description' AND `inc_type` = 'system' AND `name` = 'site_logo' AND `inc_type` = 'system' AND `name` = 'file' AND `inc_type` = 'system' AND `name` = 'site_bah' AND `inc_type` = 'system'UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system' AND `name` = 'site_description' AND `inc_type` = 'system' AND `name` = 'site_logo' AND `inc_type` = 'system' AND `name` = 'file' AND `inc_type` = 'system' AND `name` = 'site_bah' AND `inc_type` = 'system' AND `name` = 'copyright' AND `inc_type` = 'system'UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system' AND `name` = 'site_description' AND `inc_type` = 'system' AND `name` = 'site_logo' AND `inc_type` = 'system' AND `name` = 'file' AND `inc_type` = 'system' AND `name` = 'site_bah' AND `inc_type` = 'system' AND `name` = 'copyright' AND `inc_type` = 'system' AND `name` = 'address' AND `inc_type` = 'system'UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system' AND `name` = 'site_description' AND `inc_type` = 'system' AND `name` = 'site_logo' AND `inc_type` = 'system' AND `name` = 'file' AND `inc_type` = 'system' AND `name` = 'site_bah' AND `inc_type` = 'system' AND `name` = 'copyright' AND `inc_type` = 'system' AND `name` = 'address' AND `inc_type` = 'system' AND `name` = 'site_tel' AND `inc_type` = 'system'UPDATE `oc_config` SET `value` = '33制教学平台' WHERE `name` = 'site_name' AND `inc_type` = 'system' AND `name` = 'site_url' AND `inc_type` = 'system' AND `name` = 'site_title' AND `inc_type` = 'system' AND `name` = 'site_keyword' AND `inc_type` = 'system' AND `name` = 'site_description' AND `inc_type` = 'system' AND `name` = 'site_logo' AND `inc_type` = 'system' AND `name` = 'file' AND `inc_type` = 'system' AND `name` = 'site_bah' AND `inc_type` = 'system' AND `name` = 'copyright' AND `inc_type` = 'system' AND `name` = 'address' AND `inc_type` = 'system' AND `name` = 'site_tel' AND `inc_type` = 'system' AND `name` = 'site_email' AND `inc_type` = 'system'
这不科学啊，不对啊
