I has created a database that contains 2 columns username and password.I need to check whether the user exist or not using this function.But when executing the code above I get access denied....

See more:

Javascript

web

html5rocks.webdb.searchUsers = function (username,password){
var db = html5rocks.webdb.db;
db.transaction(function (tx) {
tx.executeSql("SELECT * FROM users WHERE username=? AND password=?", [username,password], function (tx, results) {
var len = results.rows.length, i;
var user = document.getElementById("username");
var pd = document.getElementById("password");
for ( i = 0; i < len; i++)
if(results.rows.item(i).username == user.value && results.rows.item(i).password == pd.value){
alert("logged in");
self.location.href = "login.html";
}
else{
alert("access denied");
}


});
});
}