日志里的插入与数据库中真正插入的不一致

浏览:558 发布日期:2018/11/17 分类:求助交流 关键字: mysql tp5 求助交流
[ sql ] [ DB ] CONNECT:[ UseTime:0.000726s ] mysql:host=127.0.0.1;port=3306;dbname=api_heifuture_c;charset=utf8
[ 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]);
            }
        }
最佳答案
评论( 相关
后面还有条评论,点击查看>>