Simple implementation of PHP page code

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Database Operation Class Code: mysqli.func.php

[PHP]View Plain copy

2. <?php
4. Database Connection Constants
6. Define (' db_host ', ' localhost ');
8. Define (' Db_user ', ' root ');
10. Define (' db_pwd ', ');
12. Define (' db_name ', ' guest ');
16. Connecting to a database
18. Function Conn ()
20. {
22. $conn = Mysqli_connect (Db_host, Db_user, Db_pwd, db_name);
24. Mysqli_query ($conn, "set names UTF8");
26. return $conn;
28. }
32. Get the result set
34. function Doresult ($sql) {
36. $result =mysqli_query (Conn (), $sql);
38. return $result;
40. }
44. Result set to object collection
46. function dolists ($result) {
48. return Mysqli_fetch_array ($result, MYSQL_ASSOC);
50. }
54. function Totalnums ($sql) {
56. $result =mysqli_query (Conn (), $sql);
58. return $result->num_rows;
60. }
70. Close the database
72. function Closedb ()
74. {
76. if (! Mysqli_close ()) {
78. exit (' close exception ');
80. }
82. }
86. ?>

Pagination Implementation code:

[PHP]View Plain copy

2. <?php
4. Include ' mysqli.func.php ';
8. Total Record Count
10. $sql = "Select dg_id from Tb_user";
12. $totalnums = Totalnums ($sql);
16. Show number of bars per page
18. $fnum = 8;
22. Number of pages
24. $pagenum = ceil ($totalnums/ $fnum);
28. Page Constants
30. @$tmp = $_get[' page '];
34. Prevent malicious paging
36. if ($tmp > $pagenum)
38. echo "<script>window.location.href= ' index.php ' </script>";
42. Calculate Paging Start value
44. if ($tmp = = "") {
46. $num = 0;
48. } Else {
50. $num = ($tmp-1) * $fnum;
52. }
56. Query statements
58. $sql = "Select Dg_id,dg_username from Tb_user ORDER by dg_id DESC LIMIT". $num.  ", $fnum";
60. $result = Doresult ($sql);
64. Traverse output
66. while (!! $rows = dolists ($result)) {
68. echo $rows [' dg_id ']. " " . $rows [' Dg_username '].  "<br>";
70. }
74. Page link
76. for ($i = 0; $i < $pagenum; $i + +) {  
78. echo "<a href=index.php?page=". ($i + 1). ">". ($i + 1).  "</a>";
80. }
82. ?>

Simple to implement the paging function, the database please configure the structure

Simple implementation of PHP page code