[ sql ] [ SQL ] SHOW COLUMNS FROM `student` [ RunTime:0.000808s ]
[ sql ] [ SQL ] SELECT * FROM `student` WHERE `studentID` = 2420173060 LIMIT 1 [ RunTime:0.000638s ]
[ sql ] [ SQL ] INSERT INTO `student` (`name` , `studentID` , `school` , `profession` , `class` , `password`) VALUES ( '肖礼浩','2420173060',...(省略一部分敏感信息)
上面的是日志的内容,但是到数据库里就变成插入的另外一个学号了
我的代码如下
//是否登录成功
if (array_key_exists('studentID', $result)) {
$check1 = Db::table('student')
->field($studentID)
->find();
//是否为首次登录,如果是null,插入数据
if ($check1 == null) {
Db::table('student')
->insertAll([
['name' => $result['name'], 'studentID' => $result['studentID'],
'school' => $result['school'], 'profession' => $result['profession'],
'class' => $result['class'], 'password' => $password],
]);
} else {
Db::table('student')
->where('studentID', '=', $studentID)
->setField([password => $password]);
}
} 最佳答案