1054:Unknown column 'xxx' in 'where clause' [ SQL语句 ] : SELECT * FROM `secp_user` WHERE ( Uname = admin )
thinkPHP用户登录检查session时报错1054,百度了一下,发现是变量的数据类型导致的该问题:代码如下
$data=session('username');
$user=M('user')->where("Uname={$data}")->find();
$user是字符串类型,应该给变量加上单引号,修改为:
$data=session('username');
$user=M('user')->where("Uname='{$data}'")->find();