tp3.2 批量插入

最新推荐文章于 2021-04-06 01:58:41 发布

蒙--

最新推荐文章于 2021-04-06 01:58:41 发布

阅读量2.8k

点赞数

分类专栏： tp3.2

本文链接：https://blog.csdn.net/mengzuchao/article/details/80408671

版权

tp3.2 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

$serverInfo = json_decode($_POST['serverinfo']);
$gameModel = D("Admin/Game");
$serverInfoModel = M('serverinfo', 'cy_');
$dataList = [];

$failGameId = [];//不存在的gameId
foreach ($serverInfo as $info) {
	$gameId = $info[0];
	$gameName = $gameModel->getGameName($gameId);
	if ($info[0] == 1) {
		continue;
	}
	if (empty($gameName)) { //过滤不存在的游戏
		$failGameId[]= $gameId;
		continue;
	}
	$data['gameid'] = $gameId;
	$data['sername'] = $info[1];
	$data['sertime'] = strtotime(gmdate('Y-m-d H:i', \PHPExcel_Shared_Date::ExcelToPHP($info[2])));
	$data['order'] = $info[3];
	$dataList[] = $data;
}

// 批量添加数据
$insertInfo = $serverInfoModel->addAll($dataList);