Reading & Transforming JSON Object into Javascript Array

Question

I want to transform a JSON object into an array.

Am using a PHP script to create a JSON file using this code:

$stores = array();
$i=0;
$reponse = $bdd->query('select * from store ');
while ($donnees = $reponse->fetch())
{
    $stores[$i] =  $donnees;
    $i++;
}

var_dump($stores);

$fp = fopen('results.json', 'w');
fwrite($fp, json_encode($stores));
fclose($fp);

In my JS file am using this code to load the data:

var json_obj = $.getJSON("results.json", function (data) {
    json_obj = data;
    return json_obj;
});

 alert(JSON.stringify(json_obj));

Now I want to transform my JSON object into a JavaScript array. But in specific way:

var props=[] ;

props.push({title:json_obj[0].name,Data:json_obj[0].Description});
props.push({title:json_obj[1].name,Data:json_obj[1].Description});


$.each(props, function (i,v)
{
  console.log(i,v);
});

Arrays in javascript MUST have numeric index, start at 0 and have no gaps. — Honk der Hase
– Honk der Hase, Commented Jul 20, 2016 at 17:48
it means: when you say "array[0].title" then the entry at offset 0 will become an object — Honk der Hase
– Honk der Hase, Commented Jul 20, 2016 at 19:10

Tim · Accepted Answer · 2016-07-20 20:42:35Z

2

Looks like you can simply parse the json into your var props to create the array object...

var props = JSON.parse(json_obj);

props is now a js array object built from parsing your json string...

EDIT: proposed change to your js file

var props = [];
$.getJSON("results.json", function (data) {
    $.each( data, function(index) {
        props.push({title:data[index].name,Data:data[index].Description});
    });
});

alert(props);

omit the rest of the code pushing to new array... just log out props...

edited Jul 20, 2016 at 20:42

answered Jul 20, 2016 at 17:48

Tim

1197 bronze badges

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

3 Comments

Abderrahman Msd Over a year ago

when used it it gave me VM2554:1 Uncaught SyntaxError: Unexpected token o in JSON at position 1

Tim Over a year ago

Sorry... Your getJSON function returns a json object via ajax... No need to map or parse... simply push the pieces into your new array per khem's advise... then you can log your array out to the console...

Abderrahman Msd Over a year ago

it says -- app.js:85 -- Uncaught TypeError: Cannot read property 'name' of undefined

khem poudel · Accepted Answer · 2016-07-21 03:32:06Z

0

You need to define array and push elements into it, why don't you try something like this

var someArray=[]
someArray.push({title:props[0].name,Data:props[0].Description})
someArray.push({title:props[1].name,Data:props[1].Description})

But its not a good idea if you donot know the length of props array

To convert json object into array you should loop through json object and push individual element into some array

var someArray = []
for(var key in json_object){
if(json_object.hasOwnProperty(key)){
   var tmpObj={title:json_object[key].name,Data:json_object[key].Description}
   someArray.push(tmpObj)
   console.log(someArray)
 }
}

Thanks

edited Jul 21, 2016 at 3:32

answered Jul 20, 2016 at 17:47

khem poudel

5877 silver badges13 bronze badges

4 Comments

Abderrahman Msd Over a year ago

i kinda understood you but how can i alert the content of the new array and see if it worked!

Honk der Hase Over a year ago

use console.log(), not alert

Abderrahman Msd Over a year ago

i used $.each(props, function (i,v) { console.log(i,v); }); but it says Uncaught TypeError: Cannot read property 'name' of undefined

Abderrahman Msd Over a year ago

sorry but it said app.js:84 Uncaught ReferenceError: json_object is not defined

Collectives™ on Stack Overflow

Reading & Transforming JSON Object into Javascript Array

2 Answers 2

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related