T98w1huM

1window.onload = function () {
2    var db = openDatabase('my-dbo', '1.0', 'My DB', 10 << 20);
3
4    db.transaction(function (tr) {
5        tr.executeSql('' +
6            'CREATE TABLE IF NOT EXISTS ' +
7            'users(' +
8            '   id INT PRIMARY KEY,' +
9            '   name VARCHAR(255),' +
10            '   password VARCHAR(255)' +
11            ')'
12        );
13    });
14
15    document.getElementById('btn-login').onclick = function () {
16        var name = document.getElementById('name').value;
17        var password = document.getElementById('password').value;
18        
19        db.transaction(function (tr) {
20           tr.executeSql('' +
21               'SELECT * FROM users ' +
22               'WHERE name = ? AND ' +
23               'password = ?', [name, password], function (tr, results) {
24
25               if (results.rows.length == 1) {
26                   alert('YAY');
27               } else {
28                   alert('Invalid name/password');
29               }
30           });
31        });
32    };
33};