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