Php User Password Recovery Script

My brother,

There are two options, and it depends on your signup form / user DB. If you encrypted the password using md5($password) for example, which is recommended, you would have to reset the password and not resend

I can't start coding because I am in a cafe right now, but let me give you a guideline which is better.

1. For Resend, Simple set up a page with a form of one field or two if you like:

Something like

username,
email,
       submit

Then check ur db for a correlation between this two fields. Your CODE should be like

//Write SQL
$sql = "SELECT * FROM user_table WHERE username = '$username' AND email = '$email' LIMIT 1";
$result =  mysql_query($sql) or die ('Could not check username with email: '.mysql_error());
      //Check if query return an empty result set
         if(mysql_num_rows($result) < 1)
                {
                    $error = "Username and Email doesn't match, please try again";
                }
        else
                 {
                     $row = mysql_fetch_assoc($result);
                     //extract the $row array to get an email and password variable of the user's email and password
                     extract($row); //The u have the variable $password (if not encrypted) and $email

                     //use the mail() function to send the details to the email address from ur DB! and not the one provided.
                 }

2. For Reset

When you get to the else clause, you generate a password, you can use the  rand() function, then use the mail() function to send before updating the password in the DB! don't update before sending, because if sending failed, u would have reset the poor guys password.


If you need a better script, go onlie, but try coding one yourself for learning purpose. More help use naijaguru [at] the free email service provided by google.

Cheers
                           

I want to believe that naijaguru has fixed your problem. If you still need any help paste your table structure here we would help you write a complete script.

Oleku
www.oleku.org
www.faceoffestac.net *Activated