How to fetch JSON array in Laravel

Question

I've a model in the name of Template and migration table in the name of templates, and i'm having a column name of templatedata in the mysql table which is holding the JSON array, while trying to fetch data in the view I'm getting an error,

Following is my controller:

 public function get_template($id) { $gettemplate = Template::findOrFail($id); return view('nitseditor.theme', ['gettemplate' => $gettemplate]); }

I'm trying to fetch the object like this:

@foreach($gettemplate as $template) <div class="branding"> <h1 class="logo"> <a href="index.html"><img src="{{ URL::asset($template->templatedata.content.logoimage) }}" alt="" width="25" height="26">NitsEditor</a> </h1> </div> @endforeach

and following is my JSON format in table:

[{ "content": { "logo": { "logoimage": "img/home/nitseditorlogo.png", "logolink": "index.html" }, "pages": [ {"pagename": "Mysite", "pagelink": "index.html"}, {"pagename": "Templates", "pagelink": "templates.html"}, {"pagename": "About Us", "pagelink": "aboutus.html"}, {"pagename": "Contact Us", "pagelink": "contactus.html"} ] } }]

I'm getting following error:

Trying to get property of non-object (View: location of blade)

Why are you looping $gettemplate when it's only 1 record when you fetch it with findOrFail($id)? — thefallen
– thefallen, Commented Jul 19, 2016 at 10:45
@TheFallen I made it for pagename and pagelink, I mean, for that I need to loop. — Nitish Kumar
– Nitish Kumar, Commented Jul 19, 2016 at 10:47
My point is that if you loop $gettemplate which is a single record, you'll be looping the properties of the Template object, which are not objects and that's why you're getting an error. — thefallen
– thefallen, Commented Jul 19, 2016 at 10:50
@TheFallen, even if I remove @foreach and try accessing like this $gettemplate->templatedata->content->logo->logoimage I'm getting the same error. — Nitish Kumar
– Nitish Kumar, Commented Jul 19, 2016 at 10:53
Please explain what are templatedata, content, logo, logoimage and how are they related to the Template object. — thefallen
– thefallen, Commented Jul 19, 2016 at 10:54

Nitish Kumar · Accepted Answer · 2016-07-19 13:31:49Z

3

Try this bro

$data_string = '[{ "content": { "logo": { "logoimage": "img/home/nitseditorlogo.png", "logolink": "index.html" }, "pages": [ {"pagename": "Mysite", "pagelink": "index.html"}, {"pagename": "Templates", "pagelink": "templates.html"}, {"pagename": "About Us", "pagelink": "aboutus.html"}, {"pagename": "Contact Us", "pagelink": "contactus.html"} ] } }]'; $template = json_decode($data_string); echo $template[0]->content->logo->logoimage.'<br>'; echo $template[0]->content->pages[0]->pagename;

Result

img/home/nitseditorlogo.png Mysite

edited Jul 19, 2016 at 13:31

Nitish Kumar

6,30722 gold badges88 silver badges160 bronze badges

answered Jul 19, 2016 at 10:48

Quynh Nguyen

3,0172 gold badges16 silver badges28 bronze badges

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

5 Comments

Nitish Kumar Over a year ago

Thanks for the update while returning $template I get the JSON, but as soon as I do $template->content I get the same error.

Nitish Kumar Over a year ago

I'm getting the JSON return having the content inside big bracket [{ }], your JSON contents are within {}, wherever I've seen the example for the contents [{ }] we have to place an array, for example in the above answer you have taken pages[0], I tried calling through template[0]->content, as you can see in my question the JSON contents are within [ ] now I'm getting the error The Response content must be a string or object implementing __toString(), "object" given.

Quynh Nguyen Over a year ago

Your JSON is an array? Right?

Nitish Kumar Over a year ago

Yes, it is an array.

Nitish Kumar Over a year ago

found out the solution, thanks for the help. I've edited the answer!

Collectives™ on Stack Overflow

How to fetch JSON array in Laravel

1 Answer 1

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Related