dongxiangxie8181 2016-11-07 21:33
浏览 52
已采纳

如何在laravel 5中编写此查询

I'm experiencing difficulty in writing this query in laravel 5.1,

select * from `host_requests` where `host_id` = 5 and (`email` LIKE "%v%" or `request_url` LIKE "%v%")

The purpose of this query is to fetch records that are associated with host_id = 5, also email and request_url are optional if they set then LIKE clause should be used. I wrote the query in laravel like this

$searchname = "v";
$hostid = "5";
$data = HostRequest::where('email', 'LIKE', '%' . $searchname . '%')
                ->where('host_id', $hostid)
                ->orwhere('request_url', 'LIKE', '%' . $searchname . '%')
                ->latest('id')
                ->paginate($size);

It is fetching all the records that are also not associated with host_id = 5.

Any help is much appreciated..Thanks

  • 写回答

2条回答 默认 最新

  • duan36000 2016-11-07 21:39
    关注

    You should use where() with closure like this:

    $data = HostRequest::where('host_id', $hostid)
                   ->where(function($q) use($searchname) {
                       $q->where('email', 'like', '%'.$searchname.'%')
                         ->orWhere('request_url', 'like', '%'.$searchname.'%');
                   })->orderBy('id', 'desc')
                   ->paginate($size);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)
编辑
预览

报告相同问题?

手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部