Level 75
Properly format that code.
Feb 27, 2018
6
Level 1
Multiple select clauses not working properly in DB query
Hi, I'm running a query across 2 tables with unexpected results. When I use the following lines of code, the result ignores the clause "where users.userType = Student"
$searchword = Input::get ('q');
$student = \DB::table('userprofiles')->join('users', 'users.userName', '=', 'userprofiles.userName')->select('userprofiles.id','userprofiles.userName', 'userprofiles.fName', 'userprofiles.lName')->where('users.userType', '=', "Student")->where('userprofiles.userName', 'LIKE', '%' . $searchword . '%')->orwhere('userprofiles.fName', 'LIKE', '%' . $searchword . '%')->orwhere('userprofiles.lName', 'LIKE', '%' . $searchword . '%')->get();
I tried another method I found online:
$student = \DB::table('userprofiles')->join('users', 'users.userName', '=', 'userprofiles.userName')->select('userprofiles.id','userprofiles.userName', 'userprofiles.fName', 'userprofiles.lName')->where('users.userType', '=', "Student")->where(function($word){$word->where('userprofiles.userName', 'LIKE', '%' . $searchword . '%')->orwhere('userprofiles.fName', 'LIKE', '%' . $searchword . '%')->orwhere('userprofiles.lName', 'LIKE', '%' . $searchword . '%')})->get();
Then I get: FatalThrowableError Parse error: syntax error, unexpected '}'
What am I doing wrong?
Thanks.
Level 2
edit this code: '->orwhere('userprofiles.lName', 'LIKE', '%' . $searchword . '%')})->get();' to '->orwhere('userprofiles.lName', 'LIKE', '%' . $searchword . '%'); })->get();', you forget a ‘；’ before '}'.
1 like
Level 1
When I try adding the ';', I get an ErrorException Undefined variable: searchword
Also, how do I properly format the code in laracasts? Cos it keeps reverting to plaintext.
Thanks.
Level 47
@jayrec - Open with three backticks. (The ` character). Write your code. Then close with three backticks.
It's also been discussed on this thread: https://laracasts.com/discuss/channels/code-review/how-to-write-code-in-laracast
1 like
Level 1
Go to know, Thanks.
Level 1
I added an if condition ($user->userType == "Student") in the view and it worked.
Please or to participate in this conversation.