<!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],function(transaction, result){
if(result)
alert(result.rowsAffected+ " row(s) affected");
else
alert("Something Went Wrong");
});
});
// 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>