/*
$pageno 要显示的页号(从1算起)
$pagesize 每页行数
*/
function pagesel($sql, $conn, $pageno, $pagesize) {
$offs = ($pageno - 1) * $pagesize;
$sql .= " limit $offs, $pagesize";
return selAll($sql,$conn);
}
$list = selAll($sql,$conn);
改为
$list = pagesel($sql,$conn);翻页条代码自己写
$pageno 要显示的页号(从1算起)
$pagesize 每页行数
*/
function pagesel($sql, $conn, $pageno, $pagesize) {
$offs = ($pageno - 1) * $pagesize;
$sql .= " limit $offs, $pagesize";
return selAll($sql,$conn);
}
$list = selAll($sql,$conn);
改为
$list = pagesel($sql,$conn);翻页条代码自己写
$rs = mysql_query($sql,$conn);
if(!$rs) {
showError();
} $list = array(); while($row = mysql_fetch_assoc($rs)) {
$list[] = $row;
} return $list;
其中, $start = ($page - 1) * $pagesize;
$page >= 1