
复制<?利用
PHP function pagetorecord($page,$pagecounts){ $result=($page-1)*$pagecounts; return $result; } function pagech($page,$j){ if($j==1){ $p=$page+1;} else{ $p=$page-1;} return $p; } $pagecounts=20; if($startpage){ $startpage=$startpage; } else{ $startpage=1; } $sqltr="select * from main order by sm limit ".pagetorecord($startpage,$pagecounts).",".$pagecounts; $connect=MySQL(和PHP搭配之最佳组合)_connect("localhost","http","something"); $select=MySQL(和PHP搭配之最佳组合)_select_db(book,$connect); $query=MySQL(和PHP搭配之最佳组合)_query(select count(*) as total from main,$connect); $totalrecord=MySQL(和PHP搭配之最佳组合)_result($query,0,"total"); $query=MySQL(和PHP搭配之最佳组合)_query($sqltr,$connect); echo "<tableborder=1cellpadding=0cellspacing=0>"; echo"<tr><td>序号</td><td>标准书号</td><td>书名</td><td>出版社</td><td>定价</td></tr>"; $i=1; while($array=MySQL(和PHP搭配之最佳组合)_fetch_array($query)){ printf("<tr><td>%d</td><td>%s</td><td>%s</td><td>%s</td><td>%f</td></tr>", $i,$array[bzsh],$array[sm],$array[cbs],$array[dj]); $i++; } echo"</table>"; echo"<hr>"; MySQL(和PHP搭配之最佳组合)_close($connect); if(0==$totalrecord%$pagecounts){ $totalpage=floor($totalrecord/$pagecounts);} else{ $totalpage=floor($totalrecord/$pagecounts)+1; } //echo $sqltr; if($startpage==1){ if($totalpage>1){ echo"首页 "; echo"前页 "; echo "<ahref=../../".basename($PHP_SELF)."?startpage=".pagech($startpage,1).">下页 </a>"; echo "<ahref=../../".basename($PHP_SELF)."?startpage=".$totalpage.">尾页</a> 共".$totalpage."页 第".$startpage."页"; } else{ echo"首页 "; echo"前页 "; echo"下页 "; echo"尾页 "; } } elseif($startpage==$totalpage){ echo "<ahref=../../".basename($PHP_SELF)."?startpage=1>首页 </a>"; echo "<ahref=../../".basename($PHP_SELF)."?startpage=".pagech($startpage,-1).">前页 </a>"; echo"下页 "; echo"尾页 共".$totalpage."页 第".$startpage."页"; } else{ echo "<ahref=../../".basename($PHP_SELF)."?startpage=1>首页 </a>"; echo "<ahref=../../".basename($PHP_SELF)."?startpage=".pagech($startpage,-1).">前页 </a>"; echo "<ahref=../../".basename($PHP_SELF)."?startpage=".pagech($startpage,1).">下页 </a>"; echo "<ahref=../../".basename($PHP_SELF)."?startpage=".$totalpage.">尾页</a> 共".$totalpage."页 第".$startpage."页"; } ?> 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.