<?php //分頁(yè)的函數(shù) function news($pageNum = 1, $pageSize = 5) { $array = array(); // $coon = mysqli_connect('rm-bp108931c0786t58eko.mysql.rds.aliyuncs.com','jjadmin','jj960820-COM','table_jjf'); $coon = mysqli_connect('localhost','root','96jj0820com','shuju'); mysqli_set_charset($coon, "utf8"); // limit為約束顯示多少條信息,后面有兩個(gè)參數(shù),第一個(gè)為從第幾個(gè)開(kāi)始,第二個(gè)為長(zhǎng)度 $rs = "select * from news limit " . (($pageNum - 1) * $pageSize) . "," . $pageSize ; $r = mysqli_query($coon, $rs); while ($obj = mysqli_fetch_object($r)) { $array[] = $obj; } mysqli_close($coon,"table_jjf"); return $array; } //顯示總頁(yè)數(shù)的函數(shù) function allNews() { // $coon = mysqli_connect('rm-bp108931c0786t58eko.mysql.rds.aliyuncs.com','jjadmin','jj960820-COM','table_jjf'); $coon = mysqli_connect('localhost','root','96jj0820com','shuju'); mysqli_set_charset($coon, "utf8"); $rs = "select count(*) num from news"; //可以顯示出總頁(yè)數(shù) $r = mysqli_query($coon, $rs); $obj = mysqli_fetch_object($r); mysqli_close($coon,"table_jjf"); return $obj->num; } @$allNum = allNews(); @$pageSize = 5; //約定每頁(yè)顯示幾條信息 @$pageNum = empty($_GET["pageNum"])?1:$_GET["pageNum"]; @$endPage = ceil($allNum/$pageSize); //總頁(yè)數(shù) @$array = news($pageNum,$pageSize); ?>
1。sql語(yǔ)句加上排序 你可以按時(shí)間排序或者按自增ID排序
2。沒(méi)有看到你的網(wǎng)站模板 不能指導(dǎo)你將信息輸出到頁(yè)面上