Laravel query to get results having at least one element of an array?

Question

I have posts and postWriters tables with one-to-many relationships. (I have also writers table).

Each post has been written by several writers collaboratively.

I want to get first 20 posts which have been written by at least one writer I follow.

For example the writers that I follow:

$arrayOfWriterIds_IFollow = [3, 5, 123, 45, ..., 3456] // total 100 ids

The query:

$posts = Post::where(
    array( 'postWriters' => function($l) {
        $l->whereIn('writer_id', $arrayOfWriterIds_IFollow); // or array(3, 5) for 2 writers..
    })
)
->orderBy('submitTimestamp', 'desc')
->take(20)
->get();

The query does not work.

Is this approach appropriate or should I add a dedicated table to evaluate my results?

I have some tables, one of them is followings table. I get $arrayOfWriterIds_IFollow from this table. — horse
– horse, Commented Feb 7, 2016 at 15:24
display your db structure and models ,there's no need to make 2 different queries for this task you can combine them into 1. — Gal Sisso
– Gal Sisso, Commented Feb 7, 2016 at 16:02
There are 3 tables related to question: posts, postWriters and writers. — horse
– horse, Commented Feb 7, 2016 at 16:06
@user2356198 if you expect an answer you would need to display them we cant guess the names of the columns — Gal Sisso
– Gal Sisso, Commented Feb 7, 2016 at 16:16

The Alpha · Accepted Answer · 2016-02-07 23:19:46Z

1

If your relationship is defined correctly then the fillowing code should work:

$posts = Post::whereHas('postWriters', function($query) use($arrayOfWriterIds_IFollow) {
    $query->whereIn('writer_id', $arrayOfWriterIds_IFollow);
})
->orderBy('submitTimestamp', 'desc')
->take(20)
->get();

answered Feb 7, 2016 at 23:19

The Alpha

147k30 gold badges294 silver badges313 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel query to get results having at least one element of an array?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related