Iterate through array and insert into websql

Question

I have a bunch of data in an array that I want to insert into websql. To do this I have tried the following but it just crashs the browser...

  while (i != data_lines)
   {
   db.transaction(function (tx) 
   {
   tx.executeSql('INSERT INTO  ' + tablename + ' (column1 column2. column3) VALUES (?, ?, ?)',[arrData[i][0],arrData[i][1],arrData[i][2]],
   i++)
   });
   }

As well as...

   while (i != data_lines)
   {
   i++
   db.transaction(function (tx) 
   {
   tx.executeSql('INSERT INTO  ' + tablename + ' (column1 column2. column3) VALUES (?, ?, ?)',[arrData[i][0],arrData[i][1],arrData[i][2]])
   });
   }

In this example i is set to the maximum record without iterating through. What would be the best method to perform this?

Kyaw Tun · Accepted Answer · 2013-11-27 01:27:02Z

1

Loop over request

db.transaction(function (tx) {
while (i != data_lines) {
     i++
       tx.executeSql('INSERT INTO  ' + tablename + ' (column1 column2. column3) VALUES (?, ?, ?)',[arrData[i][0],arrData[i][1],arrData[i][2]])
     });
}

answered Nov 27, 2013 at 1:27

Kyaw Tun

13.3k15 gold badges59 silver badges84 bronze badges

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

Collectives™ on Stack Overflow

Iterate through array and insert into websql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related