给你一个简单又好用的
<?php
require './config.php';
$maxRows_rs = 22; //读取多少条
$page = 0;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$startRow_rs = $page * $maxRows_rs;mysql_select_db($database_conn, $conn);
$query_rs = "select a.id,a.acid,a.aname,a.adate,b.aid,b.arcname from yhar a join yharc b on(a.acid=b.aid) order by id desc";//改下SQL语句
$query_limit_rs = sprintf("%s LIMIT %d, %d", $query_rs, $startRow_rs, $maxRows_rs);
$rs = mysql_query($query_limit_rs, $conn) or die(mysql_error());
$row_rs = mysql_fetch_assoc($rs);if (isset($_GET['totalRows_rs'])) {
$totalRows_rs = $_GET['totalRows_rs'];
} else {
$all_rs = mysql_query($query_rs);
$totalRows_rs = mysql_num_rows($all_rs);
}
$totalPages_rs = ceil($totalRows_rs/$maxRows_rs)-1;$queryString_rs = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "page") == false &&
stristr($param, "totalRows_rs") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rs = "&" . htmlentities(implode("&", $newParams));
}
}
?>Two:
<?php if ($page > 0) { // Show if not first page ?>
<a href="<?php printf("%s?page=%d%s", $currentPage, 0, $queryString_rs); ?>">第一页</a>
<?php } // Show if not first page ?>
<a href="<?php printf("%s?page=%d%s", $currentPage, max(0, $page - 1), $queryString_rs); ?>">前一页</a> <a href="<?php printf("%s?page=%d%s", $currentPage, min($totalPages_rs, $page + 1), $queryString_rs); ?>">下一页</a>
<?php if ($page < $totalPages_rs) { // Show if not last page ?>
<a href="<?php printf("%s?page=%d%s", $currentPage, $totalPages_rs, $queryString_rs); ?>">尾页</a>
<?php } // Show if not last page ?>
共<?php echo $totalRows_rs ?> 记录 本页从 <?php echo ($startRow_rs + 1) ?>至<?php echo min($startRow_rs + $maxRows_rs, $totalRows_rs) ?>
<?php
require './config.php';
$maxRows_rs = 22; //读取多少条
$page = 0;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$startRow_rs = $page * $maxRows_rs;mysql_select_db($database_conn, $conn);
$query_rs = "select a.id,a.acid,a.aname,a.adate,b.aid,b.arcname from yhar a join yharc b on(a.acid=b.aid) order by id desc";//改下SQL语句
$query_limit_rs = sprintf("%s LIMIT %d, %d", $query_rs, $startRow_rs, $maxRows_rs);
$rs = mysql_query($query_limit_rs, $conn) or die(mysql_error());
$row_rs = mysql_fetch_assoc($rs);if (isset($_GET['totalRows_rs'])) {
$totalRows_rs = $_GET['totalRows_rs'];
} else {
$all_rs = mysql_query($query_rs);
$totalRows_rs = mysql_num_rows($all_rs);
}
$totalPages_rs = ceil($totalRows_rs/$maxRows_rs)-1;$queryString_rs = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "page") == false &&
stristr($param, "totalRows_rs") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rs = "&" . htmlentities(implode("&", $newParams));
}
}
?>Two:
<?php if ($page > 0) { // Show if not first page ?>
<a href="<?php printf("%s?page=%d%s", $currentPage, 0, $queryString_rs); ?>">第一页</a>
<?php } // Show if not first page ?>
<a href="<?php printf("%s?page=%d%s", $currentPage, max(0, $page - 1), $queryString_rs); ?>">前一页</a> <a href="<?php printf("%s?page=%d%s", $currentPage, min($totalPages_rs, $page + 1), $queryString_rs); ?>">下一页</a>
<?php if ($page < $totalPages_rs) { // Show if not last page ?>
<a href="<?php printf("%s?page=%d%s", $currentPage, $totalPages_rs, $queryString_rs); ?>">尾页</a>
<?php } // Show if not last page ?>
共<?php echo $totalRows_rs ?> 记录 本页从 <?php echo ($startRow_rs + 1) ?>至<?php echo min($startRow_rs + $maxRows_rs, $totalRows_rs) ?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货