laravel where multiple input array

Question

i have an array like this :

array:2 [▼
0 => 1
1 => 2
]

and i have product table like this :

"id" => 1
    "nama" => "product1"
    "harga" => 100000
    "created_at" => "2021-05-01 15:21:08"
    "updated_at" => "2021-05-01 15:21:08"
  ]
"id" => 2
    "nama" => "product2"
    "harga" => 90000
    "created_at" => "2021-05-01 15:21:08"
    "updated_at" => "2021-05-01 15:21:08"
  ]
"id" => 3
    "nama" => "product3"
    "harga" => 80000
    "created_at" => "2021-05-01 15:21:08"
    "updated_at" => "2021-05-01 15:21:08"
  ]
 
 and more ...

i want to find product data using where id with multiple input, example :

array:2 [▼
0 => 1
1 => 2
]

the result : 

"id" => 1
"nama" => "product1"
"harga" => 100000
"created_at" => "2021-05-01 15:21:08"
"updated_at" => "2021-05-01 15:21:08"
]
 "id" => 2
 "nama" => "product2"
 "harga" => 90000
 "created_at" => "2021-05-01 15:21:08"
 "updated_at" => "2021-05-01 15:21:08"
 ]

is it possible? very happy when someone hepl and tell me how, thanks.

Localhousee · Accepted Answer · 2021-05-02 15:14:32Z

2

You can use whereIn from Query Builder. see Docs

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

answered May 2, 2021 at 15:14

Localhousee

9321 gold badge7 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

laravel where multiple input array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related