0 Replies Latest reply on Jan 18, 2017 12:56 AM by sethup51656429

    Database not working

    sethup51656429 Level 1

      <html>

        <head>

          <title>Contact Example</title>

       

       

          <script type="text/javascript" charset="utf-8" src="phonegap-1.2.0.js"></script>

          <script type="text/javascript" charset="utf-8">

       

       

          // Wait for PhoneGap to load

          //

          document.addEventListener("deviceready", onDeviceReady, false);

       

       

          // Populate the database

          //

          function populateDB(tx) {

        alert("populateDB")

              tx.executeSql('DROP TABLE IF EXISTS DEMO');

              tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');

              tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")');

              tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');

          }

       

       

          // Query the database

          //

          function queryDB(tx) {

        alert("queryDB")

              tx.executeSql('SELECT * FROM DEMO', [], querySuccess, errorCB);

          }

       

       

          // Query the success callback

          //

          function querySuccess(tx, results) {

        alert("query succes")

              var len = results.rows.length;

              console.log("DEMO table: " + len + " rows found.");

              for (var i=0; i<len; i++){

                  alert("Row = " + i + " ID = " + results.rows.item(i).id + " Data =  " + results.rows.item(i).data);

              }

          }

       

       

          // Transaction error callback

          //

          function errorCB(err) {

              console.log("Error processing SQL: "+err.code);

          }

       

       

          // Transaction success callback

          //

          function successCB() {

              var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);

              db.transaction(queryDB, errorCB);

          }

       

       

          // PhoneGap is ready

          //

          function onDeviceReady() {

              var db = window.openDatabase("Database", "1.0", "PhoneGap Demo", 200000);

              db.transaction(populateDB, errorCB, successCB);

          }

       

       

          </script>

        </head>

        <body>

          <h1>Example</h1>

          <p>Database</p>

        </body>

      </html>

       

      this is my code and im using plugin  cordova-sqlite-storage

      testing in android device "redmi note 3"

      can you solve this..

      please note that when i test it in the ripple emulator it shows results but in the device it doesn't give any response at all !!!!!!!!