Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onDeviceReady() {
- document.addEventListener("backbutton", onBackKeyDown, false);
- db = window.openDatabase("myLocalDB", "1.0", "Users", 200000);
- db.transaction(populateDB, errorCB, successCB);
- }
- function errorCB(tx, error) {
- console.log("In Error Function");
- alert("Database Error: " + error);
- }
- function successCB() {
- dbCreated = true;
- console.log("Successfully inserted");
- }
- function populateDB(tx) {
- var sql1 = 'CREATE TABLE IF NOT EXISTS Users (id INTEGER PRIMARY KEY, idNumber, uName varchar(255))';
- var sql2 = 'CREATE TABLE IF NOT EXISTS Sample1 (id INTEGER PRIMARY KEY, dId INTEGER, Name varchar(255), desc varchar(255), imgPath varchar(255))';
- var sql3 = 'CREATE TABLE IF NOT EXISTS Sample2 (id INTEGER PRIMARY KEY, storeId INTEGER, storeName varchar(255))';
- tx.executeSql(sql1);
- var test = new Array();
- for(var i = 0; i < 10; i++) {
- (function(i){
- test[i]="INSERT INTO Users (id, idNumber, uName) VALUES (i,i,'test')";
- })(i);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement