HTML Web SQL Retrieve

You are Here:

HTML Web SQL Retrieve

In the following example, we will retrieve all the data from the table ('myTeam') under the database ('studentsDB').

Example

HTML Online Editor
<!DOCTYPE html> <html> <body> <button type="button" onclick="retrieveData()">Retrieve Data</button> <div id="point"></div> <script> var x = document.getElementById("point"); var db = openDatabase('studentsDB', '1.0', 'Test DB', 2 * 1024 * 1024); // Insert db.transaction(function (tx) { tx.executeSql('CREATE TABLE IF NOT EXISTS myTeam (id unique, name)'); tx.executeSql('INSERT INTO myTeam (id, name) VALUES (1, "Brendan")'); tx.executeSql('INSERT INTO myTeam (id, name) VALUES (2, "Harley")'); }); function retrieveData(){ // Retrieve db.transaction(function (tx){ tx.executeSql('SELECT * FROM myTeam', [], function (tx, data) { var len = data.rows.length, i; msg = "<p>You have: " + len + " members in your team</p>"; x.innerHTML += msg; for(i = 0; i < len; i++) x.innerHTML += (data.rows.item(i).name )+ "<br>"; }, null); }); } </script> </body> </html>

Reminder

Hi Developers, we almost covered 99.5% of HTML Tutorials with examples for quick and easy learning.

We are working to cover every Single Concept in HTML.

Please do google search for:

Join Our Channel

Join our telegram channel to get an instant update on depreciation and new features on HTML, CSS, JavaScript, jQuery, Node.js, PHP and Python.

This channel is primarily useful for Full Stack Web Developer.

Share this Page

Meet the Author