how to select from database using an array in condition in laravel

Question

I have an array called $slugs and I need to receive data form database table called posts in single array how to archive that ?

Why not use whereIn Post::whereIn('slug', $slugs)->get(); — Salman Zafar
– Salman Zafar, Commented May 28, 2019 at 20:38
Please add more informations and piece of code or pseudo code what you're actually trying to achieve. — harisdev
– harisdev, Commented May 28, 2019 at 20:40

Lakhwinder Singh · Accepted Answer · 2019-05-29 08:41:21Z

3

If I'm not wrong you have array of slugs like this ['slug', 'slug1', 'slug2'] and you want to get values from table where slugs matches your slugs array in a single query.

//Solution via eloquent
$slugs = ['slug', 'slug1', 'slug2'];

Post::whereIn('slug', $slugs)->get();

// Solution via Query builder
use Illuminate\Support\Facades\DB;

$slugs = ['slug', 'slug1', 'slug2'];
DB::table('posts')->whereIn('slug', $slugs)->get();

If you want to convert all your posts response to an array and then assign it to $slugs array you should use below solution

$posts = Post::all()->toArray();
$slugs[] = $posts;

To know more about whereIn visit

edited May 29, 2019 at 8:41

Lakhwinder Singh

5,5825 gold badges30 silver badges52 bronze badges

answered May 28, 2019 at 20:45

Salman Zafar

4,0655 gold badges23 silver badges44 bronze badges

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

Comments

Johhn · Accepted Answer · 2019-05-28 20:36:06Z

0

If am getting this right? You need to fetch your posts to an array called $slugs. Simply:

$slugs = Posts::all()->toArray();

answered May 28, 2019 at 20:36

Johhn

1,04918 silver badges29 bronze badges

Collectives™ on Stack Overflow

how to select from database using an array in condition in laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related