Jump to content

Mysql update information problem!


benfla

Recommended Posts

hi, I read the mysql tutorial on how to make it so you can have members on your site, but the password was randomly made and given to you so I decided to make a form so you can change your password the only problem is when I submit it it doesnt give me any errors, but it also doesnt update the information

heres the code I\'m using now:

<?php

include \'db.php\';

if(!$yourusername){

 echo "user name is a required field. Please enter it below.<br />";

}

if(!$newpassword){

 echo "new password is a required field. Please enter it below.<br />";

}

if(!$currentpass){

 echo "current password is a required field. Please enter it below.<br/>"; 

}	

include \'newpassword.html\';

exit();



if ($newpassword = $checkpassword){

} else { 

echo \'Your new password does not match!\';

exit();

} 

$encodedcurrentpass = md5($currentpass);

$encodednewpassword = md5($newpassword);

($sql = mysql_query("UPDATE users SET password=\'$encodednewpassword\' WHERE username=\'$yourusername\' AND password=\'$encodedcurrentpass\'"));

if (!$sql) {

echo \'Your password hasnt been changed! there was an error changing your password\';

} else {

echo \'Your password has been changed!\';

}

?>

Im sorta new to this so i dont know whats wrong

if you could help me I would really appreciate it.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.