下載文件的點(diǎn)擊數(shù)回填
更新時間:2006年10月09日 00:00:00 作者:
需要名稱為book的mysql數(shù)據(jù)庫表
表中含有下列字段:
id 下載的文件的唯一標(biāo)識
downnum 點(diǎn)擊數(shù)
first.php
<?while($myrow = @mysql_fetch_array($result))
{
?>
<TR>
<TD>
<?if(empty($myrow["downnum"])) echo "0"; else echo $myrow["downnum"]; ?>
</TD>
<TD>
<a href="ddload.php?purl=downfileurl&dnnum=<?echo $myrow['downnum'] ?>&id=<?echo $myrow['id']?>">click here download </a>
</TD>
</TR>
<?};?>
ddload.php
<?
include("data.inc.php");
if($incerror)
{
echo $incerror;
exit;
}
if(empty($dnnum)) $dnnum = 1;
else $dnnum ++;
$sql = "update book set downnum ='$dnnum' where id =$id";
mysql_query($sql);
mysql_close($connect);
header("location:$purl");
?>
表中含有下列字段:
id 下載的文件的唯一標(biāo)識
downnum 點(diǎn)擊數(shù)
first.php
<?while($myrow = @mysql_fetch_array($result))
{
?>
<TR>
<TD>
<?if(empty($myrow["downnum"])) echo "0"; else echo $myrow["downnum"]; ?>
</TD>
<TD>
<a href="ddload.php?purl=downfileurl&dnnum=<?echo $myrow['downnum'] ?>&id=<?echo $myrow['id']?>">click here download </a>
</TD>
</TR>
<?};?>
ddload.php
<?
include("data.inc.php");
if($incerror)
{
echo $incerror;
exit;
}
if(empty($dnnum)) $dnnum = 1;
else $dnnum ++;
$sql = "update book set downnum ='$dnnum' where id =$id";
mysql_query($sql);
mysql_close($connect);
header("location:$purl");
?>
相關(guān)文章
php學(xué)習(xí)筆記 數(shù)組的常用函數(shù)
只要一個變量,需要在多個方法使用,就將這個變量聲明為成員屬性,可以直接在這個對象中的所有方法中使用 成員屬性,相當(dāng)于這個對象中的全局變量2011-06-06PHP中在數(shù)據(jù)庫中保存Checkbox數(shù)據(jù)(2)
PHP中在數(shù)據(jù)庫中保存Checkbox數(shù)據(jù)(2)...2006-10-10php中數(shù)據(jù)的批量導(dǎo)入(csv文件)
php中數(shù)據(jù)的批量導(dǎo)入(csv文件)...2006-10-10