PHP? ? ?? ??? ???? ?? ??? ? ?? ?? ???? ?????.
? ??? ?? ???? ?? ??? ? ?? ??? ??? ??????.
??? ??? ??? ??? ????? ??? ??? ?? ????.
? ????? ?? ?? ??? ???? ??? ??? ?? ??? ?????.
WHERE ?? ??? ??? ??? ????? SQL LIKE ???? ?????.
??? ???? ??? ???? ?? ??? ??? ???.
<?php
$SQL = "SELECT * FROM yx_books where ".$_POST['seltype']." like ('%".$_POST['coun']."%')";
?>?? ? ???? ???? ???? ?? ?? ? ?? ?? ??? ?????.
<?php
$SQL = "SELECT * FROM yx_books where ".$_POST['seltype']." like ('%".$_POST['coun']."%') order by id desc limit $startno,$pagesize";
?>????? while ?? ?? ?????? ?? ???? ?????
<?php
while($rows=mysqli_fetch_assoc($rs))
{
?>
<tr align="center">
<td class="td_bg" width="7%"><?php echo $rows["id"]?></td>
<td class="td_bg" width="28%" height="26"><?php echo $rows["name"]?></td>
<td class="td_bg" width="12%" height="26"><?php echo $rows["price"]?></td>
<td class="td_bg" width="24%" height="26"><?php echo $rows["uploadtime"]?></td>
<td class="td_bg" width="12%" height="26"><?php echo $rows["type"]?></td>
<td class="td_bg" width="24%">
<a href="update.php?id=<?php echo $rows['id'] ?>" class="trlink">修改</a>
<a href="del.php?id=<?php echo $rows['id'] ?>" class="trlink">刪除</a></td>
</tr>
<?php
}
?>?? ????? ? ???, ?? ??? ? ?? ??? ??? ? ??? ??? ??? ????? ?? ?? ?? ??? ??? ?????.
<tr>
<th height="25" colspan="6" align="center" class="bg_tr">
<?php
if($pageno==1)
{
?>
首頁(yè) | 上一頁(yè) | <a href="?pageno=<?php echo $pageno+1?>">下一頁(yè)</a> |
<a href="?pageno=<?php echo $_POST['seltype']?>">末頁(yè)</a>
<?php
}
else if($pageno==$pagecount)
{
?>
<a href="?pageno=1">首頁(yè)</a> | <a href="?pageno=<?php echo $pageno-1?>">上一頁(yè)</a> | 下一頁(yè) | 末頁(yè)
<?php
}
else
{
?>
<a href="?pageno=1">首頁(yè)</a> | <a href="?pageno=<?php echo $pageno-1?>">上一頁(yè)</a> |
<a href="?pageno=<?php echo $pageno+1?>" class="forumRowHighlight">下一頁(yè)</a> |
<a href="?pageno=<?php echo $pagecount?>">末頁(yè)</a>
<?php
}
?>
頁(yè)次：<?php echo $pageno ?>/<?php echo $pagecount ?>頁(yè) 共有<?php echo $recordcount?>條信息 </th>
</tr>
