My head go crazy with the Headers...

plasmahba

Hi, thanx for your time and your help.

I´m trying to do and authentication User area with mySql.

I have everything done, but I get this error message:

Warning: Cannot add header information - headers already sent by (output started at c:\apache\htdocs\mysite\conn.php:1) in c:\apache\htdocs\mysite\validate.php on line 25

And this is part of the code of validate.php :

<?
include("conn.php");

$ssql = "SELECT * FROM mydb WHERE User='$User' and PWD='$PWD'";

$rs = mysql_query($ssql);
if (mysql_num_rows($rs)!=0){
session_start();
session_register("autent");
$autent = "yes";
header ("Location: user.php");
}else {
header("Location: login.php?erroruser=yes");
}

is it because maybe exists a conflict between the include conn.php and the header?

Any help will be appreciated

nemonoman

if conn.php PRINTs or ECHOs anything. That includes any HTML tags including <meta> tags. Likely, as this would be why your header() commands fail.

easiest would be:

<? $ssql = "SELECT * FROM mydb WHERE User='$User' and PWD='$PWD'";

include("conn.php");

plasmahba

Your help worked like magic!!

Thanx, I found that my include file had some tags. I take them off and it worked perfect.

Good day!

rachel2004

Originally posted by nemonoman
}else {
header("Location: login.php?erroruser=yes");
}

include("conn.php");

I agree with your analysis, but judging from the file name (conn.php), he may need to keep it where he has it now. He may be better served, in that case, by suppressing his output with:

ob_start();

at the beginning of this whole thing and a:

ob_end_flush();

at the end.

<?
ob_start();
include("conn.php");


$ssql = "SELECT * FROM mydb WHERE User='$User' and PWD='$PWD'";

$rs = mysql_query($ssql);
if (mysql_num_rows($rs)!=0){
session_start();
session_register("autent");
$autent = "yes";
header ("Location: user.php");
}else {
header("Location: login.php?erroruser=yes");
}
// possibly more code
ob_end_flush();
?>

The placement of ob_end_flush() depends on where he wants to begin outputting his buffer.