发布于 5年前

MySQL 搜索中文乱码 (1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xC1\xAA\xCF\xEB'

代码如下:

$keywords = $_GET['keyword];
$where = " where keywords=".$keywords;

DB::result_first("SELECT count(*) FROM  DB::table('article')  $where_keywords");

搜索中文时,乱码错误,如:

(1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xD6\xD0\xCE\xC4' at line 1
SELECT * FROM article where keywords=中文

解决方案

$keywords 用单引号包裹起来,如

$where = " where keywords='".$keywords."'";
©2020 edoou.com   京ICP备16001874号-3