MySql----多条件查询

最新推荐文章于 2025-05-17 20:24:04 发布

Ink_cherry

最新推荐文章于 2025-05-17 20:24:04 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签：数据库搜索

本文链接：https://blog.youkuaiyun.com/Ink_cherry/article/details/53911413

数据库专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一种在PHP中实现的多重条件模糊查询方法。该方法允许用户通过类型、地点和描述等字段进行灵活组合查询，并能处理空值情况。查询结果会根据ID倒序排列并限制返回数量。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CI model里面一个多重条件搜索，
place type thefind 三个条件初始值为空（搜索all），在根据前端信息设定条件

根据条件搜出进行模糊查询
place=plcae
type=type
descrption,lostname,type=thfind
数据库 lost_message表中按照从id=$limst 开始id前9位排序的数据并根据lost_message->user_id =user_message->id
寻找第二个表user_message=>id并列进行输出

public function m_ninepic($limst,$type,$place,$thefind){
    // $sql="select fname,id from lost_message order by id desc limit 0,9";
    if($type==""&&$place==""&&$thefind=="")
    {$sql="select lost_message.fname,lost_message.lostname,lost_message.id,lost_message.place,lost_message.time ,user_message.name from lost_message inner join user_message on lost_message.user_id=user_message.id order by lost_message.id desc limit ".$limst.",9";}
else 
{
    $sql2="";
    if($type!="")
    {
        $sql2=$sql2."and lost_message.type='".$type."'";
    }
    if($place!="")
    {
        $sql2=$sql2."and lost_message.place='".$place."'";
    }
    if($thefind!="")
    {
        $sql2=$sql2."and (lost_message.type like '%".$thefind."%' or lost_message.description like '%".$thefind."%' or lost_message.lostname like '%".$thefind."%')";


    }
    $sql="select lost_message.fname,lost_message.lostname,lost_message.id,lost_message.place,lost_message.time ,user_message.name from lost_message inner join user_message on lost_message.user_id=user_message.id ".$sql2." order by lost_message.id desc limit ".$limst.",9";
}
    $data=$this->db->query($sql);
    $db=$data->result_array($data);
    return $db;
}