Skip to content

Instantly share code, notes, and snippets.

@akshay-bhardwaj
Created February 7, 2014 08:49
Show Gist options
  • Save akshay-bhardwaj/8859218 to your computer and use it in GitHub Desktop.
Save akshay-bhardwaj/8859218 to your computer and use it in GitHub Desktop.
var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);
var tempFunc = function(){
db.transaction(function (tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS LOGS (id unique, log)');
tx.executeSql('INSERT INTO LOGS (id, log) VALUES (1, \"foobar\")');
tx.executeSql('INSERT INTO LOGS (id, log) VALUES (2, \"logmsg\")');
msg = '<p>Log message created and row inserted.</p>';
console.log(msg);
});
db.transaction(function (tx) {
tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) {
var len = results.rows.length, i;
msg = '<p>Found rows: ' + len + '</p>';
var temp = temp + msg;
console.log(temp);
}, null);
});
return true;
};
tempFunc();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment