Decode json and display in table

Question

I have a HotUKDeals API which when using the URL bellow gives me some JSON. Im trying to use PHP to display it in a table but if i try and use a loop to go through the JSON i get errors.

If i try and decode i get "Object of class stdClass could not be converted to string"

So far I have this which i no gets the json and stores it in the variable .

I also have some JS which will go through JSON and put it in a table , but im having difficulties getting the JSON in the php variable into the JS.

Needed to remove code for work reasons !

Is the URL valid? I've tried to open that in my browser and it redirected me onto another page. — Voreny, Feb 01 '16 at 21:59
You need to [`parseJSON()`](http://api.jquery.com/jquery.parsejson/) — Jay Blanchard, Feb 01 '16 at 22:03

Jay Blanchard · Accepted Answer · 2016-02-01T22:56:13.067

0

To get the JSON into your jQuery code you'll have to use AJAX:

PHP file -

<?php 
    $tester = file_get_contents('http://api.hotukdeals.com/rest_api/v2/?key=d2c088ea340558b3b3517396963a341c&results_per_page=2&output=json');
    echo $tester;
?>

jQuery AJAX -

$.get( "hotukdeals.php", function( data ) {
    // now you can work with `data`
    var JSON = jQuery.parseJSON( data ); // it will be an object
    $.each(JSON.deals.items, function( index, value ) {
       console.log( value.title + ' ' + value.description );
    });
});

NOTE: The JSON that is returned has complex construction, so you will have to take care about how you extract during the loop and then place in the table.

edited Feb 01 '16 at 22:56

answered Feb 01 '16 at 22:08

Jay Blanchard

34,243
16
77
119

so the javascript i have can go into the ajax? – JohnyChew Feb 01 '16 at 22:10
You'll have to modify it to use object notation, like `JSON[i].title` @JohnyChew – Jay Blanchard Feb 01 '16 at 22:11
iv modified the JavaScript to have the json var name , but the output is blank . I also dont get any errors in teh console. – JohnyChew Feb 01 '16 at 22:16
I think the var is empty – JohnyChew Feb 01 '16 at 22:17
the JSON var i think – JohnyChew Feb 01 '16 at 22:18
how do i get the json aobject to a string – JohnyChew Feb 01 '16 at 22:19
It is a string when it comes from the PHP – Jay Blanchard Feb 01 '16 at 22:19
The table is not filling its self . Also i tried this document.getElementById("test").innerHTML = JSON; and the div says [object JSON] in it – JohnyChew Feb 01 '16 at 22:22
You have to parse and loop. It is possible that the JSON is not coming back in a format that you expect. – Jay Blanchard Feb 01 '16 at 22:22
You can use a for loop, or jQuery's `$.each` – Jay Blanchard Feb 01 '16 at 22:43
I tried this but didnt work - $.each(JSON, function(i, item) { alert(JSON[i].title); }); – JohnyChew Feb 01 '16 at 22:50
That worked ! Now to get it to work with the js code for the table – JohnyChew Feb 01 '16 at 22:58
one final question . How can i parse the json as UTF-8 to remove the weird characters? – JohnyChew Feb 02 '16 at 14:11
[Read this](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) @JohnyChew – Jay Blanchard Feb 02 '16 at 14:50
@JohnyChew you may want to create another question for this. Make sure to be specific and provide sample code. I am tied up and don't want you to have to wait for an answer. – Jay Blanchard Feb 02 '16 at 15:39

Decode json and display in table

1 Answers1