read data web sql database jquery
112
0
<!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>
By 8 years ago
The power of the user (%)
The most helpful JQUERY solutions
plugin get client ip address using jqueryJQUERY
Click to see more ...
11K
1.8K
How to get client machine name or computer name with jquery?JQUERY
Click to see more ...
16.3K
793
plugin detect country jqueryJQUERY
Click to see more ...
5.9K
772
cookie jqueryJQUERY
Click to see more ...
4K
398
plugin convert thousands to K jqueryJQUERY
Click to see more ...
3.5K
402
show position on google map jqueryJQUERY
Click to see more ...
2.8K
389
how to create a jquery plugin for converting date to days ago, month ago and year ago ?JQUERY
Click to see more ...
3K
349
How to detect the version of IE browser using jquery ?JQUERY
Click to see more ...
2.8K
338
How to get top, right, left, bottom position of element div using jquery ?JQUERY
Click to see more ...
3K
296
how to get ip address using jquery ?JQUERY
Click to see more ...
2.6K
286
- Related solutions:
- check if key already exists using jquery
712 23 -
Vote
1
- Latest solutions:
- plugin get flag by country jquery
2.7K 61 - How to get country from client ip address using jquery ?
1.5K 72 - plugin create qr code jquery
1.8K 32 - Nice select dropdown with jquery
1.2K 9 - 5 star rating using jquery
1.4K 6 - create live clock with jquery
1.1K 38 - How set toggle class using jquery ?
861 6 - check if numeric jquery
782 9 - detect mobile jquery
787 8 - search data in text file using jquery ?
779 5 - Helpful solutions:
- plugin get client ip address using jquery
11K 1.8K - How to get client machine name or computer name with jquery?
16.3K 793 - plugin detect country jquery
5.9K 772 - cookie jquery
4K 398 - plugin convert thousands to K jquery
3.5K 402 - show position on google map jquery
2.8K 389 - how to create a jquery plugin for converting date to days ag ...
3K 349 - How to detect the version of IE browser using jquery ?
2.8K 338 - How to get top, right, left, bottom position of element div ...
3K 296 - how to get ip address using jquery ?
2.6K 286
JQUERY
Would you like to receive an e-mail notification when new JQUERY solution is created?