Simple counter question

chelsea7

Hello,

I have a question. I would like to know how to count the number of page visits to a page. I would like to keep it very simple in that I do not want to save the number to any file.

The use clicks on the link which will take him/her to another page and count the number on that page. The user clicks a link back to the first page then clicks the link again and the count now increases by one on the next page and so forth. Otherwise, the counter is not saved in a file. I just want the user to know how many times he/her visited the second page during that session.

Any assistance would be helpful.

Thanks

laserlight

Well, you would have to use some way of storing the count.

One way could be by a cookie, though since that creates a file on the user's comp it isnt what you want.

You probably could use the query string, but that would mean appending the name/value pair for each link so that the count is always passed.

benkillin

well, you would have to use a file to store the number, but here is some very simple code:

<?php
$root = $_SERVER['DOCUMENT_ROOT'];
$counter_path = "counters/counter.dat";
$size = filesize($root."/".$counter_path);
$fp = fopen($root."/".$counter_path, "r+");
flock($fp, LOCK_EX);
$hit = fread($fp, $size);
$hit++;
rewind($fp);
fwrite($fp, $hit);
flock($fp, LOCK_UN);
fclose($fp);
print "All pages on this site have been accessed a total of {$hit} times";
?>

chelsea7

O.K, guys. I figured it out. It was so simple I almost got sick. In my situation, I needed numbers to increment as the user scrolls through the database. So I used the session variable. See below;

session_start();
session_register('count');

// increment count

$count++;

echo $count;
$db=mysql_connect("localhost","user","password")
or die("Could not connect : " . mysql_error());
print "Connected successfully";
print "<br>";
mysql_pconnect();
mysql_select_db("mylogin") or die("Could not select database");

$query = ("SELECT * FROM myimagexx where ID=$count");

$result = mysql_query($query) or die("Query failed : " . mysql_error());

$num_rows = mysql_num_rows($result);

while ($row= mysql_fetch_array($result))

{
print "<table width=75% border=1>\n";
print "<td width=8%>";

$image = $row['imagefilepath'];
echo "<img src=$image>";

print "</td>";

 }

/* Free resultset */
mysql_free_result($result);

/* Closing connection */
mysql_close($db);

Right now, when the page is revisted by the user in the current session (here I just refresh the browser until I put the appropiate links in.), the $count increases by one. That number is then passed to the Where ID= query. I just have to clean up the script. But now I see how I can do it.

Thanks for your patience and assistance.