frkhfk4W

1    console.log("sqlite..............");
2    console.log($cordovaSQLite);
3    var db = $cordovaSQLite.openDB({ name: "my.db", location: 'default' });
4    console.log(db);
5    var createTable = "CREATE TABLE IF NOT EXISTS MyGuests (id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY,firstname TEXT NOT NULL,lastname TEXT NOT NULL,email TEXT,reg_date NUMERIC)";
6    $cordovaSQLite.execute(db, createTable, []).then(function(res) {
7        console.log("table created...............");
8    }, function(err) {
9        console.error(err);
10    });
11
12    var query = "INSERT INTO MyGuests (firstname, lastname,email) VALUES (?,?,?)";
13    $cordovaSQLite.execute(db, query, ["R", "Prime", "R@r.com"]).then(function(res) {
14        console.log("insertId: " + res.insertId);
15    }, function(err) {
16        console.error(err);
17    });
18    var query = "select * from MyGuests";
19    $cordovaSQLite.execute(db, query, []).then(function(res) {
20        //console.log("Table data is........................", res.rows);
21        if (res.rows.length > 0) {
22            for (var i = 0; i < res.rows.length; i++) {
23                console.log(res.rows.item(i).lastname, res.rows.item(i).firstname, res.rows.item(i).email);
24            }
25        } else {
26            console.log("No results found");
27        }
28
29
30    }, function(err) {
31        console.error(err);
32    });