PHP paging function module sharing_PHP tutorial

Sharing the function module of PHP paging

What I want to share with you here is a list paging function module that I made some time ago (the function module of PHP paging), which is very simple and practical. , recommended to friends in need for reference.

Post a picture first to see the effect

Please post the code

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

$localhost = "localhost";

$username = "root";

$password = "root";

$db = "test"; //信息

$pagesize = 5;

$conn = mysql_connect($localhost,$username,$password); //链接数据库

if(!$conn){

echo "数据库链接失败".mysql_error();

}

mysql_query("SET NAMES 'UTF8'"); //编码转化

$db_select = mysql_select_db($db); //选择表

//查询记录总数

$total_sql = "select COUNT(*) from page";

$total_result = mysql_query($total_sql);

$total_row_arr = mysql_fetch_row($total_result);

$total_row = $total_row_arr[0]; //总条数

//总页数

$total = ceil($total_row / $pagesize);

//当前页数

$page = @$_GET['p'] ? $_GET['p'] : 1;

//limit 下限

$offset = ($page - 1)*$pagesize;

$sql = "select * from page order by id limit {$offset},{$pagesize}";

$result = mysql_query($sql);

echo "

PHP分页代码的小模块

";

echo "

";

echo "

";

while($row = mysql_fetch_assoc($result)){

$id = $row['id'];

$name = $row['name'];

echo "

";

}

echo "

ID	NAME
".$id."	".$name."

";

//上一页 、下一页

$pageprev = $page -1 ;

if($page > $total){

$pagenext = $total;

} else{

$pagenext = $page 1;

}

// 做链接 跳转；

echo "

上一页 丨下一页

";

 

mysql_free_result($result);

mysql_close($conn);

?>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

<🎜>$localhost = "localhost";<🎜> <🎜>$username = "root";<🎜> <🎜>$password = "root";<🎜> <🎜>$db = "test"; //Information<🎜> <🎜>$pagesize = 5;<🎜> <🎜>$conn = mysql_connect($localhost,$username,$password); //Link database<🎜> <🎜>if(!$conn){<🎜> <🎜>echo "Database connection failed".mysql_error();<🎜> <🎜>}<🎜> <🎜>mysql_query("SET NAMES 'UTF8'"); //Encoding conversion<🎜> <🎜>$db_select = mysql_select_db($db); //Select table<🎜> <🎜>//Query the total number of records<🎜> <🎜>$total_sql = "select COUNT(*) from page";<🎜> <🎜>$total_result = mysql_query($total_sql);<🎜> <🎜>$total_row_arr = mysql_fetch_row($total_result);<🎜> <🎜>$total_row = $total_row_arr[0]; //Total number of items<🎜> <🎜>//Total number of pages<🎜> <🎜>$total = ceil($total_row / $pagesize);<🎜> <🎜>//Current page number<🎜> <🎜>$page = @$_GET['p'] ? $_GET['p'] : 1;<🎜> <🎜>//limit lower limit<🎜> <🎜>$offset = ($page - 1)*$pagesize;<🎜> <🎜> <🎜> <🎜>$sql = "select * from page order by id limit {$offset},{$pagesize}";<🎜> <🎜>$result = mysql_query($sql);<🎜> <🎜>echo "

Small module for PHP pagination code

"; echo ""; echo ""; while($row = mysql_fetch_assoc($result)){ $id = $row['id']; $name = $row['name']; echo ""; } echo "

ID	NAME
".$id."	".$name."

"; //Previous page, next page $pageprev = $page -1 ; if($page > $total){ $pagenext = $total; } else{ $pagenext = $page 1; } // Make link jump; echo "

Previous page 丨Next page

"; mysql_free_result($result); mysql_close($conn); ?>

Key points:

1,

?

1	$sql = "select * from page order by id limit {$offset},{$pagesize}";

1

$sql = "select * from page order by id limit {$offset},{$pagesize}";

2.

The code is as follows:

echo "

Previous page 丨Next page

";

These two points are the key to embodying the art of paging technology and PHP code~

The above is all the content shared with you in this article. I hope you will like it.

http://www.bkjia.com/PHPjc/1017139.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1017139.html

TechArticle

Sharing the function module of php paging. What I want to share with you here is a function module for list paging that I made some time ago ( PHP paging function module), very simple and practical, recommended to those who have...