×Welcome aboard! We are happy you are here and wish you good net-raft!



Together We Can Simplify The World

the current number of solutions:  2360
.htaccess (1x)    AJAX (13x)    ANGULARJS (161x)    ASP (1x)    ASP.NET (6x)    BACKBONE.JS (47x)    BOOTSTRAP (12x)    C# (224x)    COFFEESCRIPT (28x)    CSS (71x)    HTML (47x)    JADE (34x)    JAVA (51x)    JAVASCRIPT (430x)    JQUERY (390x)    JQUERY MOBILE (5x)    JSON (5x)    LARAVEL (25x)    MYSQL (9x)    NODEJS (162x)    ORACLE SQL (19x)    PERL (2x)    PHP (295x)    PYTHON (10x)    REACT (62x)    RUBY (25x)    RUBY ON RAILS (1x)    SHELL (2x)    SQL (90x)    SQL SERVER (3x)    TYPESCRIPT (51x)    VB.NET (32x)    W3.CSS (6x)    W3.JS (40x)    
join us

click to create your account

web sql database

(jquery web sql database )

- JQUERY

 viewed 63

Comment:
JQUERY

2

// works in chrome, opera, safari
<!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 () {

$("#btn_create").click(function () {
var db = null;
db = window.openDatabase("MyDb", "1.0", "my database", 1024 * 1024 * 3);

db.transaction(function (tx) {

// create table
tx.executeSql(
"CREATE TABLE MYTABLE (id INTEGER, country VARCHAR(255), city VARCHAR(255))", [],
function () { $("#output1").text("table has been sucessfully created!"); },
function (tx, error) { $("#output1").text(error.message); });
});
});

// insert record

$("#btn_insert").click(function () {
var id = $("#id").text();
var country = $("#country").text();
var city = $("#city").text();

var db=null;
db = window.openDatabase("MyDb", "1.0", "my database", 1024*1024*3);

db.transaction(function(tx){

tx.executeSql(
"INSERT INTO MYTABLE (id, country, city) VALUES (?,?,?)", [id,country,city],
function(){$("#output2").text("record has been sucessfully inserted!");},
function(tx, error){$("#output2").text(error.message);});
});
});

// read records
$("#btn_read").click(function () {
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);
alert(row["id"]);
alert(row["country"]);
alert(row["city"]);
}

});
});

});


// drop table
$("#btn_remove").click(function () {
var db = null;
db = window.openDatabase("MyDb", "1.0", "my database", 1024 * 1024 * 3);

db.transaction(function (tx) {

tx.executeSql("DROP table MYTABLE", [],
function () { $("#output3").text("table has been sucessfully removed!"); },
function (tx, error) { $("#output3").text(error.message); });

});
});
});
</script>

<div id="id">1</div></br>
<div id="country">USA</div></br>
<div id="city">San Diego</div></br>
<div id="output1"></div></br>
<div id="output2"></div></br>
<div id="output3"></div></p>

<button id="btn_create">create table</button>
<button id="btn_insert">insert record</button>
<button id="btn_read">read record</button>
<button id="btn_remove">remove table</button>

</body>
</html>

     

created: 5 months ago

The power of the user (%)

31%

Do you know a little more effective code ? Feel free to optimize ...


haven't you found what you're looking for ?
Write us your question ...
Login is not needed.


The most helpful JQUERY solutions
Likes Solution Technology
748 plugin get client ip address using jqueryJQUERY
378 plugin detect country jqueryJQUERY
277 cookie jqueryJQUERY
237 plugin convert thousands to K jqueryJQUERY
209 How to detect the version of IE browser using jquery ?JQUERY
173 How to get top, right, left, bottom position of element div using jquery ?JQUERY
139 how to get the value from an object using jquery ?JQUERY
125 how to get ip address using jquery ?JQUERY
124 jquery plugin for getting client ip addressJQUERY
104 how to create a jquery plugin for converting date to days ago, month ago and year ago ?JQUERY
Check out all of JQUERY ...
The most viewed JQUERY solutions by country
Solution Country
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre
How to get client machine name or computer name with jquery?Cinque Terre