aid指静态页的标记(aid=1代表的是一个静态页面) click_num是对应的浏览次数
静态页
Insert title herephp统计静态html页面浏览访问次数代码
count.php
$aid = isset( $_GET['aid'] )?$_GET['aid']:'';
$t = isset( $_GET['t'] )?$_GET['t']:'';
if(intval( $aid )){
if( $t =='show' ){
echo "document.write('这里是显示浏览次数,可以从数据库读出来');";
}
else{
$conn = mysql_connect('localhost','root','root') ;
$sql = "Update count set click_num = click_num+1 where aid ='$aid'";
mysql_db_query('db_test',$sql,$conn);
}
}
?>
--
-- 表的结构 `count`
--
CREATE TABLE IF NOT EXISTS `count` (
`id` int(11) NOT NULL auto_increment,
`aid` int(11) default NULL,
`click_num` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;