php - mysql FIND_IN_SET 查询不到数据

问题描述

问 题

$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>";
print_r($res);

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'");//写库

解决方案

直接把SQL拿到数据库里面跑一下

类似这种

select * from city where FIND_IN_SET(city_name , '3213222222333,123');

这篇关于php - mysql FIND_IN_SET 查询不到数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！