Currently I am building a mobile app using Phonegap. In my project I need to store the data into the database and refresh it with server time to time.<\/p>\n
Phonegap have the Storage API to do this. Storage API is based on the W3C HTML5 webdatabase. So we just need to create the database and corresponding table according to the webdatabase specification e.g;
\n[java]
\nvar db = openDatabase("myApp", 1.0, "App database",200000)
\n[\/java]
\nNow to create tables and insert data into it using this db instance
\n[java]
\ndb.transaction(function(transaction){
\n transaction.executeSql("CREATE TABLE user (username Integer default NULL, UNIQUE(username));");
\n transaction.executeSql("INSERT INTO user (username) values (‘uday’);")
\n})
\n[\/java]
\nNow to get the data from this table we will simply write the select query. The executeSql method has its own success and failure callback method. Success callback gives the result set from the query e.g;
\n[java]
\ndb.transaction(function(transaction){
\n transaction.executeSql("SELECT * from user where username=?",[‘uday’],successCallback,function(e){
\n console.debug("some error")
\n })
\n})<\/p>\n
function successCallback(transaction,results){
\n for (var i = 0; i < results.rows.length; i++) {
\n var username = results.rows.item(i).username;
\n \/\/ Some code
\n }
\n}
\n[\/java]
\nThe executeSql method takes four argument, first is the query, second array of values, if needed in the query, third success callback, which returns the result of query and last one error callback.<\/p>\n","protected":false},"excerpt":{"rendered":"
Currently I am building a mobile app using Phonegap. In my project I need to store the data into the database and refresh it with server time to time. Phonegap have the Storage API to do this. Storage API is based on the W3C HTML5 webdatabase. So we just need to create the database and […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":4,"footnotes":""},"categories":[1],"tags":[1043,1044,921,1042],"class_list":["post-8183","post","type-post","status-publish","format-standard","hentry","category-technology","tag-database-in-phonegap","tag-execute-sql-query-in-phonegap","tag-phonegap","tag-sqllite-in-phonegap"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t