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");
}
}
}