<?php
$conn = mysql_connect ( "localhost", "root", "root" );
mysql_select_db ( "test", $conn );
mysql_query ( "set names 'UTF-8'" );
$showNum = 4;
if ($_GET ['goPageNum']) {
$goPageNum = $_GET ['goPageNum'];
if ($goPageNum <= 0)
$goPageNum = 1;
} else {
$goPageNum = 1;
}
$nowShowBeginNum = ($goPageNum - 1) * $showNum; // 索引0算第一条数据
$sel_message = "select * from message limit $nowShowBeginNum,$showNum";
$que_message = mysql_query ( $sel_message ) or die ( "Invalid query: " . mysql_error () );
?>
<form action="" method="get">
<a href="?goPageNum=<?php echo ($goPageNum -1);?>">上一页</a> :<a href="?goPageNum=<?php echo ($goPageNum +1);?>">下一页</a><br/>
<?php
while ( $row_message = mysql_fetch_array ( $que_message ) ) {
echo $row_message ['id'] . " : " . $row_message ['title'] . " : " . $row_message ['content'] . "<br>";
}
?>
</form>