Diffrent operation in HTML5 Web SQL Database
This article describe about HTML5 Web SQL Database operation.
HTML5 Web SQL Database operation
Executing queries:
For execute query on the database use database
.transaction() method. This method take only single argument, this method take
care of actually executing the query.
var dab = openDatabase('empdb', '1.0', 'test DB', 2 *
1024 * 2048);
dab.transaction(function (txt) {
txt.executeSql('CREATE TABLE IF NOT EXISTS LOGIN (id unique,
logs)');
}); |
Note: The declared query create table in
the empdb database.
INSERT Operation:
For this insert row or entries into the table
LOGIN
var dab = openDatabase('empdb', '1.0', 'test DB', 2 *
1024 * 2048);
dab.transaction(function (txt) {
txt.executeSql('CREATE TABLE IF NOT EXISTS LOGIN (id unique,
logs)');
txt.executeSql('INSERT INTO LOGIN (id, logs) VALUES (1, "amrit")');
txt.executeSql('INSERT INTO LOGIN(id, logs) VALUES (2, "loginmessage")');
txt.executeSql('INSERT INTO LOGIN (id, logs) VALUES (3, "my
message")');
}); |
READ Operation:
The below declared part of program is used
for the reading purpose. This code execute line by line and fetch the insert
rows from the LOGIN table
var dab = openDatabase('empdb', '1.0', 'test DB', 2 *
1024 * 2048);
dab.transaction(function (txt) {
txt.executeSql('CREATE TABLE IF NOT EXISTS LOGIN (id unique,
logs)');
txt.executeSql('INSERT INTO LOGIN (id, logs) VALUES (1, "amrit")');
tx.executeSql('INSERT INTO LOGS (id, log) VALUES (2, "loginmessage")');
txt.executeSql('INSERT INTO LOGIN (id, logs) VALUES (3, "my
message")');
});
dab.transaction(function (txt) {
txt.executeSql('SELECT * FROM LOGIN', [], function (txt, results) {
var leng = results.rows.length, i;
masg = "<p>Found rows: " + leng + "</p>";
document.querySelector('#status').innerHTML += masg;
for (i = 0; i < leng; i++){
alert(results.rows.item(i).log );
}
}, null);
}); |
Further
Readings
You may also want to read these related
articles :
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here