PHP+Mysql统计文件下载次数实例

php+mysql统计文件下载次数实例，实现的原理也很简单，是通过前台点击链接download.php传参id，来更新点击次数。

获取文件列表：

<小学生班规十条?php require 'conn.php';  $query = mysql_query("lect * from downloads"); $lists = array(); while ($row = mysql_fetch_assoc($query)) {     $l电能的单位是什么ists[] = $row; } ?>

读取文件列表，并加上download.php链接和参数id：

<ul class="filelist">     <?php foreach ($lists as $v) { ?>         <li><a href="download.php?id=<?php echo $v['id'] ?>"><?php echo $v['filenaps教程实例me'] ?><span class="downcount" title="下载次数"><?php echo $v['downloads'] ?></span><span class="download">点击下载元旦元宵捷报频传打一成语</span></a></li>                 <?php } ?> </ul>

点击下载按钮，累加文件次数：

$(function() {         $('ul.filelist a').live('click'我的故乡, function() {             var count = $('.downcount', this);             count.text(parint(count.text()) + 1);         }); });

download.php文件源码：

<?php $id = (int) $_get['id'];  if (!ist($id) || $id == 0)     die('参数错误!'); $query = mysql_query("lect * from downloads where id='$id'"); $row = mysql_fetch_array($query); if (!$row)     exit; $filename = iconv('utf-8', 'gbk', $row['filename']); //中文名称注意转换编码 $savename =  $row['savename']; //实际在服务器上的保存名称 $myfile = 'files/' . $savename; //文件  if (file_exists($myfile)) {     mysql_query("update downloads t downloads=downloads+1 where id='$id'");     $file = @ fopen($myfile, "r");     header("content-type: application/octet-stream");     header("content-disposition: attachment; filename=" . $filename);     while (!feof($file)) {         echo fread($file, 50000);     }     fclo($file);     exit; } el {     echo '文件不存在！'; } ?>

本文转自： 转载请注明出处！