javascript - Check a Boolean value from database at the start of an app then load terms and condition page if false, load menu page if true -


is possible?

before page loads, run javascript code check value in database is, open relevant page?

here code far:

function ondeviceready()    //phone gap ready {     try      {         db = opendatabase('cuopioid', '1.0', 'cupioids application database',                 2 * 1024 * 1024);     } catch (e)      {         // error handling code goes here.         if (e == invalid_state_err)          {             // version number mismatch.             alert("invalid database version.");         }         else          {             alert("unknown error " + e + ".");         }     }     console.log("database created!");     db.transaction(createtableterms, errcb, console.log("medicines table created!"));     $('#btnaccept').on('click', acceptterms); }

the code below creates database (if isn't there already)

function createtableterms(tx)  {     tx.executesql('create table if not exists terms (id unique, status boolean)');     tx.executesql('insert terms (id, status) values (0, 0)');     console.log("terms table created!"); }

i have created function selects rows form database if set true, if results has 1 record want open menu page, if has no results means terms , conditions haven't been accepted previously:

function checkterms(tx) {     db.transaction(function(tx)      {         tx.executesql('select * terms status=1', [],console.log("check terms"), errcb);     });     var len = results.rows.length;     if (len = 1)     {         console.log("accepted - menu page");     }     else     {         console.log("termsandconditions page");     } }

i not sure put checkterms(tx) function

i solved problem creating new javascript file runs when html page lodes (start of <head> tag

  • which opens database
  • runs sql query find value
  • opens relevant page depending on result

it still displays page (half second @ most) when load page, want

here code:

try  {     db = opendatabase('cuopioid', '1.0', 'cupioids application database',             2 * 1024 * 1024); } catch (e)  {     // error handling code goes here.     if (e == invalid_state_err)      {         // version number mismatch.         alert("invalid database version.");     }     else      {         alert("unknown error " + e + ".");     } }  checkterms();  function checkterms(tx) {     db.transaction(function(tx)      {         tx.executesql('select * terms status=1', [], openpage, errcb);     }); }     function openpage(tx, results) {     var len = results.rows.length;     if (len = 1)     {         getdrugs();         window.location.href = "#page1"         console.log("accepted - menu page");     }     else     {         window.location.href = "#page0"         console.log("termsandconditions page");     } }

Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more