目前,我正在Laravel上的一个项目上工作,但被卡住了。
SELECT * FROM SPITems WHERE publisher_id=? AND feed_id=? AND (title LIKE '%?%' OR description LIKE '%?%')
现在我有这段代码:
$query = SPItem::orderBy('title'); if(isset($_GET['publisherID']) && is_numeric($_GET['publisherID'])) { $query = $query->where('publisher_id', $_GET['publisherID']); } if(isset($_GET['productFeedID']) && is_numeric($_GET['productFeedID'])) { $query = $query->where('program_id', $_GET['feedID']); } if(isset($_GET['search'])) { $query = $query->orWhere('title', 'like', '%' . $_GET['search'] . '%'); $query = $query->where('description', 'like', '%' . $_GET['search'] . '%'); }
但这会产生:
SELECT * FROM SPITems WHERE (publisher_id=? AND feed_id=?) OR (title LIKE '%?%') AND description LIKE '%?%'
如何获得正确的“或”订单?
在文档中查看“ 参数分组” 部分:
https://laravel.com/docs/master/queries#parameter- grouping
它说明了如何在WHERE子句中对条件进行分组。
应该是这样的:
if(isset($_GET['search'])) { $query = $query->where(function($query){ $query->where('title', 'like', '%' . $_GET['search'] . '%') ->orWhere('description', 'like', '%' . $_GET['search'] . '%'); }); }