Wednesday, March 15, 2017

How to pass array in where condition? Laravel 5.3

If I have data like this

For example, my table is country table

First data :

id = 1; name = england; deleted_by = 1, 3

Second data :

id = 2; name = spain; deleted_by = 2, 4

I try like this :

Country::whereIn('deleted_by', $user_id)->get(); 

But seems my case can not use whereIn

For example, I want to show data has an user_id = 1

How can I do it?

Note :

deleted_by = the data deleted by the user id

$user_id = user id that is being logged



via samuel toh

Advertisement