PHP Bug or just me?

[Anon]

Hi, i have a really confusing problem....

I have a config.php file where variables such as database settings can be set. This config.php file is inserted into every file like this;

include("http://www.pagadoo.com/pagadoo_config.php");

the file pagadoo_config.php looks like this;

=============
<?php
$title = "The Pagadoo! Job & Recruitment Network";
$DBhost = "localhost";
$DBuser = "username";
$DBpass = "password";
$DBname = "pagadoo";
$dt = date("m d y HⓂs");
$Header = "http://www.pagadoo.com/header.php";
$Footer = "http://www.pagadoo.com/footer.php";
$Start_Page = "http://www.pagadoo.com/php/index.php";
$log_ip = $REMOTE_ADDR;
$page = $PHP_SELF;
$to = "[e-mail]";

include($Header);

$cn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Error Connecting To Database!");
mysql_select_db ($DBname);

?>

but... when i try to query like this

=====
echo "<SELECT NAME='county'>";
$sql = mysql_query("SELECT * FROM county",$cn);
while($row = mysql_fetch_array($sql)) {
echo "<option value='$row[county]'> $row[county]";
}

echo "</select>";

it doesnt seem to recognise the $cn variable(which is of course the database connection string. I know 100% that the query abbove is correct, and i am now done for ideas. Is it a bug or just me🙁

Jonathan

[Anon]

Jonathan, probably you have to declare $cn in the same archive that you call $sql = mysql_query ("..., because it isn't a persistent connection. Try it ...

[Anon]

Think about it. If you include a php file from an http source that has php parsing turned on, what do you get out of that file?

I.e. if I create a file that looks lke this: ([ replaces angle brackets so they won't get eaten by phpbuilder.)

[?php
print "hello";
?]

and I include it like this:
include ("http://127.0.0.1/filename.php");

what am I including in my script? A file that says this:

hello

because the php is getting "eaten" by the parser, and the output of the php file is now just the word hello.

similarly, since you included your config file this way:

include("http://www.pagadoo.com/pagadoo_config.php");
it is getting interpreted and you are not getting any of your php code included in your program. Include it this way:

include ("path/file.php") and you're set. Or put it into a .txt file and include it your way, where it won't get interpreted (assuming you haven't set your web server to interpret php script in .txt files)

include ("http://myserver.com/path/file.txt"); should work.