Jump to content

Archived

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

hey_suburbia

redirect user after email is found in SQL DB

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!

Share this post


Link to post
Share on other sites
perhaps you have some blank spaces/lines following the final '?>'

any such spaces/lines are sent as HTML and will cause the error you see

Share this post


Link to post
Share on other sites

×

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.