PHP+MySQL counter Help Needed

tyrol_gangster

i use the following visitors counter on my web and i am moving web to new server. on the old place, the counter runs ok, on the new one it adds count even when i reload the page. what could be wrong with the settings or whatever else when the code used is the same? or please does someone know other simple counter that counts only one visit from a user within specified time period???

<?
$SPath=$PATH_INFO;
$CookieDeath=720;
@$Conn=mysql_connect("s","s","s");
mysql_select_db("s");

if (empty($CounterID)){
$SQLText="SELECT FROM Tcounter WHERE SPath='$SPath'";
$result=mysql_query($SQLText);
if (mysql_num_rows($result)==0){
$SQLText="INSERT INTO Tcounter (SPath,Visits) VALUES ('$SPath',1)";
$result=mysql_query($SQLText);
$Visits=1;
$CounterID=mysql_insert_id($result);
}
else{
$row=mysql_fetch_array($result);
$Visits=++$row["Visits"];
$CounterID=$row["CounterID"];
$SQLText="UPDATE Tcounter SET Visits=$Visits WHERE CounterID=$CounterID";
$result=mysql_query($SQLText);
}
}
else{
$SQLText="SELECT Visits FROM Tcounter WHERE CounterID=$CounterID";
$result=mysql_query($SQLText);
$row=mysql_fetch_array($result);
$Visits=$row["Visits"];
}
mysql_close($Conn);
setcookie("CounterID",$CounterID,(time()+$CookieDeath60));

echo "$Visits";
?>

xblue

if on, $CounterID would get you a cookie value or a get or post parameter named CounterID.

if off, you need to address them differently
$_COOKIE['CounterID'] or $HTTP_COOKIE_VARS['CounterID'] (deprecated in current php versions) in your case.

tyrol_gangster

thx. i understand your answer that when register globals is set to ON, it should work. but when i run phpinfo on the new server, it says it is ON. so i am not sure if this is the problem... additionaly i remember i had some other php scripts not working on localhost in the past and the solution was in register globals, but these work fine on the server, so there must be some other problem...

anyway, just to make sure and give it a try, could you pls specify to a complete newbie, where to change the code? change all occurances of $CounterID to $_COOKIE['CounterID'] ???

tyrol_gangster

would this help?

OLD & WORKING FINE - http://www2.pipni.cz/phpinfo.php
NEW & WIRKING STRANGE - http://phpinfo.webdum.com/

tyrol_gangster

and what it also strange and did not occur on the old server is that when i set the counter to 0 (empty the table) and run it for the first time, it says (but shows 1):

Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in xxxxx/xxx/xxx/counter.php on line 14

then i hit F5 and the warning dissapears (but of course the damned numbers 2,3,4,5,6... appear which i would REALLY REALLY appreciate someone to tell me WHY THE HELL IT HAPPENS... PLEASE, i am sure it is nothing difficlut for people who unferstand this.

tyrol_gangster

and here is the table:

CREATE TABLE Tcounter(
CounterID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
SPath VARCHAR(122),
Visits INT
);