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.