Jump to content

Aud11

Members
 View Profile  See their activity

  • Posts

    1

  • Joined

  • Last visited

 Content Type 

Posts posted by Aud11

    Validate if record exists in a database websql

    in JavaScript

    Posted

    Hi i am trying to retrieve a user from a database based on the username and password entered and then if the user exists i then go to the next page,i am using one function and global variables..what is giving me a problem is that i want to use the form data before executing the validate function..please help

     

    var db = openDatabase('AudreyTeracore', '1.0', 'Company Registration DB', 2 * 1024 * 1024);
    var nameContent = new Array(); // now it's global!
    var passwordsArray = new Array();
    var nameT=document.getElementById("username").value;
    var passwordT=document.getElementById("password").value;
    db.transaction(function(tr){
    tr.executeSql("select UserName,Password From UserLogin Where UserName='"+nameT+"' And Password ='"+passwordT+"' ", [],
    function(tx, result)
    {
    for (var i = 0; i < result.rows.length; ++i)
    {
    var row = result.rows.item(i);
    var name = row.UserName;
    var pass = row.Password;
    nameContent.push(name);
    passwordsArray.push(pass);
    }
    });
    });
    function checkValid() {
    for (var i = 0; i < nameContent.length; ++i)
    {
    if(nameContent!="" && passwordsArray!=""){
    alert("Sucessfully logged in")
    document.getElementById('form1').action = "EditUser.html";
    break;
    }
    else
    {
    alert("Please enter valid username and password");
    }
    }
    }
×
×
  • Create New...