[請益] 留言板編號遞補

看板PHP作者mabinogi (柳生)時間11年前 (2014/10/01 00:28)推噓2(2推 0噓 12→)

留言14則, 4人參與討論串1/1

因為剛開始學PHP所以有點卡關，所以來請教各位留言板想要做成遞補形式 (舉例來說有三篇留言，編號是01 02 03 如果刪掉第二篇，03會自己遞補成02) 我是照著書做的，但是他顯示我沒有定義 $totalRows_RecBoard 與$pageNum_RecBoard 有點不太懂他的意思是要我在哪邊補什麼所以附上程式碼的部分 <?php header("Content-Type: text/html; charset=utf-8"); require_once("connMysql.php"); $pageRow_records = 5; $num_pages = 1; if (isset($_GET['page'])) { $num_pages = $_GET['page']; } $startRow_records = ($num_pages -1) * $pageRow_records; $query_RecBoard = "SELECT * FROM `board` ORDER BY `boardtime` DESC"; $query_limit_RecBoard = $query_RecBoard." LIMIT ".$startRow_records.", ".$pageRow_records; $RecBoard = mysql_query($query_limit_RecBoard); $all_RecBoard = mysql_query($query_RecBoard); $total_records = mysql_num_rows($all_RecBoard); $total_pages = ceil($total_records/$pageRow_records); ?> <!doctype html> <html> <head> <meta charset="utf-8">  <title>歡迎光臨螳螂科技教學網站--Welcome to the Mantis Technology Teaching Website--</title>  <link href="css/screen.css" rel="stylesheet" type="text/css" media="screen">   </head> <body> <div id="wrapper"> <div id="con"> <div id="header"><img src="image/banner.png" width="940" height="350"></div> <div id="navigation"> <ul> <li><a href="member_center.php">關於我們</a></li> <li>│</li> <li><a href="album.php">圖片展示</a></li> <li>│</li> <li><a href="member_join.php">加入會員</a></li> <li>│</li> <li><a href="post.php">留言板</a></li> <li>│</li> <li><a href="mindex.php">行動裝置</a></li> <li>│</li> <li>購物車</li> <li>│</li> <li><a href="outlook.php">聯絡我們</a></li> </ul> </div>  <div id="content"> <h1>訪客留言板</h1> <?php $countNo = $totalRows_RecBorder; if($pageNum_RecBorder>0){ $countNo = $totalRows_RecBorder - $pageNum_RecBorder * $maxRows_RecBorder; } ?> <?php while($row_RecBoard=mysql_fetch_assoc($RecBoard)){ ?> <table width="90%" border="0" align="center" cellpadding="4" cellspacing="0"> <tr valign="top"> <td width="96" align="center"><?php if($row_RecBoard["boardsex"]=="男"){;?> <img src="image/male.gif" alt="我是男生" width="49" height="49"> <?php }else{?> <img src="image/female.gif" alt="我是女生" width="49" height="49"> <?php }?> <br> <?php echo $row_RecBoard["boardname"];?></td> <td width="563">[<?php echo $countNo;$countNo--;?>] <?php echo $row_RecBoard["boardsubject"];?> <p><?php echo nl2br($row_RecBoard["boardcontent"]);?></p> <p align="right"><?php echo $row_RecBoard["boardtime"];?> <?php if($row_RecBoard["boardmail"]!=""){?> <a href="mailto:<?php echo $row_RecBoard["boardmail"];?>"><img src="image/email-a.png" alt="電子郵件" width="16" height="16" border="0" align="absmiddle"></a> <?php }?> <?php if($row_RecBoard["boardweb"]!=""){?> <a href="<?php echo $row_RecBoard["boardweb"];?>"><img src="image/home-a.png" alt="個人網站" width="16" height="16" border="0" align="absmiddle"></a> <?php }?> </p></td> </tr> </table> <?php if($row_RecBoard["pons"]!=""){?> <table width="90%" height="44" border="0" align="center" cellpadding="0" cellspacing="0" class="pons"> <tr> <td width="24%" align="right">版主回復：</td> <td width="76%"><?php echo nl2br($row_RecBoard["pons"]);?></td> </tr> </table><?php }?><?php }?> <table width="90%" border="0" align="center" cellpadding="4" cellspacing="0"> <tr> <td valign="middle"><p>資料筆數：<?php echo $total_records;?></p></td> <td align="right"><p> <?php if ($num_pages > 1) { ?> <a href="?page=1">第一頁</a> | <a href="?page=<?php echo $num_pages-1;?>">上一頁</a> | <?php }?> <?php if ($num_pages < $total_pages) { ?> <a href="?page=<?php echo $num_pages+1;?>">下一頁</a> | <a href="?page=<?php echo $total_pages;?>">最末頁</a> <?php }?> </p></td> </tr> </table> </div>  <div id="slider"><img src="image/logo.png" width="200" height="291">  <div id="fb-root"></div> <script>(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = "//connect.facebook.net/zh_TW/sdk.js#xfbml=1&version=v2.0"; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));</script> <div class="fb-like-box" data-href="https://www.facebook.com/pages/Test/1410495552555771?ref_type=bookmark" data-width="200" data-height="300" data-colorscheme="light" data-show-faces="true" data-header="true" data-stream="false" data-show-border="true"></div> </div>  <div id="footer"> <p>螳螂科技工作室代表號：04-776-0000 傳真：04-776-0000聯絡人：信箱 c77XXX25@ms2.hinet.net<br /> Copyright©2014All rights reserved.Mantis Technology Workshop </p> </div> </div> </div> </body> </html> 卡了好幾天，麻煩幫我解惑謝謝！ -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.44.120.191 ※ 文章網址: http://www.ptt.cc/bbs/PHP/M.1412094530.A.9FA.html