Passing array to view in Laravel(php)

Question

I am trying to pass an array to blade view in Laravel. Here is my code in controller:

$event_nav= array();
       $event_nav[] = DB::table('tr_visit')
           ->join ('tm_child','tr_visit.Child_ID','=','tm_child.Child_ID')
           ->where('tr_visit.Child_ID', 'LIKE', '%' . $childName . '%')
           ->select(DB::raw('YEAR(Visit_Date)'))
           ->distinct()
           ->get();
 return view('ProfilAnak.BmiAnak.seeBmi',compact('event_nav'));

and here is my view:

    @foreach($event_nav as $year)
       {{$event_nav[0]}}
    @endforeach

I'm getting following error message :

"htmlentities() expects parameter 1 to be string, array given"

can anyone help?

open source guy · Accepted Answer · 2015-08-11 04:34:52Z

1

you have to do something like this

@foreach($event_nav[0] as $year)
       {{$year->Child_ID}}
       {{$year->blah}}
@endforeach

answered Aug 11, 2015 at 4:34

open source guy

2,78710 gold badges40 silver badges62 bronze badges

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

3 Comments

Anita Intansia Hutagaol Over a year ago

in @event_nav i just want select Year of Visit Date.. so how can i make it in view? {{$year->Visit_Date}} not working

open source guy Over a year ago

->select(DB::raw('YEAR(Visit_Date) AS Visit_Date'))

Anita Intansia Hutagaol Over a year ago

Thanks for that - I'll change it.

Narendrasingh Sisodia · Accepted Answer · 2015-08-11 04:55:53Z

1

What you were doing over here is same as echoing an array using echo so you need to update your code as

@foreach($event_nav as $year)
   {{$year->Visit_Date}}
@endforeach

answered Aug 11, 2015 at 4:55

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

Comments

M0rtiis · Accepted Answer · 2015-08-11 04:59:29Z

0

replace

->select(DB::raw('YEAR(Visit_Date)'))

with

->select(DB::raw('YEAR(Visit_Date) AS Visit_Date'))

and in view do this

@foreach($event_nav as $year)
   {{$year->Visit_Date}}
@endforeach

like @Narendra Sisodia said

answered Aug 11, 2015 at 4:59

M0rtiis

3,7611 gold badge17 silver badges22 bronze badges

1 Comment

Anita Intansia Hutagaol Over a year ago

Thanks for that - I'll change it.

Collectives™ on Stack Overflow

Passing array to view in Laravel(php)

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related