当前位置: 动力学知识库 > 问答 > 编程问答 >

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

问题描述:

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.

网友答案:

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:

分享给朋友:
您可能感兴趣的文章:
随机阅读: