search by firstname or lastname or nickname

Please i have this and am able to search by fistname only i want to search by lastname and nickname which are also found in my database, how do i do that? $member = Request::get('keyword'); DB::select("SELECT * FROM members WHERE firstname LIKE '%".$member."%' ");

veve286

10 years ago

Best Answer

Level 8

why dont you use orWhere( )? Easy in eloquent way


 $member = Request::get('keyword');
$members=App\Member::where('firstname','like',"$member%")->orWhere('lastname','like',"$member%")->orWhere('nickname','like',"$member%")->get( );

1 like

nanadjei2

10 years ago

Level 4

thanks man

Please or to participate in this conversation.