Adding values dynamically to the table in Web SQL database using javascript

Question

I am fetching values from web service. And I have to insert those values into the table in Web SQL database.

I have 4 records. I have inserted the following code into the loop, but only the last record is added in database and not the first 3 records.

for(var t=0;t<main_category.length;t++){
        db.transaction(function(tx){
            var insertStatement="INSERT INTO main_menu(catId,catName,catImage) VALUES(?,?,?)";
            tx.executeSql(insertStatement, [menu_id, menu_name, menu_img]);
            console.log("values inserted "+ t);
        });
}

I tried many solutions, following link has one of them,

Web SQL Database + Javascript loop

But, it did not work. Please suggest me how can I populate the table with dynamic values.

ssut · Accepted Answer · 2014-07-08 06:36:38Z

2

try this:

for(var t = 0; t < main_category.length; t++){
        (function(i) {
            var item = main_category[i];
            var menu_id = item.id, menu_name = item.name, menu_img = item.img;
            db.transaction(function(tx) {
                var insertStatement="INSERT INTO main_menu(catId,catName,catImage) VALUES(?,?,?)";
                tx.executeSql(insertStatement, [menu_id, menu_name, menu_img]);
                console.log("values inserted "+ i);
            });
        })(t);
}

result:

edited Jul 8, 2014 at 6:36

answered Jul 8, 2014 at 5:48

ssut

4412 silver badges8 bronze badges

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

3 Comments

Deepika Over a year ago

but the values are not getting inserted in the table in database.

ssut Over a year ago

i am working this code.. puu.sh/a1Lds/d72bb5e8d3.png , so which browser are you using?

Deepika Over a year ago

Aah! made slight changes, its working just the catNames and catImages are having issues, all values are getting inserted there in first row then decrement by 1 in second row and so on.

Collectives™ on Stack Overflow

Adding values dynamically to the table in Web SQL database using javascript

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related