vendredi 16 novembre 2018

Laravel Query builder query equivalent to SQL query?

I query is working fine only problem in this where clause. plz tell me what will query builder query in laravel, equivalent to this query

WHERE (interest_request.sender_id = 6 or interest_request.to_user_id = 6) 
AND interest_request.interest_status =2 
and profiles.profile_id not in (6)

I am using following query builder but not working

where('to_user_id',$my_profile_id)->orwhere
('sender_id',$my_profile_id)->where('interest_status','2')
->whereNotIn('profiles.profile_id', $my_profile_id) 



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire