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