duanhaodi4809 2018-08-16 00:27
浏览 2290
已采纳

Laravel Query使用with()语句

Having trouble trying to use the with statement on a query as shown here

thePage::select('field1','field2')
->with('pagePhotos')

This query works fine, but what if I want to only get pagePhotos where the photoLocation="Miami". This photoLocation field is not on thePage Model, and only on the pagePhotos table.

Below is a stab in the dark that doesn't work but it shows the logic I'm trying to get at, I hope!

thePage::select('field1','field2')
->with(
    'pagePhotos'->where('photoLocation','=','Miami')
)->get();

EDIT

In addition to the answer / comments here I found this helped me get the query perfect https://stackoverflow.com/a/41436703/7675570

Just in case anyone has similar scenarios it could help.

  • 写回答

2条回答 默认 最新

  • dousha7904 2018-08-16 00:31
    关注

    Use whereHas:

    thePage::select('field1','field2')
        ->with('pagePhotos')
        ->whereHas('pagePhotos', function($query) {
            $query->where('photoLocation', '=', 'Miami');
        })
        ->get();
    

    Laravel Querying Relationship Existence

    Edit:

    If you want to be selective on the pagePhotos fields, instead of

    ->with('pagePhotos')
    

    do

    ->with('pagePhotos' => function($query) {
        $query->select('field1', 'field2');
    })
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?