CODEWITHSUNDEEP
phpjsonlaravellaravel-5
Nitish Kumar
Nitish Kumar

Reputation: 6286

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)

Upvotes: 1

Views: 138

Answers (1)

Quynh Nguyen
Quynh Nguyen

Reputation: 3009

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

Upvotes: 3

Related Questions