mercredi 8 avril 2020

im having problem with join on multi table in laravel

working on group chat web app with laravel

i want to perform search for user on particular group with their name

so basically there are three table

users -> id , timeline_id , email , pw

timelines -> id , fname , lname , p_no

page_user(defines user on particular group/page) -> id , page_id , user_id

page -> id , timeline_id, pg_name

when i perform search on one selected group , query giving search from whole user not from selected group

`$page_members= DB::table('timelines')`
     `->join('users', 'timelines.id', '=', 'users.timeline_id')`    
     `->where('timelines.fname','LIKE','%'.$q.'%')`        ``
     `->orWhere('timelines.lname','LIKE','%'.$q.'%')`
     `->orWhere('users.email','LIKE','%'.$q.'%')`
     `->orderby('users.id', 'DESC')`
     `->get();`

where i need to do change ; considering that $page_id = 1; $q is search value;



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire