PHP+Mysql分页
<?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>