$con = mysql_connect("localhost","root","root"); //$dbname = "weixin"; function selectMsg($str) { $rows = array(); $msgArr = array(); $like = array(); $arr = array(); $sql = "SELECT * FROM weixin.weixin_msg WHERE FIND_IN_SET('".$str."',Title)"; $result = mysql_query($sql); while($rows = mysql_fetch_array($result, MYSQL_ASSOC)) { $msgArr[] = $rows; } if (!empty($msgArr)) { return $msgArr; }else{ $sqlstr = "SELECT * FROM weixin.weixin_msg WHERE Title LIKE '%".$str."%' order by id desc"; $like = mysql_query($sqlstr); while($arr = mysql_fetch_array($like, MYSQL_ASSOC)) { $msgArr[] = $arr; } return $msgArr; } } function cityName($keyword) { $sql = "SELECT * FROM weixin.weixin_cityname WHERE FIND_IN_SET('".$keyword."',CityNameCn)"; $result = mysql_fetch_array(mysql_query($sql), MYSQL_ASSOC); print_r($result); } cityName("北京"); $res= selectMsg("123"); echo "<pre class="brush:php;toolbar:false">"; print_r($res);
Nach dem Login kopieren
selectMsg那个函数可以输出,
但是下面城市的就不行,检查了一下不是表名之类的问题.字段也是utf8
这样查询也可以
解决了,在链接数据库后加入以下代码
header("Content-Type: text/html;charset=utf-8"); //连接数据库 $con = mysql_connect("localhost","root","root"); mysql_query("set character set 'utf8'");//读库 mysql_query("set names 'utf8'");//写库
Nach dem Login kopieren