php include statement

jotan

Have 2 issues:

1) include statement doesn't seem to work together with header statement. Why? I tried but always get an error msg on problem with header. But when i take away the include statement, the header works.

2) how to have include statement in a php file and yet hide it from the public so that they can't open the include file which may be password.php?

Thank you.

dcooper

1) paste your code please

2) aslong as all the code in password.php is within the php tags the user cant read it

jotan

Hi,

Thank you for your reply.

The code with the include and header statement as follows:

<?
include 'icebreakers_pword.php';
//db connection
$connection=mysql_connect ("localhost", $username, $pass) or die ("Cannot connect to the database at this time. Please go back and try again.");
$db= mysql_select_db ("wordjuxtapoz", $connection) or die ("Couldn't select database. Please go back and try again.");

$date = date('Y-m-d');

//sql statement
$sql = "INSERT INTO test (id,email,realname,country,age,date) VALUES ( ' ', '$email', '$realname', '$country', '$age', '$date')";

//sql query
$sql_result=mysql_query($sql,$connection) or die ("Cannot process your request. Please go back and try again");

//chk result
if (!$sql_result)
{
die ("Sorry, I cannot add you to my database. Please go back and try again.");
}
header("Location: download.html");

dcooper

the location header needs and correct path so

header("Location: download.html");

should be
header("Location: http://www.site.com/download.html");

try that and see if u still get an error

jotan

hi,

have tried your suggestion, still doesn't work.

The error message:
Warning: Cannot modify header information - headers already sent by (output started at /home/wj/public_html/icebreakers_pword.php:2) in
/home/wj/public_html/test.php on line 54

Any idea?

pjleonhardt

yeah, there's already some HTML output on the file you're including.. (icebreakers_pword.php)

jotan

not too sure what html output means?

It's a php file and only contains username and password. Why is there some html output?

Appreciate your enlightenment on this.

tekky

html output... something thats NOT php that the browser would HAVE to parse/display

anything NOT in PHP tags, or that is ECHO'd our PRINT'd before the header() statement (and no, you dont have to have STATIC paths for header, "location: document.php" would work) will break the header() call and give you the error you specified

Moonglobe

Originally posted by tekky
html output... something thats NOT php that the browser would HAVE to parse/display

anything NOT in PHP tags, or that is ECHO'd our PRINT'd before the header() statement (and no, you dont have to have STATIC paths for header, "location: document.php" would work) will break the header() call and give you the error you specified

that includes as much as a space or newline!

jotan

thanks!

now i know.

I will chk my include file.

legsman

Originally posted by jotan
thanks!

now i know.

I will chk my include file.

yr 1st line [[[[ include 'icebreakers_pword.php'; ]]]]

last line - [[[ header("Location: download.html"); ]]]

these are relative paths to the file
yr php include line needs [ i think ]

http URL's like include ( 'http://yr-web-sitez.com/path/to/incl-filename' ) ; [ with or w-out the brackets shld work now

Moonglobe

uh....that would introduce more overhead with the HTTP calls. there is no problem with relative paths. the header part should be absolute, but relatives will work with all major browsers.