Jump to content

redirect user after email is found in SQL DB


hey_suburbia

Recommended Posts

Here is what I have:

[code]<?php


mysql_connect("localhost","user","pass");


mysql_select_db("db");

$email = $_POST['email'];
 
$fetch_exist=mysql_query("SELECT email FROM db WHERE email = '$email'");

if(mysql_num_rows($fetch_exist)>0)
{
header('Location: www.site.com/page1.html');
exit;
}

else
{
$error_message .="
That Email is not in our database. \n
Please register here: www.site.com/page2.html
";
die ($error_message);
}

?>[/code]


The problem occurs when I try to redirect with "Location:", I get:

Warning: Cannot modify header information - headers already sent by (output started at /usr/com/site/public_html/login.php:3) in /usr/com/site/public_html/login.php on line 23


Line 23 is the header('Location: http://www.site.com');

Normally this is fixed by just making the only content the "Location:" script, but I have to access the database first?

[b]In a nutshell:[/b]
If email exists, user goes to page1.html.
If email doesn't exist, user goes to page2.html

Thanks!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.