-------------------------------- PHP常用代码 1、连接MYSQL数据库代码 2、读取数据库,并实现循环输出 循环的内容......... 3、如何实现分页,包括两个函数,两个调用 1)两个函数 //分页函数 function genpage(&$sql,$page_size=2) { global $prepage,$nextpage,$pages,$sums; //out param $page = $_GET["page"]; $eachpage = $page_size; $pagesql = strstr($sql," from "); $pagesql = "select count(*) as ids ".$pagesql; $conn = mysql_query($pagesql) or die(mysql_error()); if($rs = mysql_fetch_array($conn)) $sums = $rs[0]; $pages = ceil(($sums-0.5)/$eachpage)-1; $pages = $pages>=0?$pages:0; $prepage = ($page>0)?$page-1:0; $nextpage = ($page<$pages)?$page+1:$pages; $startpos = $page*$eachpage; $sql .=" limit $startpos,$eachpage "; } //显示分页 function showpage() { global $page,$pages,$prepage,$nextpage,$queryString; //param from genpage function $shownum =10/2; $startpage = ($page>=$shownum)?$page-$shownum:0; $endpage = ($page+$shownum<=$pages)?$page+$shownum:$pages; echo "共".($pages+1)."页: "; if($page>0)echo "
首页"; if($startpage>0) echo " ...
?"; for($i=$startpage;$i<=$endpage;$i++) { if($i==$page) echo "
[".($i+1)."] "; else echo "
".($i+1)." "; } if($endpage<$pages) echo "
? ... "; if($page<$pages) echo "
尾页"; }...