Welcome aboard! We are happy you are here and wish you good net-raft!
Database name
Version number
Text description
Size of database
Creation callback
<script>
var db = openDatabase('namedb', '1.0', 'my database', 2 * 1024 * 1024);
db.transaction(function (tx) {
tx.executeSql('SELECT * FROM tablename', [], function (tx, results) {
var char = results.rows.length, i;
msg1 = "<p>record: " + char + "</p>";
document.querySelector('#status').innerHTML += msg1;
for (i = 0; i < char; i++){
msg1 = "<p><b>" + results.rows.item(i).log + "</b></p>";
document.querySelector('#test').innerHTML += msg1;
}
}, null);
});
</script> 
<!DOCTYPE html>
<html lang="en">
<head>
<script src="https://code.jquery.com/jquery-2.1.3.min.js" type="text/javascript"></script>
</head>
<body>
<script>
$(document).ready(function () {
//works in chrome, safari, opera
var db=null;
db = window.openDatabase("MyDb", "1.0", "my database", 1024*1024*3);
db.transaction(function(tx){
tx.executeSql("SELECT id, country, city FROM MYTABLE", [],
function(SQLTransaction, data){
for(var i=0; i < data.rows.length;i++) {
var row = data.rows.item(i);
$("#id").text(row["id"]);
$("#country").text(row["country"]);
$("#city").text(row["city"]);
}
});
});
});
</script>
<div id="id"></div></br>
<div id="country"></div></br>
<div id="city"></div></br>
<div id="output"></div>
</body>
</html>
The most helpful HTML solutions
how to create the moving picture left and right in html ?HTML Click to see more ... 1.2K 97