Nitish Kumar Nitish Kumar - 4 months ago 12
PHP Question

How to fetch JSON array in Laravel

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)

Answer

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