<?php require_once('Connections/search.php'); ?>
<?php
$aaaaa = $_POST['search'];
?>
<?php
$maxRows_search = 10;
$pageNum_search = 0;
if (isset($_GET['pageNum_search'])) {
$pageNum_search = $_GET['pageNum_search'];
}
$startRow_search = $pageNum_search * $maxRows_search; mysql_select_db($database_search, $search);
$query_search = "Select name From title Where LOWER(name) like LOWER('%$aaaaa%')";
$query_limit_search = sprintf("%s LIMIT %d, %d", $query_search, $startRow_search, $maxRows_search);
$search = mysql_query($query_limit_search, $search) or die(mysql_error());
$row_search = mysql_fetch_assoc($search); if (isset($_GET['totalRows_search'])) {
$totalRows_search = $_GET['totalRows_search'];
} else {
$all_search = mysql_query($query_search);
$totalRows_search = mysql_num_rows($all_search);
}
$totalPages_search = ceil($totalRows_search/$maxRows_search)-1;
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP分页显示</title>
</head> <body>
<p>
<?php do { ?>
<?php echo $row_search['name']; ?><br />
<?php } while ($row_search = mysql_fetch_assoc($search)); ?>
</p>
<p> </p>
</body>
</html>
<?php
mysql_free_result($search);
?> 上面这段是显示搜索结果的代码,用的POST传递,文本域名是search,每页显示十条~我想加一个分页显示的功能,我用DW自带的生成上一页下一页等功能,在翻页的时候总是无法传递SEARCH值~变成显示全部数据~从网上弄了几十个分页显示源码~总是显示错误~可能是我位置放错了~麻烦各位大哥帮我修改一下这个~给里面加上(第一页,上一页,下一页,最后一页等功能,谢谢)
我初学~这个问题困扰了我很多天,在网上问了很多~翻了很多代码~
麻烦各位讲的详细一些~~~~~最好能帮我把代码嵌套到里面~~~~~谢谢了~~~~~~~
<?php
$aaaaa = $_POST['search'];
?>
<?php
$maxRows_search = 10;
$pageNum_search = 0;
if (isset($_GET['pageNum_search'])) {
$pageNum_search = $_GET['pageNum_search'];
}
$startRow_search = $pageNum_search * $maxRows_search; mysql_select_db($database_search, $search);
$query_search = "Select name From title Where LOWER(name) like LOWER('%$aaaaa%')";
$query_limit_search = sprintf("%s LIMIT %d, %d", $query_search, $startRow_search, $maxRows_search);
$search = mysql_query($query_limit_search, $search) or die(mysql_error());
$row_search = mysql_fetch_assoc($search); if (isset($_GET['totalRows_search'])) {
$totalRows_search = $_GET['totalRows_search'];
} else {
$all_search = mysql_query($query_search);
$totalRows_search = mysql_num_rows($all_search);
}
$totalPages_search = ceil($totalRows_search/$maxRows_search)-1;
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP分页显示</title>
</head> <body>
<p>
<?php do { ?>
<?php echo $row_search['name']; ?><br />
<?php } while ($row_search = mysql_fetch_assoc($search)); ?>
</p>
<p> </p>
</body>
</html>
<?php
mysql_free_result($search);
?> 上面这段是显示搜索结果的代码,用的POST传递,文本域名是search,每页显示十条~我想加一个分页显示的功能,我用DW自带的生成上一页下一页等功能,在翻页的时候总是无法传递SEARCH值~变成显示全部数据~从网上弄了几十个分页显示源码~总是显示错误~可能是我位置放错了~麻烦各位大哥帮我修改一下这个~给里面加上(第一页,上一页,下一页,最后一页等功能,谢谢)
我初学~这个问题困扰了我很多天,在网上问了很多~翻了很多代码~
麻烦各位讲的详细一些~~~~~最好能帮我把代码嵌套到里面~~~~~谢谢了~~~~~~~
$resultc=mysql_query($execc);
$rsc=mysql_fetch_array($resultc);
$num=$rsc[0];
这样可以得到记录总数
ceil($num/10))如果一页10记录的话,这个就是总的页数 所以可以这么写
if(empty($_GET['page']))
{
$page=0;
}
else
{
$page=$_GET['page'];
if($page<0)$page=0;
if($page>=ceil($num/10))$page=ceil($num/10)-1;//因为page是从0开始的,所以要-1
} 这样$exec可以这么写 $exec="select * from tablename limit ".($page*10).",10";
//一页是10记录的 最后我们需要做的就是几个连接:
<a href="xxx.php?page=0">FirstPage</a>
<a href="xxx.php?page=<?=($page-1)?>">PrevPage</a>
<a href="xxx.php?page=<?=($page+1)?>">NextPage</a>
<a href="xxx.php?page=<?=ceil($num/10)-1?>">LastPage</a>