MySQL newb

djdaz

Hi
I've been attempting to learn the basics of MySQL for a while now, but cant quite get my head around connecting to a database, retreiving a password for a certain username and comparing it with the password specified in a form.
Would be a great help if someone can just quickly jot down this script. The rest of the stuff should come easily then.

Thanks.

touchingvirus

It all depends on how you store the password..if you md5 it then the compare would look like this...

if ($bbuser=$DB_site->query_first("SELECT userid,usernickname,userpassword FROM users_table WHERE usernickname='".addslashes(htmlspecialchars($usernickname))."'")) {

if ($bbuser['userpassword']!=md5($enteredpassword)) {      

echo "Wrong Password, Please try again";
        die;

and if you were using normal text to store the password it would be something like this...

if ($bbuser=$DB_site->query_first("SELECT userid,usernickname,userpassword FROM users_table WHERE usernickname='".addslashes(htmlspecialchars($usernickname))."'")) {

if ($bbuser['userpassword']!= $enteredpassword)) {      

echo "Wrong Password, Please try again";
        die;

Again, please be a little more specific 🙂