<!DOCTYPE html>
<html lang="en-US">
<body>
<button type="button" onclick="update()">Update</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 update(){
//Update
db.transaction(function (tx) {
tx.executeSql('update myTeam set name=? where id=?', ["Eich", 2]);
});
// 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>
<p><strong>Note:</strong> Go to your Developer Tools to check the database as mentioned in this <a href="/html/web-sql" target="_blank">page</a></p> </body>
</html>