29 lines
777 B
PHP
29 lines
777 B
PHP
<?php
|
|
SESSION_START();
|
|
require('connect.php');
|
|
|
|
$code = $_POST['code'];
|
|
$code = urldecode($code);
|
|
|
|
$query = "SELECT * FROM `pass_forgot` WHERE `confirm_mail`='$code'";
|
|
$result = mysql_query($query, $connection);
|
|
$result_rows = mysql_fetch_assoc($result);
|
|
$mail=$result_rows['mail_new'];
|
|
|
|
if(mysql_num_rows($result)==1){
|
|
$query = "UPDATE `pass_forgot` SET `confirm_mail`=NULL, `mail`=`mail_new`, `mail_new`=NULL WHERE `confirm_mail`='$code'";
|
|
mysql_query($query, $connection);
|
|
|
|
?>
|
|
<table width='400px' id='table_mail'>
|
|
<tr>
|
|
<th align='left' colspan='2'><h2>Email Adres bevestigen</h2></th>
|
|
</tr><tr>
|
|
<td colspan='2'>Uw email adres is succesvol gewijzigd.</td>
|
|
</tr>
|
|
</table>
|
|
<?php echo "#" . $mail;
|
|
}
|
|
else{
|
|
echo 'Deze code klopt niet!';
|
|
}
|