Why the search in the PHP site can only search English and letters, can't search Chinese?
Q: Why search in the PHP site can only search English and letters, can not search Chinese?
Search Chinese, show blank, please heroes, pointing Maze!
if (!mysql_connect ("localhost", "admin", "admin"))
Die ("Could Not Connect:". Mysql_error ());
mysql_select_db ("CESF");
$query = "SET NAMES ' GB2312 '";
mysql_query ($query);
?>
$keyword =$_post[' keyword '];
$contents = Array ();
$rt =mysql_query ("select * from dede_archives where title like '% $keyword% '");
while ($rs =mysql_fetch_array ($RT))
{
$contents []= $rs;
}
?>
Query instance
foreach ($contents as $key = = $value) {
echo "
"; Echo"
$value [title] |
"; Echo"
";
}
?>
Share to:
------Solution--------------------
Print out the SQL statement to see if the SQL statement is normal (mainly guessing that the Chinese parameters obtained may be garbled
------Solution--------------------
------Solution--------------------
Print SQL directly to see if the database has values.