include problem

alexgeek · #1 Aug 1st, 2007, 10:50

Right,
I have a php script that shows how many users there are in the database:


<?php //how many users

$dbhost = "localhost";
$dbname = "web";
$dbuser = "alex";
$dbpass = "pass";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());


$userquery = "select username from users";
$douserquery = mysql_query($userquery) or die(mysql_error());
$userstotal = mysql_num_rows($douserquery);
echo "Currently we have " .$userstotal. " users";
?>

and I'm using this to link to it on the index.php page (root) :

PHP: Select all


<?php include('/content/totalusers.php'); ?>

But nothing turns up when i include it

i tried putting "12" before "<?php" and "34" after "?>" but it came up as "12 34".
What's wrong?
You can have more than 1 include on a page right?
Because it's also including 'navigation.php'
thanks

alexgeek · #2 Aug 1st, 2007, 10:52

oh forgot to say the script works,
as in just navigating to /content/totalusers.php
will show "Currently we have x users"

c010depunkk · #3 Aug 1st, 2007, 11:39

You can include more than one page, that's not the problem. Make sure the url is right (try replacing 'include' with 'require' and see if you get errors).

karinne · #4 Aug 1st, 2007, 12:06

You can use relative paths in include.

So your include should be something like this

PHP: Select all


<?php include('../content/totalusers.php'); ?>

alexgeek · #5 Aug 1st, 2007, 12:57

umm it still didn't work :/

RZX Developer · #6 Aug 1st, 2007, 13:58

hey try

Blake121 · #7 Aug 1st, 2007, 14:19

are you sure you have the path to the include right?

Where is the include found?
www.yourdomain.com/content/totalusers.php ? or something like www.yourdomain.com/php/content/totalusers.php ?

Maybe you should take the first slash off of the include path. Like this...

<?php include('content/totalusers.php'); ?>

alexgeek · #8 Aug 1st, 2007, 14:42

taking the slash of worked

thanks

Blake121 · #9 Aug 1st, 2007, 15:36

lol. No problem.

using the slash makes the url: http://www.yourdomain.com/content/
but without it makes it: http://www.yourdomain.com/yourfolder/content/

Just so you know.

ioncube · #10 Aug 8th, 2007, 08:19

Quote:

Originally Posted by Blake121

using the slash makes the url: http://www.yourdomain.com/content/
but without it makes it: http://www.yourdomain.com/yourfolder/content/

Just so you know.

True for the browser, but remember that PHP is server side, and when you include files with include/require (or better practice, include_once/require_once), then you are (usually) specifying and including a file path and not a URI.

So include('/content/totalusers.php') was trying to include totalusers.php from the directory /content (i.e. directory content in the root directory) rather than from the directory 'content' in the same directory as the main script. PHP will emit a warning when it cannot include a file,
but if displaying errors has been disabled then no error would be seen, and in
this case logging would probably be to a file. It's a good idea to find out where
errors are going as diagnosing problems is tricky without that!

Coding the correct include path can sometimes be tricky in PHP as the current directory
is not always where you expect it to be or the same in all cases. This is particularly the case if
file A.php includes subdir/B.php, and A.php is included from files in different directories.
One technique is to construct an absolute path based on where a script is running. The pseudo constant
__FILE__ holds the currently executing files full path, and using the function dirname(), you
can extract the directory in order to locate files relative to that.

e.g. in A.php:

include_once dirname(__FILE__) . '/subdir/B.php';

This ensures that no matter where A.php is located and independent of the current
directory, if subdir/B.php is always in the same directory as A.php
then A.php can include B.php no matter where the files are located, what the current
directory is and where A.php has been included from.

hth

c010depunkk · #11 Aug 8th, 2007, 13:56

*stands and gapes in awe of this wonderfully elegant solution to one of his biggest problems*
Now that was interesting.

Thanks ioncube

alexgeek · #12 Aug 8th, 2007, 14:14

Wow big post

and handy

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I use #include within an If Then statement?	Donny Bahama	Classic ASP	5	Jul 30th, 2006 18:29
js include	timmytots	JavaScript Forum	5	Jul 8th, 2006 12:43
JS include	timmytots	JavaScript Forum	5	Jun 16th, 2006 01:49
Help need with php include!!	allstar	PHP Forum	7	Dec 29th, 2005 15:09
Include Virtual on IIS	jakenoble	PHP Forum	3	Mar 8th, 2004 07:22

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
include problem