ci框架使用FIND_IN_SET

最新推荐文章于 2024-10-18 10:16:47 发布

原创最新推荐文章于 2024-10-18 10:16:47 发布 · 515 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

CI框架专栏收录该内容

7 篇文章

订阅专栏

本文介绍了一段控制器代码，展示了如何使用SQL LIKE操作筛选Python主题的课程，同时剖析了数据模型中get_list_like方法的细节。

控制器代码：
$where=Array(
   status=>1,
   xingzhi=>1,
   ctype=>3,
   zhuanye=>3,
   ruanjian=>3
)
$likeWhere['mingcheng'] = "python";
$query = $this->CourseModel->get_list_like($where,array("start"=>0,"pagesize"=>20),'pid asc,time desc','*',$likeWhere);

数据模型方法：
public function get_list_like($where = array(), $page_info = array(), $orderby = 'id DESC', $field = '*',$likeWhere = array())
{
$where = empty($where) ? array() : $where;
$this->set_limit($page_info);
if(isset($where['ruanjian']) && !empty($where['ruanjian'])){
$this->db->where("FIND_IN_SET($where[ruanjian],ruanjian) !=", 0);
unset($where['ruanjian']);
}
$this->db->select($field)->from($this->tablename)->where($where);
if(isset($likeWhere['mingcheng']) && !empty($likeWhere['mingcheng'])){
$this->db->like('mingcheng', $likeWhere['mingcheng'], 'both');
}
$data = $this->db->order_by($orderby)->get()->result_array();
echo $this->db->last_query();//打印sql语句
return $this->return_array($data);
}

sql结果：
SELECT `id`, `mingcheng`, `zhouqi`, `xb_jiage`, `yc_jiage`, `ke_pic`, `cont`, `content`, `time`, `zhuanye`, `dengji`, `ruanjian` FROM `pre_cda_kecheng_fabu` WHERE FIND_IN_SET(4,ruanjian) != 0 AND `status` = 1 AND `xingzhi` = 1 AND `ctype` = '3' AND `zhuanye` = '3' AND `mingcheng` LIKE '%python%' ESCAPE '!' ORDER BY `pid` asc, `time` desc LIMIT 12