<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>AMS - CRM</title>
<script type="text/javascript" src="js/jquery-2.1.1.min.js"></script>
<script type="text/javascript">
// <BUILD INSERT STATEMENT>
$(document).ready(function(){
// JSON data url
var url="https://mydomain.com/json.php";
$("#status").html("<p>Loading data... please wait</p>");
// <INSERT DATA>
$.getJSON(url, function(data){
db.transaction(function (tx) {
// <create database>
tx.executeSql('DROP TABLE IF EXISTS CRM');
tx.executeSql('CREATE TABLE IF NOT EXISTS CRM (id unique, customer, contact)');
// </create database>
$.each(data.users, function(i,user){
var sql_id = user.id;
var sql_company = user.company.replace(/'/g,"\\'").replace(/"/g,'') // comment out quotes
var sql_contact = user.contact.replace(/'/g,"\\'").replace(/"/g,'') // comment out quotes
tx.executeSql('INSERT INTO CRM (id, customer, contact) VALUES ('+sql_id+', "'+sql_company+'","'+sql_contact+'")');
});
});
$("#status").html("done");
});
// </INSERT DATA>
});
// </BUILD INSERT STATEMENT>
</script>
</head>
<body>
<div id="status"></div>
</body>
</html>
ASKER
$.getJSON(url, function(data){
...
})
.fail(function() {
// do whatever for errors
})
ASKER
ASKER
JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and in almost every mainstream web browser.
TRUSTED BY