Hit Counter in php


ok have found many forums on topic none answer question. want add visitor count detailed record page count hits specific record. (eg. http://nameofmysite.com/detailed.php?recordid=300)

i dont need results displayed on page want record number in main database named 'page' in 'hits' field. session variable nice. trying create top ten section based on number of hits. please help!

jh369057 wrote:
> ok have found many forums on topic none answer question.
> want add visitor count detailed record page count hits
> specific record. (eg. http://nameofmysite.com/detailed.php?recordid=300)

when create new record, set value of hits field 0.

in detailed.php add following code:

if (isset($_get['recordid'])) {
$rec = $_get['recordid'];
// add database connection code here

$sql = 'update nameoftable set hits = (hits + 1) recordid = '.
mysql_real_escape_string($rec);
mysql_query($sql);
}

--
david powers, adobe community expert
author, "the essential guide dreamweaver cs4",
"php solutions" & "php object-oriented solutions"
http://foundationphp.com/


More discussions in Develop server-side applications in Dreamweaver


adobe

Comments

Popular posts from this blog

Convierte tu Raspberry en un NAS. Firmware fvdw-sl 15.3 - Raspberry Pi Forums

How to format a Get Request

avrdude: verification error, first mismatch at byte 0x0000 0x0c != 0x62