Page paging function_PHP tutorial

Provide an example classification function, friends in need can refer to it.

//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_count page with $rows records";
$pagenav .= "Homepage ";
$pagenav .= "Previous page ";
$pagenav .= "After One page ";
$pagenav .= "Last page";
$pagenav.=" Jump to n";
for($i=1;$i<=$ page_count;$i++){
if($i==$page) $pagenav.="$in";
else $pagenav. ="$in";
}
} // page paging function
// Usage example
if (!$conn = mysql tutorial_connect("localhost", "root","root")) die('Database tutorial 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;
?>

Look at the database structure below

Create a new database test
Execute the following statement (create a new table test: three fields of id, sex, 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

http://www.bkjia.com/PHPjc/444818.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/444818.htmlTechArticle provides an example classification function. Friends in need can refer to it. ?php tutorial // page paging function $page = $_get[page]; function page($rows,$page_size){ global $page,$selec...

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：php Memcached distributed cache (1/3)_PHP tutorialNext article：php Memcached distributed cache (1/3)_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