File into which a file is included

smurl

Hi, I have a file "global.php" - which contains my database connection.
If the database connection fails, I want it to redirect the user to a nice pretty page explaining all about the database error without any of the horrible mysql errors all over the place, which is easilly accomplishable.

<?
$connect=mysql_connect("localhost","user","xxx");
$select=mysql_select_db($database);

$ref=$_SERVER['HTTP_REFERER'];

if (!$connect) {
header("Location: http://www.site.com/databaseError.php?ref=$ref");
}
else {
header("Location: http://www.site.com/databaseError.php?ref=$ref");
}
?>

However, the above makes "ref" empty...
Basically, what I want to do is pass on the page into which global.php is being included, onto the databaseError.php page, so that it can then email me and tell me which page the database couldn't connect to.

For example:-

index.php has global.php included into it. The database won't connect. So I want it to then redirect the user to databaseError.php, and then that page to email me and tell me that the error occured whilst loading "index.php". Is there a way to do this? I know how to do the email etc. - i'm just not sure if you can find out which page the global.php was included into.

Thanks for your help if possible!
Carl

leatherback

If I remember correctly,

this:

$headertest = $_SERVER['REQUEST_URI'];

gives the value in the addressbar, which would be what you are looking for.

smurl

leatherback wrote:
If I remember correctly,

this:

$headertest = $_SERVER['REQUEST_URI'];

gives the value in the addressbar, which would be what you are looking for.

J.

Well I tried that... and it is giving me just the path from the root folder...
I guess it's better than nothing, but when my things are seperated over subdomains, I'm not sure what to do because what I really need is the whole URL for this to work properly... :S

Thankyou anyway!

smurl

<?
$connect=mysql_connect("localhost","user","xxx");
$select=mysql_select_db("database");

$ref=$_SERVER['SCRIPT_NAME'];
$host=$_SERVER['SERVER_NAME'];

$refurl="http://";
$refurl.=$host;
$refurl.=$ref;

if (!$connect || !$select) {

header("Location: http://www.site.com/databaseError.php?RefURL=$refurl");

}

?>

I ended up doing it that way. And it's working! But thankyou for the help 😃

dewen

$_SERVER['HTTP_REFERER'];

should be put in databaseError.php , to find out where the previous page coming from. Though it may not reliable since a broswer may not support reference

Do a

print_r[$GLOBALS]

to find out info you need

smurl

dewen wrote:
$_SERVER['HTTP_REFERER'];

should be put in databaseError.php , to find out where the previous page coming from. Though it may not reliable since a broswer may not support reference

Do a
print_r[$GLOBALS]
to find out info you need

Doing the refer thing in databaseError.php would just show me the url to the global.php file wouldn't it? shrug Oh well, what I'm using is good enough! 🙂 thanks

LoganK

The refer thing would show you the last page the user visited before going to databaseError.php. The last page would be something like index.php, user.php unless they explicitly went to global.php.