Php Include_once Doesn't Seem To Work From Html File

**mklappen** · November 29, 2007

Hi

With the recent upgrade to php5/mysql5 a counter script that I created count page hits of some of my html files and store in a MYSQL DB has stopped working...

Just before the header of my html file I have an @include_once function that use to execute my counter script everytime the html page was loaded. The url to the counter script contains 2 parameters (PHP_Self URL and the users ip address.) Once the counter script gets this information it updates or inserts a mysql table.

I can execute the counter script manually by cut/paste it into the browser, it updates the mysql table with no issues. For some reason however it does not do this in the html file through the include_once(). This has been working for the past 6-9 months up until yesterday or the day before and code hasn't changed.

Any thoughts or recommendations on how to get this working again are greatly appreciated.

PHP code inside my html file. It includes the include_once() which should call the counter script every time the page is loaded.

><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<?php
	if (getenv(HTTP_X_FORWARDED_FOR)) {
		$ip   = getenv("HTTP_X_FORWARD_FOR");
		$host = gethostbyaddr($ip);
	} else {
		$ip   = getenv("REMOTE_ADDR");
		$host = gethostbyaddr($ip);
}
@include_once("http://www.mysite.com/counter.php?ip=$ip&url={$_SERVER[PHP_SELF]}");

/* just created this var for troubleshooting...the $curl returns the correct path and parameters. If I cut paste this exact variable when renedered in browser, Mysql table is updated w/o problems */

$curl = "http://www.mysite.com/counter.php?ip=$ip&url={$_SERVER[PHP_SELF]}";
echo "CounterURL: $curl";
?>
<head>
	<title> page title </title>
	<meta> etc....
	
	No more PHP code on page....

Here is my counter.php again this has been working on php4 for the past 6-9 months w/o issues.

><?php
require_once('mysql_connect.php'); //connection to DB
$URL = $_GET['url']; //get url parameter from url that is passed through the @include_once()
$ip = $_GET['ip']; //get ip parameter from url that is passed through the @include_once()

//troubleshooting variables...when executing from browser these variables are returned correctly
echo "URL: $URL<br>";
echo "ip: $ip<br>";
	
$qip = "SELECT COUNT(url) as ct FROM ipaddr WHERE url='$URL' and date=CURDATE() and ip='$ip'";
$rip = @mysql_query($qip);
$rowip = @mysql_fetch_array($rip,MYSQL_ASSOC);

//if user ip address is NOT in db for curdate then add info to ipaddr table and counter table.
if($rowip['ct'] == 0) {
	$i1 = @mysql_query("Insert INTO ipaddr(url,ip,date) Values('$URL','$ip','CURDATE()')");
	$qurl = "SELECT url FROM counter WHERE url='$URL' and date=CURDATE()";
	$rurl = @mysql_query($qurl);

	if(@mysql_num_rows($rurl) == 0) {
		$query = @mysql_query("INSERT INTO counter(url,count,date) VALUES('$URL','1',CURDATE())");
	}
	else {
		$query = @mysql_query("UPDATE counter SET count=count+1 WHERE url='$URL'");

	}
}
?>

**TCH-Andy** · November 29, 2007

Try changing the http ://www.mysite.com/counter.php to just counter.php

I assume you have a line in the htaccess to interpret html files as php ?

**TCH-James** · November 29, 2007

In PHP5, URL based includes are disabled. This helps avoid any remote URL injections.

Another option for include is to use the system path to the file:

>include_once($_SERVER['DOCUMENT_ROOT']."counter.php?ip=$ip&url={$_SERVER[PHP_SELF]}")

**mklappen** · November 29, 2007

In PHP5, URL based includes are disabled. This helps avoid any remote URL injections.

Another option for include is to use the system path to the file:
>include_once($_SERVER['DOCUMENT_ROOT']."counter.php?ip=$ip&url={$_SERVER[PHP_SELF]}")

Thanks, I will try that...I need to have the doc root since my counter script is in my home dir while the htm files are all over the place.

**mklappen** · November 29, 2007

ok, I've changed my include once to use the $_SERVER['DOCUMENT_ROOT'] but I'm now receiving the follow errors (I removed the @ from my include_once so I could see the errors it was throwing.)

Not sure why it throws a failed to open stream: No Such file or directory since my include is calling something from another directory.

Also don't know much about the second inclusion error.

Thanks in advance for any help.

>Warning: include_once(/home/mydomain/public_html/counter.php?ip=99.999.999.99&url=/mydir/mysubdir/mysubsubdir/index.htm) [function.include-once]: failed to open stream: No such file or directory in /home/mydomain/public_html/mydir/mysubdir/mysubsubdir/index.htm on line 20

Warning: include_once() [function.include]: Failed opening '/home/mydomain/public_html/counter.php?ip=99.999.999.99&url=/mydir/mysubdir/mysubsubdir/index.htm' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mydomain/public_html/mydir/mysubdir/mysubsubdir/index.htm on line 20

This is my new include statment which is line 20 referenced in the errors above.

**mklappen** · November 30, 2007

yeah i figured it out and got it fixed, found a small reference to it on php.net...when using the include whith the directory path I needed to remove my parameters after the counter.php, instead I passed them as variables using $_GET in both the counter.php and my .htm files.

So just in case anyone else runs into the problem with php5

This does not work because of the URL path:

><?php include_once("http://www.mysite.com/counter.php?ip=$ip&url={$_SERVER[PHP_SELF]}"); ?>

I used the follow which now has my counter working again!

>//in htm file
<?php	
$_GET['ip'] = $ip;
$_GET['url'] = $_SERVER[PHP_SELF];
include_once("/home/*****/public_html/counter.php");	
?>

Then I used the same $_GET calls in my counter.php script.

Sign In

Php Include_once Doesn't Seem To Work From Html File

Recommended Posts

mklappen

TCH-Andy

TCH-James

mklappen

mklappen

mklappen

Join the conversation

Hosting