[RESOLVED] 'include' not working

freedmania

I want to put all mySql queries in one script, sqlFetch2.php5, then include that script where desired.

The top of that script:

<?php 
session_start();
require_once('../../Connections/key2DB.php');

I include it in script bzz.php5. No problem.

I include it in script s_comp.php. I get

"Fatal error: main() [function.require]: Failed opening required '../../Connections/key2DB.php' (include_path='.:/usr/lib/php') in /homepages/26/d230240947/htdocs/client/appdev/ ... /sqlFetch2.php5 on line 3"

I think, perhaps, you can't include a php5 script in a php script, and save sqlFetch2.php, and include it. I get the same error message, only for "...sqlFetch2.php".

bzz.php5, as it happens, is called in an iframe inside s_comp.php. I comment out the iframe, comment out the bzz.php5 'include', do both: same error.

I've tried other stuff, too, some of which were actually embarrassing. All to no avail.

If anyone can tell me what's going on, and how to stop it, and how to do the include (if I can), it would mean a great deal to me.

Thanks,
- Paul

NogDog

The error message is simply telling you it could not open the include file. It could be because you gave it the wrong path, there is a misspelling somewhere in the path/filename, or the directories/file do not have the necessary permissions set to allow the Apache (or other web-server) user account to access that file.

freedmania

I don't know much about networks, servers, and the like. All I know about permissions relates to the little columns of letters I've seen in Ipswitch ftp clients. And just this second, when I went to log onto the site, it appeared to be down. Ftp works, but that may not be the same server, right? So who knows; this might be a server issue. The site's on The Other Guy's leased server space. I don't have direct contact with the hosting company, and he's not picking up his cell.

But while I'm waiting for something or somebody to do something, I was wondering: permissions have to do with ip addresses, yes? In other words, I may have permission to access file aaa.php, or I may not, but bbb.php cannot have its 'permission' to 'include' aaa.php rescinded, can it?

the same pathname works in another script in the same folder as s_comp.php. I've checked it over ten thousand times (and if you think I can't make the same mistake ten thousand times in a row, you just don't have faith).

Is incorrect pathname or lack of permission the only reason this won't work? And, what's with "(include_path='.:/usr/lib/php')"? That path, if it is good, is out of my reach.

Thanks,
Paul

NogDog

I suspect the issue is the script trying to do the include is in a different directory than the one you copied the command from. the ".." characters in the file path mean "go up one directory level". If the problematic file is at a different level in the file system directory hierarchy, then that would explain the problem. For this reason, when doing that sort of include, I find it more reliable and easier to copy-and-paste to use an "absolute" path instead of a "relative" path. You can make use of the $SERVER['DOCUMENT_ROOT'] variable to specify that the path start at the root of your web site, e.g.:

require_once($_SERVER['DOCUMENT_ROOT'] . '/Connections/key2DB.php');

freedmania

There's a dark possibility here: maybe I miscounted the little dots. That's the kind of thing I could do ten thousand times before it dawned on me to test it...

The applicable law here is, "First, test what you're sure you know."

If I ever regain access to this site, I'll let you know.

Thank you,
- Paul

freedmania

Um, it's working ...

thank you, NogDog.