</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>
