php mail onclick on link execute mysql命令

Question

I'm trying to do a password reset using mail, so what will happen is the user will enter his email on the forgot password and on button click it will be sent to the email that is on the database. Now what i will do is give the user a new random password and to do this the user should click on the link on the email to verify that he really wants to change the password, will that be possible? Here is my code

    if (isset($_POST['mytxtmail']))
    {
        $newid = ($_POST['mytxtmail']);

    $result = mysqli_query($con,"SELECT EMAIL FROM members WHERE EMAIL='$newid'");
    if($result->num_rows == 0) {
    echo 'Mail  Successfully Sent to '.$newid;
    return false;   
    }
    else
    $to      = $newid;
    $subject = 'the subject';
    $message = 'Please Click here to Verify the Change of Password';
    $headers = 'From: [e-mail]' . "
" .
        'Reply-To: [e-mail]' . "
" .
        'X-Mailer: PHP/' . phpversion();

    mail($to, $subject, $message, $headers);

    echo 'Mail  Successfully Sent to '.$newid;

    }

Answer 1

You should include the link in the email which would take the user to the password verification script (it could be the same you are using here, only add needed functionality).