Populate database with json in JavaScript

Question

I have a JSON String in a JavaScript var, how I can loop through JSON string to make script like this output?

INSERT INTO table VALUES ('$var1', '$var2', '$var3', '$varN');

Is there is any direct way to fill a table from a json string?

JSON Example:

{"table":[{"id":"1","name":"David","nick":"falk","year":"20"},{"id":"2","name":"Mark","nick":"master","year":"50"},{"id":"3","name":"jhon","nick":"jx","year":"20"},{"id":"4","name":"Maria","nick":"beauty","year":"20"}]}

I edited the question to add the example. Refresh the page, please. — candlejack
– candlejack, Commented Mar 19, 2014 at 4:27

ncubica · Accepted Answer · 2014-03-19 04:59:56Z

2

We assign a variable name to the json object

var table = {"table":[{"id":"1","name":"David","nick":"falk","year":"20"},{"id":"2","name":"Mark","nick":"master","year":"50"},{"id":"3","name":"jhon","nick":"jx","year":"20"},{"id":"4","name":"Maria","nick":"beauty","year":"20"}]};

Using jquery

loop over the variable table which have the property table.

 $.each(table.table,function(index, item){
    //INSERT INTO table VALUES ('$var1', '$var2', '$var3', '$varN');     
     console.log("INSERT INTO table VALUES('"+ item.id + "','"+ item.name + "','"+ item.nick + "','"+ item.year +"')");
});

take a look in jsfiddle http://jsfiddle.net/628Cb/

edited Mar 19, 2014 at 4:59

answered Mar 19, 2014 at 4:38

ncubica

8,53510 gold badges58 silver badges74 bronze badges

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

1 Comment

candlejack Over a year ago

I got an error: Uncaught TypeError: Cannot read property 'length' of undefined But I fixed: table= JSON.parse(table); Thanks!

Aks · Accepted Answer · 2014-03-19 04:36:03Z

1

You can use the for loop to iterate over the array contained by the table object.

var p = {"table":[{"id":"1","name":"David","nick":"falk","year":"20"},{"id":"2","name":"Mark","nick":"master","year":"50"},{"id":"3","name":"jhon","nick":"jx","year":"20"},{"id":"4","name":"Maria","nick":"beauty","year":"20"}]};
 var arr = p["table"];
 for(var i=0;i<arr.length;i++){
    var obj = arr[i];
    alert(obj["id"] + " "+ obj["name"] + " "+ obj["nick"]+ " "+obj["year"]);   
    INSERT INTO table VALUES (obj["id"], obj["name"], obj["nick"], obj["year"]);   
}

answered Mar 19, 2014 at 4:36

Aks

1,58713 silver badges23 bronze badges

Collectives™ on Stack Overflow

Populate database with json in JavaScript

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related