How to retrieve username pasword from database?

Questions about SQLite database.

How to retrieve username pasword from database?

Postby Ilian » Thu May 04, 2017 11:29 am

I have made a database with username and pasword but It seems not to work since in the database I put 3 users in and the page doesnt even connect to it
nore checks it
. I just want that the login and pasword comes from the database and is valid.. Users are already defined with a list and has to match them.
Does anyone know where it is wrong?


!DOCTYPE html>
<html>
<head>
<title>Log In</title>
<script src="https://code.jquery.com/jquery-1.10.2.js"></script>
<script src="logiin.js"></script>
<link href="style/Logiin.css" rel="stylesheet" />
<link rel="icon" href="Images/icon.png">
<meta charset="utf-8" />
</head>
<body>
<script src="logiin.js"></script>
<form name ="myform" action="/Default1.aspx">
<div class="imgcontainer">

<img src="Images/logo.png" alt="Avatar" class="avatar" />
</div>

<div class="container">
<label><b>Gebruikersnaam</b></label>
<input type="text" id ="txtuserName" placeholder="Geef gebruikersnaam" name="uname" required>

<label><b>Wachtwoord</b></label>
<input type="password" id="txtPassword" placeholder="Geef wachtwoord" name="psw" required>

<button type="submit" value="button name" onclick="Validate">Login</button>

<input type="checkbox" checked="checked"> Onthou mij
</div>

<div class="container" style="background-color:#f1f1f1">

</div>
</form>

</body>
</html>
---------------------------


var connection = mysql.createConnection({
host: 'localhost:49974',
user: 'gebruikersnaam',
password: 'null',
database: 'user.http://localhost:49974/App_Data/user.db'
});

var count = 2;
function validate() {
var uname = document.myform.uname.value;
var psw = document.myform.psw.value;
var valid = false;
var unameArray = ["username1", "username2", "username3", "username4"];
var pswArray = ["password1", "password2", "password3", "password4"];
for (var i = 0; i < unameArray.length; i++) {
if ((uname == unameArray[i]) && (psw == pswArray[i])) {
valid = true;
break;
}
}
if (valid) {
alert ("Login was sucessvol");
window.location = "" ;
return false;
}
var t = " tries";
if (count == 1) {t = " try"}
if (count >= 1) {
alert ("Onjuist gebruikersnaam en/of paswoord. U heeft " + count + t + " over.");
document.myform.uname.value = "";
document.myform.psw.value = "";
setTimeout("document.myform.uname.focus()", 25);
setTimeout("document.myform.uname.select()", 25);
count --;
sendRequest(uname, psw);
}
else {
alert ("Steeds incorrect! U heeft geen pogingen meer over!");
document.myform.uname.value = "Geen pogingen meer mogelijk!";
document.myform.psw.value = "";
document.myform.psw.disabled = true;
document.myform.psw.disabled = true;
return false;
}
}

function sendRequest(uname, psw){
var crd = {
user:uname,
pass: psw
}
var json = JSON.stringify(crd);

$.ajax({
type: "POST",
url: "../Ajax/LogIn.ashx",
data: json,
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function(response){
console.log("ok");
},
error: function(error){
console.log();
}
});
}
Ilian
 
Posts: 1
Joined: Thu May 04, 2017 11:24 am

Re: How to retrieve username pasword from database?

Postby Googie » Thu May 04, 2017 1:36 pm

You are asking about MySQL. This subforum is about SQLite. You should ask this at either MySQL forums, or JavaScript forums, or StackOverflow.
Googie
Site Admin
 
Posts: 788
Joined: Wed Jul 27, 2011 8:04 pm


Return to SQLite database

Who is online

Users browsing this forum: No registered users and 1 guest

cron