Query Laravel Select WhereIn Array

Question

This query does not work correctly, it only shows 1 row

 $data = Post::select('id', 'name')
   ->whereIn('id', [$order])
   ->orderByRaw(\DB::raw("FIELD(id, $order)"))
   ->get();

but this works fine, it shows all rows

  $data = Post::select('id', 'name')
    ->whereIn('id', [1,2,3])
    ->orderByRaw(\DB::raw("FIELD(id, $order)"))
    ->get();

Thank you!

Yevgeniy Afanasyev · Accepted Answer · 2019-04-08 01:42:03Z

45

Your Query is Here:-

$data = Post::select('id', 'name')
  ->whereIn('id', $order)
  ->orderByRaw(\DB::raw("FIELD(id, ".implode(",",$order).")"))
  ->get();

Remove [] from $order.

For WhereIn condition second parameter should be an array. So the $order should be

$order = [1,2,3,4]

edited Apr 8, 2019 at 1:42

Yevgeniy Afanasyev

42k30 gold badges186 silver badges211 bronze badges

answered Jul 2, 2016 at 11:49

Rakesh Kumar

4,4522 gold badges19 silver badges30 bronze badges

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

10 Comments

Do Thanh Dat Over a year ago

This's my code $keys=array_keys($request->all()); $order=join(", ",$keys);

Rakesh Kumar Over a year ago

Use only this $order= array_values($request->all()); and (\DB::raw("FIELD(id, ".implode(",", $order).")")

Rakesh Kumar Over a year ago

use like this $order = array_values($request->all()) and \DB::raw("FIELD(id, ".implode(",", $order).")")

Rakesh Kumar Over a year ago

can u write o/t of $request->all() so we can debug.

Do Thanh Dat Over a year ago

Array ( [2] => 1 [3] => 4 [4] => 2 )

|

D.Dimitrioglo · Accepted Answer · 2016-07-02 12:53:53Z

12

If your $order is an array, i think that you should do this

whereIn('id', $order) instead of whereIn('id', [$order])

P.S. In official documentation mentioned that second argument should be an array:

$users = DB::table('users')
             ->whereIn('id', [1, 2, 3])
             ->get();

edited Jul 2, 2016 at 12:53

answered Jul 2, 2016 at 11:43

D.Dimitrioglo

3,6632 gold badges25 silver badges43 bronze badges

6 Comments

Do Thanh Dat Over a year ago

come on, see my first query :|

Do Thanh Dat Over a year ago

Here $keys=array_keys($request->all()); $order=join(", ",$keys);

Do Thanh Dat Over a year ago

Here Array ( [2] => 1 [3] => 4 [4] => 2 )

Do Thanh Dat Over a year ago

yes, i tried and had error Array to string conversion

Do Thanh Dat Over a year ago

Object of class Illuminate\Database\Eloquent\Builder could not be converted to string

|

Collectives™ on Stack Overflow

Query Laravel Select WhereIn Array

2 Answers 2

10 Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related