Php+mysql page Break

In this program, the new class Fenye inherits the class Dbsql, so in the destructor of the new class, the destructor of the parent class is called to link the database, and the file config.inc.php defined by the global variable is included. /* There are three class functions in this paging class, the function of the first function says, the second function Caculate mainly calculates the total number of records in the recordset, how many pages are displayed, and assigns the results to the member variables for the next function to use the values. The third function, the URL, is the code that implements the recordset pagination display. Here, the paging algorithm mainly uses this SQL statement: SELECT * FROM table_name limit $start, $pageper; where $start is the starting position of the query, $pageper is the number of bars to display on each page. */ Include_once ("db.inc.php"); Class Fenye extends dbsql{ Public $count _1; Returns the total number of bars in the result recordset Private $pageper = 3; Number of recordset bars displayed per page Public $pc; Total number of pages displayed Private $sql = "SELECT * from students"; Public $offset; The current number of pages Public Function __constract () { Parent::__constract (); Call a method in the parent class to link the database } Public Function caculate ($sql = "") { $sql = $this->sql; $result =mysql_query ($sql) or Die (Mysql_error ()); $count =mysql_num_rows ($result); $this->count_1= $count; $PC =intval ($count/$this->pageper) +1; $this->pc= $pc; } Public function URL ($targetUrl) { $pagesize = $this->pageper; Show records per page $page =isset ($_get[' page ')? Intval ($_get[' page '): 1;//get the current page $sql = "SELECT * from students limit". ($page-1) * $pagesize. ", $pagesize"; echo $sql; exit; $results =mysql_query ($sql) or Die (Mysql_error ()); while ($row = Mysql_fetch_array ($results)) { for ($i =0; $i<> echo $row [$i]. " "; echo " "; } $offset = ($page-1) * $pagesize; $prepage = $page-1; Previous page $nextpage = $page +1; Next page $pagenav = "Total". $this->count_1. "Records $pagesize records per page, total". $this->pc. "Page, current section $page page"; if ($page ==1) { $strpage = "First page" "Previous page" "Next Page" "Last Page" "; } if ($page >1&& $page <= $this->pc) { $strpage = "First page" "Previous page" "Next Page" "Last Page" "; } if ($page = = $this->pc) { $strpage = "First page" "Previous page" "Next Page" "Last Page" "; } $strpage = "$pagenav $strpage "; Echo $strpage; } } /* Small function Annotations: Intval: Obtain an integer value; Count: Computes the number of elements of an array; Expression_1? Expression_2:expression_3;: If the first expression is a value, the return value of the function is the value of the second expression, otherwise the return value of the function is the value of the third expression. For the sake of security of the Code of the program, the type of the member variable of the class is set to private. */ ?> Copy Code

