dongye7231 2017-05-23 10:37
浏览 349
已采纳

使用orwhere子句的Laravel eloquent orm查询

Hi I have been using this query to retrieve data based on orWhere clause

$q->where('created', $date);
$q->where(function ($query) {
  $query->where('gender', 'Male')
        ->where('age', '>=', 18);
})->orWhere(function($query) {
  $query->where('gender', 'Female')
        ->where('age', '>=', 30);   
})->orWhere(function($query) {
  $query->where('gender', 'Orthodox')
        ->where('age', '>=', 35);

first orWhere clause is working perfectly, however 2nd isnt. It seems to be a scope issue, i.e something with ()

  • 写回答

2条回答 默认 最新

  • doujimiao7480 2017-05-23 10:45
    关注

    Group your conditions properly and it should be fine.

    $q->where('created', $date);
    $q->where(function ($query) {
        $query->where(function ($query) {
            $query->where('gender', 'Male')
                ->where('age', '>=', 18);
        })->orWhere(function ($query) {
            $query->where('gender', 'Female')
                ->where('age', '>=', 30);
        })->orWhere(function ($query) {
            $query->where('gender', 'Orthodox')
                ->where('age', '>=', 35);
        });
    });
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?