點閱次數:{BlogRec.blog_hits}作法
1.先在資料庫blog_msg資料表新增一個blog_hits欄位名稱
2.先新增一個updatehits.php/伺服器按加 / 點刪除紀錄
3.
if
((isset($_GET['blog_no'])) && ($_GET['blog_no'] != "")) {
$deleteSQL = sprintf("DELETE FROM blog_msg WHERE
blog_no=%s", GetSQLValueString($_GET['blog_no'], "int"));
mysql_select_db($database_blogConn,
$blogConn);
$Result1 = mysql_query($deleteSQL, $blogConn)
or die(mysql_error());
$deleteGoTo = "blognew.php";
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ?
"&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s",
$deleteGoTo));
}
將DELETE
FROM blog_msg WHERE blog_no=%s改成下面語法
update blog_msg
set blog_hits=blog_hits+1 WHERE blog_no=%s
4.blog.php
<h5
style="font-size:20px;color:black;text-align:left"><a
style="text-decoration: none;"
href="updatehits.php?blog_no=<?php
echo $row_BlogRec['blog_no']; ?>"><?php echo
$row_BlogRec['blog_subject']; ?></a> [<?php echo
$row_BlogRec['blog_postdate']; ?>]<span
style="font-size:14px;"> 點閱次數:<?php echo
$row_BlogRec["blog_hits"]+300;?></span></h5>
5.當按下blog.php主題連結到updatehits.php更新資料庫blog_hits+1後馬上跳轉到blognew.php