Adding Multiple Variables to a View in Laravel

Question

$header = DB::select("SELECT COLUMN_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tableOne'");
$secheader = DB::select("SELECT COLUMN_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tableTwo'");

$variables = DB::table('tableThird')->get();
$variables = json_decode(json_encode($variables, true));
$tbHeading = json_decode(json_encode($header, true)); //json object

return view('admin/crosstabdata', compact('secheader','tbHeading','variables'));

When I print all three variables to view (crosstabdata.blade.php) file, it said:

secheader variable does not exist.

Put your view code here please. And I think it's better to change the `admin/crosstabdata` to `admin.crosstabdata` in the last line. — Rouhollah Mazarei, Jan 15 '19 at 14:09

score 0 · Answer 1 · edited Jan 15 '19 at 14:19

0

Try this;

$header = DB::select("SELECT COLUMN_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tableOne'");
$data['secheader'] = DB::select("SELECT COLUMN_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tableTwo'");

$variables = DB::table('tableThird')->get();
$data['variables'] = json_decode(json_encode($variables, true));
$data['tbHeading'] = json_decode(json_encode($header, true));

return view('admin/crosstabdata', $data);

Hope this approach helps out.

edited Jan 15 '19 at 14:19

Kenny Horna

13,485
4
44
71

answered Jan 15 '19 at 12:18

petersowah

728
8
20

I need three variable to pass – Sarfaraz Jan 15 '19 at 12:25
From your code, which variables? I figured you’re sending secheader, variables and tbHeading – petersowah Jan 15 '19 at 12:28
What does `dd($secheader)` return? – petersowah Jan 15 '19 at 12:43
Undefined variable: secheader – Sarfaraz Jan 15 '19 at 12:48

score 0 · Answer 2 · edited Jan 15 '19 at 14:19

0

try this way:

return View::make('admin.crosstabdata')
           ->with(compact('secheader', 'tbHeading', 'variables'));

edited Jan 15 '19 at 14:19

Kenny Horna

13,485
4
44
71

answered Jan 15 '19 at 12:29

Ronak Bokaria

616
6
6

score 0 · Answer 3 · answered Jan 15 '19 at 14:17

Your code should work. Maybe the problem is in the view.

As an alternative, you can pass varaibles to your views like this:

$secheader = /** ... */;
$variables = /** ... */;
$tbHeading = /** ... */;

return view('admin.crosstabdata')
           ->with('secheader', $secheader)
           ->with('variables', $variables)
           ->with('tbHeading', $tbHeading);

Then in your view you can access them like $secheader, $variables & $tbHeading.

score 0 · Answer 4 · answered Jan 15 '19 at 17:29

0

You can pass an associative array to the with() method, so your return statement can look like this:

return view('admin/crosstabdata')->with(['secheader' => $secheader, 'tbHeading' => $tbHeading, ...]);

answered Jan 15 '19 at 17:29

Raed Yakoubi

332
3
8

score -1 · Answer 5 · answered Jan 15 '19 at 11:45

-1

i didn't try to pass three vatiables directly but here is a way to pass two variables

 return view('admin/crosstabdata', compact('secheader'))->with('tbHeading', $tbHeading);

also i saw this question in stack over flow i think it might help you its about making it as an array and passing it as one variable see here

Laravel - Pass more than one variable to view

answered Jan 15 '19 at 11:45

RYOK

473
7
23

I need multiple variable to pass into view. – Sarfaraz Jan 15 '19 at 12:00
will you can pass that variables throughmaking them as array and pass the array loop though it and loop each variable again and you get the resault see the link and you will understand – RYOK Jan 15 '19 at 19:11

Adding Multiple Variables to a View in Laravel

5 Answers5