Diffrent operation in HTML5 Web SQL Database

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 :

• Introduction to HTML5 Web Worker

• HTML5 article

• REMOTING Using SQL Server Database

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here