Variable scope inside php function

Question

I'm doing an excel file export from an eloquent model using Laravel and Maatwebsite/Laravel-Excel.

Here's what I have

 public function export(Request $request)
    {
        $data = $this->getData($param1)->get();
        $export = Excel::create('example' . date('m-d-Y-G-His'), function ($excel) {
            $excel->setDescription('example');
        });

        $export->sheet('Example', function ($sheet) {
            $sheet->row(1, array(
                'row1',
                'row2',
                'row3'
            ));

            $i = 2;
            foreach ($data as $d) {
                $sheet->row($i, array(
                    $d->id,
                    $d->name, $d->date,
                ));
            }
        });
    }

And I get Undefined variable: data

I understand that is a scope problem and the error is correct, but what is the best way to pass the variable inside the function?

tkausl · Accepted Answer · 2016-06-24 03:02:19Z

1

You can ask PHP to make it available in the anonymous function with the use keyword:

$export->sheet('Example', function ($sheet) use ($data) {

answered Jun 24, 2016 at 3:02

tkausl

14.4k3 gold badges37 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Variable scope inside php function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related