Laravel controller error: Undefined variable

Question

In my Laravel controller, it keeps saying error like this.

[2019-10-29 11:13:57] local.ERROR: Undefined variable: target_date

{"userId":2,"exception":"[object] (ErrorException(code: 0): Undefined variable: target_date at

/home/ljw/public_html/byappscms/app/Http/Controllers/ChartController.php:78)

However, in my controller file, the variable EXIST.

ChartController.php

public function onGetAppDailyChartData(Request $request)
{

    info("~~~~~~~~~~~" . $request->date);
    $target_date = strtotime($request->date);
    info("~~~~~~~~~~~" . $target_date);

    $appsTotal = AppsData::where('app_process', '=', '7')
        ->where(function ($query) {
            $query->where('service_type', '=', 'lite')
                ->orWhere('end_time', '>', $target_date);
        })
        ->count();
}

And I checked the log, the values printed well. They printed the date and the UNIX timestamp.

What possibly cause this error here?

line 78 is that the orWhere clause or the info()?

Loko
– Loko

2019-10-29 11:23:07 +00:00
Commented Oct 29, 2019 at 11:23 — Loko
– Loko, Commented Oct 29, 2019 at 11:23
The line 78 is orWhere line.

Julian
– Julian

2019-10-29 11:23:57 +00:00
Commented Oct 29, 2019 at 11:23 — Julian
– Julian, Commented Oct 29, 2019 at 11:23

Salim Djerbouh · Accepted Answer · 2019-10-29 11:23:20Z

4

The variable is outside the scope of closure functions, introduce it with use

$appsTotal = AppsData::where('app_process', '=', '7')
                    ->where(function($query) use ($target_date) { // <--- Here
                      $query->where('service_type', '=', 'lite')
                            ->orWhere('end_time', '>', $target_date);
                    })
                    ->count();

Hope this helps

answered Oct 29, 2019 at 11:23

Salim Djerbouh

11.1k6 gold badges35 silver badges65 bronze badges

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

1 Comment

Julian Over a year ago

Oh wow. Fantastic! Thank you very much. I'll accept this answer 6min later.

Collectives™ on Stack Overflow

Laravel controller error: Undefined variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related