php - Laravel Eloquent WHERE and AND -


i have comment table id, privacy(0,1,2), comment_body columns

i using larvael 4.2.x eloquent result. trying comment privacy of 0 , 1 one user.

what have tried?

option 1

$user  = user::find(1);  //query give me comment privacy = 0 $comment_for_user = $user->comments()->where('privacy','0'); 

option 2

//this wont return $comment_for_user = $user->comments()->where('privacy','0')                                     ->where('privacy',1); 

option 3

//return result gets post form users  $comment_for_user = $user->comments()->where('privacy','0')                                     ->orwhere('privacy',1); 

thanks help.

you can use wherein.

$comment_for_user = $user->comments()->wherein('privacy', array(0, 1))->get(); 

you can find more useful methods in documentation.


Comments

Popular posts from this blog

angularjs - ADAL JS Angular- WebAPI add a new role claim to the token -

php - CakePHP HttpSockets send array of paramms -

node.js - Using Node without global install -