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.