PHP分頁_PHP教程

今天在工作之餘寫的一段PHP分頁處理指令碼，歡迎拍磚！！！顯示頁面 index.php

分頁處理函數 showbbsProcess.php

作者：'.$arr[$i]['poster'].' '.'發布時間：'.$arr[$i]['posted'].'
';//如果遍曆完$arr數組裡的所以元素，即$i（$i從0開始）等於數組的元素個數減一，則跳出2層迴圈（for迴圈和foreach迴圈）if ($i==(count($arr)-1))break 2;}}$RowCount=getRowCount($connectmysql);//一共有多少條記錄$PageCount=ceil($RowCount/$PageSize);//共有幾頁,ceil()函數進一取整echo '文章統計：'.$RowCount.'條'.' '.'共有'.$PageCount.'頁 ';//當為第一頁時不輸出“上一頁”if ($CurrentPageID != 1){echo "上一頁";}//向前跳頁if ($CurrentPageID > 2){echo " <<< ";}//輸出詳細的頁數，如：【1】for ($j=1;$j<=$PageCount;$j++){echo "[$j]";}//向後跳頁if ($CurrentPageID <= ($PageCount-2)){echo " >>> ";}//當為最後一頁時不輸出“下一頁”if ($CurrentPageID != $PageCount){echo "下一頁";}$connectmysql->closeConn();}

與資料庫溝通的函數 showbbs_fun.php

getRowsArray($sql);return $arr1;}//該函數用來查詢資料庫的表的行數function getRowCount($connectmysql){$sql="select * from db_content";$num=$connectmysql->getRowsNum($sql);return $num;}

資料庫類 connectMysql.php

conn=mysql_connect($this->host,$this->username,$this->password);@mysql_select_db($this->dbname,$this->conn);mysql_query('set names utf-8');}//查詢結果function getResult($sql){if ($this->conn==''){$this->conndb();}$this->result=mysql_query($sql,$this->conn);}//返回查詢的記錄數function getRowsNum($sql){$this->getResult($sql);$num_rows=mysql_num_rows($this->result);if (mysql_errno()==0){return $num_rows;}else {return '';}}//將結果輸出為一個單條記錄數組並返回function getArray($sql){$this->getResult($sql);if (mysql_errno()==0){$this->resultArray=mysql_fetch_array($this->result,MYSQL_ASSOC);//得到關聯陣列return $this->resultArray;}else {return '';}}//返回一個含有多條記錄的二維數組function getRowsArray($sql){$this->getResult($sql);if (mysql_errno()==0){while ($row=mysql_fetch_array($this->result,MYSQL_ASSOC)){$this->rowsArray[]=$row;}return $this->rowsArray;//print_r($this->rowsArray);exit;}else {return '';}}//更新、添加、刪除function uidresult($sql){if ($this->conn==''){$this->conndb();}//echo $sql;//exit;@mysql_query($sql);$this->rowsNum=@mysql_affected_rows();if (mysql_errno()==0){return $this->rowsNum;}else {return '';}}//釋放結果集function freeResult(){mysql_free_result($this->result);$this->rowsNum=0;$this->rowsArray='';$this->resultArray='';}//關閉資料庫function closeConn(){$this->freeResult();mysql_close($this->conn);$this->conn='';}}

http://www.bkjia.com/PHPjc/755766.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/755766.htmlTechArticle今天在工作之餘寫的一段PHP分頁處理指令碼，歡迎拍磚！！！顯示頁面 index.php 分頁處理函數 showbbsProcess.php 作者：'.$arr[$i]['poster'].' '.'發布時...

