I'm trying to make a simple word game that has a database of words (which is preloaded or can be loaded by the user) that can be updated through website. I found this example and I got it to work. However, it wont work if I have an existing database. I'm new to this type of programming, so i've been doing research for 2 days now.

var db = openDatabase('db.sqlite', '1.0', 'Test DB', 2 * 1024 * 1024);
var msg;
/*
db.transaction(function (tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS vocabList(id unique, word, definition, weekNO)');
msg = '<p>Log message created and row inserted.</p>';
document.querySelector('#status').innerHTML =  msg;
});
*/ 

I mented this out to prevent creating the database (should i have not done that?)

db.transaction(function(tx) {
    tx.executeSql('SELECT * FROM vocabList WHERE weekNO = 1', [], function(tx, results) {
        var len = results.rows.length,
            i;
        msg = "<p>Found rows: " + len + "</p>";
        document.querySelector('#status').innerHTML += msg;
        for (i = 0; i < len; i++) {
            msg = "<p><b>" + results.rows.item(i).word + "</b></p>";
            document.querySelector('#status').innerHTML += msg;
        }
    }, null);
});

If there is another more efficient way to do this, please point me in the right direction.

I'm trying to make a simple word game that has a database of words (which is preloaded or can be loaded by the user) that can be updated through website. I found this example and I got it to work. However, it wont work if I have an existing database. I'm new to this type of programming, so i've been doing research for 2 days now.

var db = openDatabase('db.sqlite', '1.0', 'Test DB', 2 * 1024 * 1024);
var msg;
/*
db.transaction(function (tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS vocabList(id unique, word, definition, weekNO)');
msg = '<p>Log message created and row inserted.</p>';
document.querySelector('#status').innerHTML =  msg;
});
*/ 

I mented this out to prevent creating the database (should i have not done that?)

db.transaction(function(tx) {
    tx.executeSql('SELECT * FROM vocabList WHERE weekNO = 1', [], function(tx, results) {
        var len = results.rows.length,
            i;
        msg = "<p>Found rows: " + len + "</p>";
        document.querySelector('#status').innerHTML += msg;
        for (i = 0; i < len; i++) {
            msg = "<p><b>" + results.rows.item(i).word + "</b></p>";
            document.querySelector('#status').innerHTML += msg;
        }
    }, null);
});

If there is another more efficient way to do this, please point me in the right direction.

• javascript
• sqlite
• html

2 Answers 2

I'm not exactly sure what you're having problems with. But in your code, you mented out the part where it checks whether or not a table has been created. From that mented out code, there are no rows being inserted either, so it is a blank database.

I modified your code here: http://jsfiddle/Ae8m2/

I unmented out your creation part, and added a couple rows.

The database you are creating/connecting to is a client-side database. If you want to connect to a back-end database, you should use a server language, such as php.

You may want to use ajax with this, to connect to your database and execute your requests.