Hi!

Ive tried to install a counter-script that displays the number of pageloads on my forum. The forum is made in php and are using mysql-database to store the articles that are possible to submit on the site. Ive tried several different counters which have used the “include” command to include the script on the page, in my case content.php.

The problem is that the counter are counting the total number of pageloads on all of the articles alltogether, instead of counting the number of pageloads on every unique article. The page that are calling the articles from the database are as I said content.php and every article are named content.php?article.1, content.php?article.2, content.php?article.3 etc. the number refering to the number in the database.

My question is:

Are there anyone who got a script or any suggestion on how I can manage to view the number of pageloads on every unique article? I just manage to view the total amount of pageloads.

I guess I, somehow have to have a unique code for each article but the prolem is how and what kind of code?

Hope you understood my problem.

Thanks for your help

Per

I use this code. It only records unique pageviews and not a page refresh

The MySQL table has two columns, page = pagename & count = number of unique views. call hitcount() before any headers are sent out or if you want to show the count on the page use $var = hitcount()

PHP Code:

<?php
session_start();

function hitcount($page) {
$page =  "'" . substr($page,0) . "'" ;
if (!isset($_SESSION[$page])) {
    $_SESSION[$page] = true;
$db = mysql_connect("server", "username", "password");
mysql_select_db("database", $db);
$sql ="SELECT * FROM table WHERE page=$page";
$result = mysql_query($sql);
$dbrow = mysql_fetch_array($result);
//$dbrow[1] is pagename ($page) $dbrow[2] is page views

if (is_null($dbrow[2])) {
$sql = "INSERT INTO table (page,count) VALUES ($page,1)";
} else {
$dbrow[2] = $dbrow[2] + 1;
 $sql = "UPDATE table SET count='$dbrow[2]' WHERE page= $page";
}
//echo $sql;
$result = mysql_query($sql);
$count = $dbrow[2];
mysql_close($db);
return $count;
}
}

?>

Does it display the counting on each article in the database for example

article.1 15 views, article.2 4 views etc.

It will store whatever you send as the parameter to the function as the pagename. So if you want the pagename to be "fred", Call the function as

PHP Code:

$var = hitcount("fred") 


and it will return with the pageview count for "fred".