Menu
Community /Pin to ProfileBookmark
@NogDogMar 09.2008 — #The first question would be, why do you want to retrieve the password? Normally you just need to verify that the username as password are correct, then you have no further need for the password.
Storing Login Information???
I’ve begun to experiment with login systems using PHP and MySQL. What would be the correct way to retrieve someone’s username and password from the database, and then store it in variables?
[code=php]SELECT testusername FROM usernames
SELECT testpassword FROM passwords
$username = testusername;
$password = testpassword;
Would that be correct?
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogMar 09.2008 — #The first question would be, why do you want to retrieve the password? Normally you just need to verify that the username as password are correct, then you have no further need for the password.[code=php]
$sql = "SELECT first_name FROM users WHERE username = '" .
mysql_real_escape_string($_POST['username']) . "' AND password = '" .
mysql_real_escape_string($_POST['password']) . "'";
$result = mysql_query($sql);
if(!$result)
{
// something wrong with the database or your query, so output an error
exit()
}
if(mysql_num_rows($result) != 1)
{
// invalid login, so output error or whatever you want to do.
exit();
}
// we're good to go
session_start();
$_SESSION['first_name'] = mysql_result($result, 0);
echo "Hello, {$_SESSION['first_name']}";
[/code]