PHP again guys.....

Question

I thought this code was supposed to send an email to me..... but i didn't get any when i ran the code
or do i have to host before it works??

here is the code:

$sql = $mysqli->query("INSERT INTO users(firstname,lastname,username,email,password,vkey) VALUES('$fname','$lname','$uname','$email','$password','$vkey')");

if ($sql) {
// send verification maessage to email
$to = $email;
$subject = "Email Verification";
$message = "<a href='http://localhost/project3/verify.php?vkey=$vkey'>Verify Account</a>";
$headers = "From: [e-mail] \r\n";
$headers .= "MIME_Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";

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

header('location:thankyou.php');

}else{
echo $mysqli->error;
}

i don't know what went wrong

Answer 1

So is it inserting in the DB? If not then the issue lays outside of the if($sql).

Also I would guess that your headers are wrong. See mine below.

Try this code just on its own on a test page and just change the recipient to a written address for testing. Also check your spam folder as this will likely end up being spammed. PhpMailer is the best option.

$recipient = $email;

$subject = 'User Contact Information';

$headers = "From: "[e-mail]"\r\n";
$headers .= "Reply-To: "[e-mail]"\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";

$body = 'Hi '.$_POST["uname"].', thanks for sending us an email.';

mail($recipient, $subject, $body, $headers) or die ("Failure");

Answer 2

it's inserting into the DB but the mail is not coming....

Answer 3

Let me try your code alone. ..thanks