关于sql语句中文字符串和英文字符串的区别

$name1='张三';
$name2 = 'zhangsan';

链接mysql省略..

$result1=mysqli_query($con,"select * from student WHERE stu_name= $name1 ");
$result2=mysqli_query($con,"select * from student WHERE stu_name= $name2 ");
var_dump($result1);
var_dump($result2);

得到的结果$result1是false,$result2是true.

 

$result1=mysqli_query($con,"select * from student WHERE stu_name= '$name1' ");

给这里加上单引号就能解析返回结果为true

他们的区别就是在中文下的字符串赋给变量不能解析,而英文就能解析.这点的注意.

转载于:https://my.oschina.net/ricooo/blog/679223