WhereIN query returns null in laravel?

Question

I am trying to find the number of user with WhereIN query, I tested with three types 1st two return user correctly but when I use the variable instead of direct data then it returns null

$userss = User::where('id',Auth::user()->id)->first();

        $membership = Ppv::whereIN('membership_id',[3])->count();
       dd( $membership);//its returns user correctly



 $membership = Ppv::where('membership_id',$userss->membership_id)->count();
           dd( $membership); // also return users correctly

but when i use it in whereIN query it returns null

$userss = User::where('id',Auth::user()->id)->first();
    $membership = Ppv::whereIN('membership_id',array($userss->membership_id))->count();
   dd( $membership); // retruns null or 0

I don't understand why you would use whereIn for an array with one item. — Dan
– Dan, Commented Jul 7, 2020 at 11:35
@rkg i am consudering both same. both are not working as well — Alex
– Alex, Commented Jul 7, 2020 at 11:38
@Dan in membership_id comlum values are stored in array format with implode — Alex
– Alex, Commented Jul 7, 2020 at 11:41

Kurt Friars · Accepted Answer · 2020-07-07 11:57:01Z

3

You are using $userss, like it is an id. It is not. It is a User model. If you want to use it how you described, you need:

    $membership = Ppv::whereIn('membership_id',[ $userss->membership_id ])->count();

But if you are going to take first(), from User, you should just do:

    $membership = Ppv::where('membership_id',$userss->membership_id)->count();

edited Jul 7, 2020 at 11:57

answered Jul 7, 2020 at 11:43

Kurt Friars

3,7742 gold badges18 silver badges29 bronze badges

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

5 Comments

Alex Over a year ago

not worked i also tried i am also confused. but when i insert data directly it works

Kurt Friars Over a year ago

Please edit your question with your solution please, to help other users.

Alex Over a year ago

your last update also not fits because i need in arrray,, but thanks alot , i will always remeber it

Kurt Friars Over a year ago

It is an array: whereIn('membership_id',[ $userss->membership_id ])

Kurt Friars Over a year ago

Post your solution

Roshan Karki · Accepted Answer · 2020-07-07 12:10:29Z

0

$user = User::where('id',Auth::user()->id)->first();

Please check the value of $user->membership_id;

return Ppv::whereIN('membership_id',[$user->membership_id])->count();

answered Jul 7, 2020 at 12:10

Roshan Karki

12 bronze badges

Collectives™ on Stack Overflow

WhereIN query returns null in laravel?

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related