写sql时遇到的BUG,问题是这样的:
A Database Error Occurred
Error Number: 1054
Unknown column 'john' in 'where clause'
select * from user where u_name = john
Filename: F:/CI/system/database/DB_driver.php
Line Number: 691
报错中出现了Unknown column 'john' in where clause.字面意思是没有找到john列。其实数据表中是有这行信息的,问题的根源在于拼凑SQL语句时,没有对字符类型的数据使用引号引起来,导致报这样的错误
原来sql语句:$query = $this->db->query("select * from user where u_name = $username")
更改后:$query = $this->db->query("select * from user where u_name = '$username'")