Notice: Array to string conversion in C:\wamp\www\myphpfileeset_pass_form.php on line <i>33</i>
An email has been sent for you to reset your password!
I already check in my email box i'm getting the proper user_id=value&reset_token=value
reset_pass_form.php
if ( !empty($_POST) && !empty($_POST['forgot_emailpass']) ) {
$email = escape_data($_POST['forgot_emailpass']);
$result = $heidisql->prepare("SELECT * FROM users WHERE email_address='$email'");
$result->execute();
$user = $result->fetch();
If($user) {
session_start();
$reset_token = random_str(30);
$new_hashtoken = bin2hex($reset_token);
$sql = "UPDATE users "
. "SET reset_token= '$new_hashtoken', "
. "reset_allocated_time= now() "
. "WHERE user_id='$user' "; // <- Error is here!
$reset_pass = $heidisql->prepare($sql);
$reset_pass->execute();
// Send registration confirmation link (reset.php)
$to= $email;
$from = "smtp.intnet.mu";
$subject = 'Reset Password';
//Compose a simple HTML email msg
$message = "<html><body>";
$message .= "<h1 style='color: darkblue;'> Hi, there you</h1>";
$message .= "<p><b>Email:</b> $email</p>";
$message .= "<p>To reset your password, please click on the given link below: </p>";
$message .= "<a href='http://localhost:8080/myphpfile/reset_pass_form.php?user_id=".$user['user_id']."&reset_token=".$new_hashtoken. " '> Click Here</a>"; //http://localhost:8080/myphpfile/reset_pass_form.php?
$message .= "</body></html>";
$headers = 'From:' .$from. "
" . // Creating the email headers // To send an HTML mail, content-type must be set to HTML
'Reply-To: '.$from. "
" .
'MIME-Version: 1.0' . "
" .
'Content-type: text/html; charset=iso-8859-1' . "
" .
'X-Mailer: PHP/' . phpversion();
if (mail($to, $subject, $message, $headers)) { // Sending email // email_to, subject, body,email_from
echo 'An email has been sent for you to reset your password!'; // As you can see above the email is being sent
exit();
} else {
echo'Server failed to sent message, please try again later.';
exit();
}
}
}
In my database my reset_token remain empty instead to being the value $new_hashtoken and the same goes for my reset_allocated_time which also remain null
