require_once not finding file

[tbox]

I've structured my sites by defining functions that build certain elements within the site. I then simply call the relevant functions depending on the page. To make things simpler I have a page called holding_fns.php which simply uses the require_once function to include different subsets of functions ie. user authentication functions, display functions etc. That way each page only needs to include this one script in order to include all the functions it might need. HOWEVER...
I have a set of functions contained within a file called db_fns.php. This (obviously!) contains functions that relate to the database - specifically the function that opens a connection with the database. As such it has a username and password combination to allow this.
I would like, for obvious reasons, to move this file out of the public_html tree on my hosted server. I thought I could do this by using the following code:

require_once('../db_fns.php');

but for some reason this breaks the holding_fns.php script.
I thought this was straight forward. Any ideas why it's not working?!?!

[Mittineague]

If the file can't access the database from outside the root, it should be able to pull the data from outside the root. That is, db_fns.php could require_once "../db_data.php"

[tbox]

Thanks Mittineague. I think I understand what you're getting at. However, I'm not sure that's the problem.
The file db_fns file only has one function in it - the function that is called when a database connection is required. Surely this means that even if, as you say, the database can't be accessed from outside the root it doens't matter cos all I'm by the time the function is called it will have been required into another file. Does that make sense?
Are you suggesting I place the information needed to connect as variables in a file db_data.php, place that outside the root, then request that file into db_fns and use the variables within the function?

[guido2004]

However, I'm not sure that's the problem.

Try it

Btw, right now, are you getting any error?

[tbox]

Just tried it and it's still not happy. Because the function in db_fns now includes the require_once for db_data the site only breaks once the function is called. Still basically the same problem though. Getting a bit frustrating... Isn't this that any site with a database has to do?!?!?!

[guido2004]

the site only breaks once the function is called

What error do you get?

[tbox]

Warning: require_once(../../holding_db_data.php) [function.require-once]: failed to open stream: No such file or directory in /home/tourbox1/public_html/includes/holding_db_fns.php on line 4

Fatal error: require_once() [function.require]: Failed opening required '../../holding_db_data.php' (include_path=''.:/usr/lib/php:/usr/local/lib/php:/home/tourbox1/'') in /home/tourbox1/public_html/includes/holding_db_fns.php on line 4

[crmalibu]

To help you understand relative filepaths and how php tries to resolve them, make use of getcwd(). The value returned by getcwd() is the directory which php will try to resolve a relative file path from(well, it may also try to use the include path too, but lets ignore that for now).

For example,

echo getcwd() . '/../../holding_db_data.php';
require_once ('../../holding_db_data.php'); 

So if the value of getcwd() was
/home/foo/bar/baz

Then ../../holding_db_data.php
would resolve to /home/foo/holding_db_data.php


Keep in mind, when you include a file, it does not change php's current working dir. The current working directory is generally the directory of the first file executed.

[oddz]

If your host support $_SERVER['DOCUMENT_ROOT'] use it then remove the last directly and use it as your private root. Then anything that is above the site root simple place them together and you have a nice absolute path. Simple example:

define('PUBLIC_ROOT',$_SERVER['DOCUMENT_ROOT']);
define('PRIVATE_ROOT',str_replace('/httpdocs','',PUBLIC_ROOT));

require_once(PRIVATE_ROOT.'/db_fns.php'); 

where /httpdocs is the site root directory.