</form> <br> <table width="700" border="1"> <tr align="center" bgcolor="#CCCCCC"> <td>主題</td> <td>發表人</td> <td>發表時間</td> <td>最新回應時間</td> <td>回應數</td> </tr> <?php while ($record = mysql_fetch_array($result)) { echo '<tr>'; echo '<td><a href="view1.php?no=' . $record['boardNo'] . '">' . highlight_keyword($record['boardTopic'], $_POST['keyword']) . '</a></td>'; echo '<td>' . highlight_keyword($record['boardAuthor'], $_POST['keyword']) . '</td>'; echo '<td>' . $record['boardDatetime'] . '</td>'; // 取出最後回應時間 $lastReply = mysql_query("SELECT boardDatetime FROM board1 WHERE boardType = '" . $record['boardNo'] . "' ORDER BY boardDatetime DESC LIMIT 1;", $link_ID); $lastReplyDatetime = mysql_fetch_array($lastReply); echo '<td>' . $lastReplyDatetime['boardDatetime'] . '</td>'; // 計算回應數 $replyCount = mysql_num_rows(mysql_query("SELECT * FROM board1 WHERE boardType = '" . $record['boardNo'] . "';", $link_ID)); echo '<td>' . $replyCount . '</td>'; echo '</tr>'; } // 用完再關閉連線 mysql_close($link_ID); ?> </table>
?> </td> <td> <table width="100%" border="0"> <?php for ($i = 0; $i < 9; $i++) { if ($i % 3 == 0) { print '<tr>'; } print '<td width="300" align="center">'; if (isset($productTable[$i])) { print '<table width="80%" bgcolor="gray" border="1">'; print '<tr bgcolor="white" align="center"><td colspan="2"><a href="product_view.php?no=' . $productTable[$i]['productNo'] . '"><img src="img.php?no=' . $productTable[$i]['productNo'] . '" border="0" width="150" height="150"></a></td></tr>'; print '<tr bgcolor="white" align="center"><td colspan="2">' . highlight_keyword($productTable[$i]['productName'], $_GET['keyword']) . '</td></tr>'; print '<tr bgcolor="white" align="center"><td>售價:$' . number_format($productTable[$i]['productPrice']) . '</td><td>庫存:' . $productTable[$i]['productStock'] . '</td></tr>'; print '<tr bgcolor="white" align="center"><td colspan="2">' . highlight_keyword($productTable[$i]['productAbstract'], $_GET['keyword']) . '</td></tr>'; print '</table>'; } print '</td>'; if ($i % 3 == 2) { print '</tr>'; } } ?> <tr> <td colspan="2" align="right"> <?php if ($pageNo != 1) { echo '<a href="product.php?keyword=' . $_GET['keyword'] . '&page=' . ($pageNo - 1) . '">上一頁</a>'; } if ($pageNo != $pageTotal) {
"> <input type="submit" value="搜尋"> </form> <?php while ($record = mysql_fetch_array($result)) { echo '<table width="500" border="1">'; if ($check) { echo '<tr><td><a href="edit.php?no=' . $record['guestbookNo'] . '">修改</a> / <a href="delete.php?no=' . $record['guestbookNo'] . '">刪除</a></td></tr>'; } echo '<tr><td>'; echo highlight_keyword($record['guestbookName'], $keyword); if ($record['guestbookEmail']) { echo ' <<a href="mailto:' . $record['guestbookEmail'] . '">' . $record['guestbookEmail'] . '</a>>'; } echo '<font size="-2"> (' . $record['guestbookDatetime'] . ') </font>'; echo '</td></tr>'; echo '<tr><td>' . str_replace("\n", '<br>', highlight_keyword($record['guestbookContent'], $keyword)) . '</td></tr>'; echo '</table><br>'; } if ($pageNo != 1) { echo '<a href="search3.php?page=' . ($pageNo - 1) . '&keyword=' . $keyword . '">上一頁</a>'; } if ($pageNo != $pageTotal) { echo '<a href="search3.php?page=' . ($pageNo + 1) . '&keyword=' . $keyword . '">下一頁</a>'; } ?> </body> </html>