访客计数器用于动态页面 - Visitor Counter For dynamic pages

Visitor Counter For dynamic pages

本文关键字：动态用于计数器访客 | 更新日期: 2023-09-27

我使用以下代码为我的动态网页，看起来像http://localhost/xxx/IND/xxxx/detail.php?v_id=VID1234567890.

当访问者计数器更新时它会更新所有的id

v_id |访问Vid1234567890 | 5Vid2234567890 | 5VID3234567890 | 5

<?php
$counter='';//initilize counter
$sql="SELECT hit FROM venue";
$result=mysql_query($sql);
$rows=mysql_fetch_assoc($result);
$counter=$rows['hit'];
// if count is empty
if(empty($counter)){
$counter=1;
$insertCounter="INSERT INTO venue set hit='".$counter."'";
$result1=mysql_query($insertCounter);
}
echo "You are visitor num=>". $counter;
// increment visitor count
$increasecounter=$counter+1;
$sql2="update venue set hit='".$increasecounter."'";
$result2=mysql_query($sql2);
?>

如何为不同的id显示不同的访问者计数器V_id |访问量Vid1234567890 | 10Vid2234567890 | 5VID3234567890 | 15

的问候Uttam

考虑创建一个带有vid字段的简单表

作为v_id是你表的输入

Insert into simple_table (vid) values ($v_id)

then list query

select vid, count(*) from simple_table group by vid;

以上查询将如下所示

VID1234567890 , 10 
VID2234567890 , 5 
VID3234567890 , 15