Why Laravel query returns empty array?

Question

I'm using Laravel query builder to retrieve results from db but it shows me empty array but whenever i use raw query it shows me results. Any solutions?

RAW query (showing results)

$work_query = 'SELECT * FROM work_availability WHERE EmployeeID = ' . $id . ' AND Position LIKE "%' . $r->position . '%" AND Type = "' . $r->first_time_type . '"';

Laravel Query builder (return empty array)

$work_first_time = DB::table('work_availability')
        ->where('EmployeeID', $r->id)
        ->where('Position', 'LIKE', " % $r->position % ")
        ->where('Type', '"'.$r->first_time_type.'"')
        ->get()->toArray();

John Lobo · Accepted Answer · 2021-06-18 07:23:12Z

2

Try this

1.Error is in ->where('Type', '"'.$r->first_time_type.'"'). quotes not required in laravel 2.Erorr in ->where('Position', 'LIKE', " % $r->position % ")

You can use here two ways

->where('Position', 'like', "%{$r->position }%")

or

->where('Position', 'like', "%".$r->position."%")

So Final code will be

$work_first_time = DB::table('work_availability')
        ->where('EmployeeID', $r->id)
        ->where('Position', 'like', " %{$r->position}% ")
        ->where('Type', $r->first_time_type)
        ->get()->toArray();

edited Jun 18, 2021 at 7:23

answered Jun 18, 2021 at 7:19

John Lobo

15.4k2 gold badges18 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

ZaIn Ul AbiDeen Sān Over a year ago

Still gives empty array

John Lobo Over a year ago

can you show what you get in dd($r->all()); and try to use like smaller one.

ZaIn Ul AbiDeen Sān Over a year ago

[ "id" => "1047" "position" => "Care Assistant,Live In" "first_time_days" => "Friday" "second_time_days" => "Saturday" "daysit_days" => null "sleepin_days" => null "first_time_type" => "06:45-15:00" "second_time_type" => "15:00-21:45" "other_type" => "Other" "daysit_type" => "DaySit" "sleepin_type" => "SleepIn" "week_type" => "Weeks" "waking_type" => "WakingNight" "other_data" => "nonef" "week_data" => "10" "AnnualLeave" => "Yes" "AnnualLeaveDates" => "19-10-2020,21-10-2020,23-10-2020" ]

ZaIn Ul AbiDeen Sān Over a year ago

The result of dd($r->all()); no problems with that one

John Lobo Over a year ago

try this ->where('Position', 'like', "%".$r->position."%")

|

Collectives™ on Stack Overflow

Why Laravel query returns empty array?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related