CI-篝火嵌套 LIKE 查询 - CI-Bonfire Nested LIKE query

CI-Bonfire Nested LIKE query

本文关键字：LIKE 查询嵌套 CI- | 更新日期: 2023-09-27

我可能需要一些帮助来嵌套一个喜欢的查询。我的目标是完成如下操作：

Select * from 'Library_Book'
WHERE(
    ('BookName' LIKE '%FILTER1%' OR 'BookDescription' LIKE '%FILTER1%')
AND 
    ('BookName' LIKE '%FILTER2%' OR 'BookDescription' LIKE '%FILTER2%')
)

到目前为止，我的方法是：

$this->db->select('Library_Book.*');
foreach($filter as $fltr){
    $this->db->like('Library_Book.BookName', $fltr);
    $this->db->or_like('Library_Book.BookDescription', $fltr);
}
$records = $this->find_all();

这导致：

Select * from 'Library_Book'
WHERE(
    'BookName' LIKE '%FILTER1%' OR 'BookDescription' LIKE '%FILTER1%'
AND 
    'BookName' LIKE '%FILTER2%' OR 'BookDescription' LIKE '%FILTER2%'
)

如何获取or_like语句两边的括号？

谢谢

图奇达蒙

CI-篝火版本 0.7

模块/mymodul/models/mymodel_model.php

朗尼泽尔在《篝火》中告诉的答案。

我测试了它，它可以工作。

$wheres = array();
foreach ($filter as $fltr)
{
    $wheres[] = "('BookName' LIKE '%{$fltr}%'' OR 'BookDescription' LIKE '%{$fltr}%')";
}
$this->db->where( implode(' AND ', $wheres), null, false);
$records = $this->find_all();