21,886
社区成员
发帖
与我相关
我的任务
分享
<div id="show">
<?php
header('content-type:text/html;charset=utf-8;');
include 'function.php';
if (isset($_POST['num'])||isset($_GET['page'])) {
$pdo=new PDO("mysql:host=localhost;dbname=t1","root","");
session_start();
$_SESSION['num']=$_POST['num'];
$stmt3=$pdo->prepare("select * from table1 where num=?");
$stmt3->execute(array($_POST['num']));
$res3=$stmt3->fetchall();
$rows=count($res3);
$pagesize=5;
if($rows==0){
$pagenum=1;
}else{
$pagenum=ceil($rows/$pagesize);
}
if(isset($_GET['page'])){
$page=$_GET['page'];
if(empty($page)||$page<0||!is_numeric($page)) {
$page=1;
}else{
$page=intval($page);
}
}else{
$page=1;
}
if($page>$pagenum){
$page=$pagenum;
}
$startnum = ($page - 1)*$pagesize;
$display_page=5;
$query = "SELECT * FROM qq where num=? LIMIT $startnum,$pagesize";
$stmt=$pdo->prepare("$query");
//$stmt=$pdo->prepare("select * from table1 where num=?");
$stmt->execute(array($_POST['num']));
$res=$stmt->fetchall(PDO::FETCH_ASSOC);
$v = current($res);
if($res){
foreach($res as $v){
//echo '<h3><span>'.$v['num'].'</span></h3>' ;
echo '<h4>'.$v['name'].'</h4>';
}
}else{
echo "无数据";
}
}
?>
</div>
<div id="page">
<?php
if(isset($_POST['num'])||isset($_GET['page'])){
fenye();
}
?>
</div>
<div id="show">
<?php
header('content-type:text/html;charset=utf-8;');
include 'function.php';
$num = isset($_REQUEST['num'])? $_REQUEST['num'] : 0;
$page = isset($_REQUEST['page'])? $_REQUEST['page'] : 1;
$pdo=new PDO("mysql:host=localhost;dbname=t1","root","");
session_start();
$_SESSION['num']=$num;
$stmt3=$pdo->prepare("select * from table1 where num=?");
$stmt3->execute(array($num));
$res3=$stmt3->fetchall();
$rows=count($res3);
$pagesize=5;
if($rows==0){
$pagenum=1;
}else{
$pagenum=ceil($rows/$pagesize);
}
if($page){
if(empty($page)||$page<0||!is_numeric($page)) {
$page=1;
}else{
$page=intval($page);
}
}else{
$page=1;
}
if($page>$pagenum){
$page=$pagenum;
}
$startnum = ($page - 1)*$pagesize;
$display_page=5;
$query = "SELECT * FROM qq where num=? LIMIT $startnum,$pagesize";
$stmt=$pdo->prepare("$query");
//$stmt=$pdo->prepare("select * from table1 where num=?");
$stmt->execute($num);
$res=$stmt->fetchall(PDO::FETCH_ASSOC);
$v = current($res);
if($res){
foreach($res as $v){
//echo '<h3><span>'.$v['num'].'</span></h3>' ;
echo '<h4>'.$v['name'].'</h4>';
}
}else{
echo "无数据";
}
?>
</div>
<div id="page">
<?php
if($num || $page){
fenye($num, $page);
}
?>
</div>
<?php
function fenye($num){
global $page,$pagenum,$shoupage,$pageoffset;
echo "<div >";
echo "<ul id='ul2'>";
echo '<li>'.$page.'/'.$pagenum.'页|</li>';
if($page==1){
echo '<li>首页|</li>';
echo '<li>上一页|</li>';
}else{
echo '<li><a href="'.$_SERVER["SCRIPT_NAME"].'">首页</a>|</li>';
echo '<li><a href="'.$_SERVER["SCRIPT_NAME"].'?'.($page-1).'&num='.$num.'">上一页</a>|</li>';
}
$shoupage=5;
$pageoffset=($shoupage-1)/2;
$start=1;
$end=$pagenum;
if($pagenum>$shoupage){
if($page>$pageoffset){
$start=$page-$pageoffset;
$end=$pagenum>$page+$pageoffset?$page+$pageoffset:$pagenum;
}else{
$start=1;
$end=$pagenum>$shoupage?$shoupage:$pagenum;
}
if($page+$pageoffset>$pagenum){
$start=$start-($page+$pageoffset-$end);
}
}
echo '<div>';
echo '<ul id="ul1">';
for($i=$start;$i<=$end;$i++){
echo '<li><a href="'.$_SERVER["SCRIPT_NAME"].'?page='.$i.'&num='.$num.'">'.($i).'</a></li>';
}
echo '</ul>';
echo '</div>';
if($page==$pagenum){
echo '<li>|下一页|</li>';
echo '<li>尾页|</li>';
}else{
echo '<li>|<a href="'.$_SERVER["SCRIPT_NAME"].'?page='.($page+1).'&num='.$num.'">下一页</a>|</li>';
echo '<li><a href="'.$_SERVER["SCRIPT_NAME"].'?page='.$pagenum.'&num='.$num.'">尾页</a>|</li>';
}
echo '</ul>';
echo '</div>';
};
?>
然后调用改这样
<div id="page">
<?php
if($num || $page){
fenye($num);
}
?>
</div>