How to connect to db

boonboonie

I am attempting to connect to the database. I don't know what is wrong with this code?

Fatal error: Failed opening required 'cis-test/cis_connect.php' (include_path='./:/usr/local/lib/php') in /home/booa88/blaffffffdia-www/cis-test/Barriersquestions.php on line 18

Do I have the wrong path for the database I want to connect to?

This is the script in my connection script php page:

11 DEFINE (DB_USER, "xxxxxx");
12 DEFINE (DB_PASSWORD, "xxxxxx");
13 DEFINE (DB_HOST, "localhost");
14 DEFINE (DB_NAME, "xxxxxxxxxxx_com");
15 # display_members.php
16 $connection=mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

This is the code where my php page calls the connect php page

17 //Include the MySQL information
18 require_once ("cis-test/cis_connect.php");
19 $db=mysql_select_db(DB_NAME);

I am new to this but not to programming. Any suggestions?

Thanks

sincerely,

Sonac😕

LordShryku

It's saying it can't include the file. Is this dir and file in the web root or in /usr/local/lib/php?

cis-test/cis_connect.php

boonboonie

Hello LordShryku

I made a directory/folder I made off the root for all these files I am testing called: cis-test. Am I supposed to locate my .php in a different directory? My host had already set up the web site for MySQL and php but I have no idea how to locate those directories if I need them.

Thanks for your response.

LordShryku

Here's the problem. Your script is in
/home/booa88/blaffffffdia-www/cis-test

And you're trying to include
cis-test/cis_connect.php

So, it's looking for
/home/booa88/blaffffffdia-www/cis-test/cis-test/cis_connect.php

See the folder twice? If you're trying to include the file in the same folder, just call
require_once ("cis_connect.php");

boonboonie

Hi LordShryku,

Wow, that's so elementary. Great, I will try that out
thanks.

sonac.