PHP paging function code (simple and practical)_PHP tutorial

Prepare data:

Create a new database test
Execute the following statement (create a new table test: three fields of id, sex and name)

CREATE TABLE `test` (
`id` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`sex` INT( 1 ) NOT NULL ,
`name` VARCHAR( 20 ) NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin;

Add data to the test table, for example:
1 1 Xiaoqiang
2 0 Xiaohong
3 0 Xiaoli
4 1 Xiaobing
5 1 Zhang San
6 0 Li Si
7 0 Wu Xin

Write PHP statement (index.php):

Copy code The code is as follows:

// Page paging function
$page = $_GET["page"];
function Page($rows,$page_size){
global $page,$select_from,$select_limit,$pagenav;
$page_count = ceil($rows/$page_size);
if($page <= 1 || $page == '') $ page = 1;
if($page >= $page_count) $page = $page_count;
$select_limit = $page_size;
$select_from = ($page - 1) * $page_size.', ';
$pre_page = ($page == 1)? 1 : $page - 1;
$next_page= ($page == $page_count)? $page_count : $page + 1 ;
$ pagenav .= "Page $page/$page_count total $rows records ";
$pagenav .= "Homepage ";
$pagenav .= "Previous page ";
$pagenav .= " ";
$pagenav .= "Last page";
$pagenav.=" Jump ton";
for($i=1;$i< =$page_count;$i++){
if($i==$page) $pagenav.="$in";
else $ pagenav.="$in";
}
} // Page paging function
// Usage example
if (! $conn= mysql_connect("localhost", "root" ,"root")) die('Database selection failed! ');
if (!mysql_select_db("test", $conn)) die('Database selection failed!');
mysql_query('set names GBK');
// Calculate using Page function Output $select_from which record to start retrieval, $pagenav output paging navigation
$rows = mysql_num_rows(mysql_query("select * from test"));
Page($rows,2);
$sql = "select * from test limit $select_from $select_limit";
$rst = mysql_query($sql);
while ($row = mysql_fetch_array($rst)){
echo "$row[id] - $row[sex] - $row[name]

---

";
}
echo $pagenav;
?>

Browse index.php Page, as shown in the picture:

It’s time to say byebye, it’s really easy to use!

PHP simple paging function
Written a simple PHP paging function, and the database calls are also written in it. People who use it can delete it by themselves!

Copy code The code is as follows:

function getask(){
$sql = "select * from cms_ask where ansower <> ' ' ";
//这里要改成方法
$q_sq = mysql_query($sql);
$count = mysql_num_rows($q_sq);
$page_size = 8;
$page_current = isset($GLOBALS['page']) ? intval($GLOBALS['page']) : 1;
$page_count = ceil($count / $page_size);
$page_start = $page_current - 4;
$page_end = $page_current + 4;
if ($page_current < 5) {
$page_start = 1;
$page_end = 5;
}
if ($page_current > $page_count - 4) {
$page_start = $page_count - 8;
$page_end = $page_count;
}
if ($page_start < 1)
$page_start = 1;
if ($page_end > $page_count)
$page_end = $page_count;
$pagebar = "";
$sql = "select * from cms_ask where ansower <> ' ' order by id desc limit " . (($page_current - 1) * $page_size) . "," . $page_size;
$row=$this -> user -> getall("$sql");
foreach($row as $v){
echo '

问：'.$v["question"].'

答：'.$v["ansower"].date("Y-m-d H:i:s",$v["postTime"]).'

';

}

$pagebar .= "

";
$pagebar .= "

";
if ($page_current != 1) {
$pagebar .= '
1. FIRST
';
}
for ($i = $page_start; $i <= $page_end; $i++) {
if ($i == $page_current) {
$pagebar .= "
2. " . $i . "
";
} else {
$pagebar .= "
3. " . $i . "
";
}
}

if ($page_current != $page_count) {
$pagebar .= "
4. END
";
}
$pagebar .= "

";
$pagebar .= "

";
echo $pagebar;
}

http://www.bkjia.com/PHPjc/322617.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/322617.htmlTechArticle准备数据： 新建一个数据库 test 执行下面的语句（新建一个表 test ：id、sex、name 三个字段） CREATE TABLE `test` ( `id` INT( 4 ) NOT NULL AUTO_INCREMEN...

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：Instructions for using php printf output format_PHP tutorialNext article：Instructions for using php printf output format_PHP tutorial

Related articles

See more

• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• All expression symbols in regular expressions (summary)

Public welfare online PHP training，Help PHP learners grow quickly！

About usDisclaimerSitemap

© php.cn All rights reserved