A php+mysql paging class code
Release: 2016-07-25 08:52:47
Original
1294 people have browsed it
Paging class usage:
-
-
-
- include_once("fenye_php.php"); //Introduce class
- ///////// ////////////////////////////////////////////////////// ////////////
- $con = mysql_connect("localhost","root","");
- if (!$con)
- {
- die('Could not connect: ' . mysql_error ());
- }
mysql_select_db("myblog", $con);//Select the database
-
- $PAGE_SIZE=10;//Set the number displayed on each page
- //// ////////////////////////////////////////////////////// //////////////////
- $pageSupport = new PageSupport($PAGE_SIZE); //Instantiate PageSupport object
- $current_page=$_GET["current_page"];//Page current Number of pages
- if (isset($current_page)) {
- $pageSupport->__set("current_page",$current_page);
- } else {
- $pageSupport->__set("current_page",1);
- }
-
- $pageSupport->__set("sql","select * from article ");
- $pageSupport->read_data();//Read data
-
- if ($pageSupport->current_records > 0) // If the data is not empty, assemble the data
- {
- for ($i=0; $i<$pageSupport->current_records; $i++)
- {
- $title = $pageSupport->result[$i][" title"];
- $content = $pageSupport->result[$i]["content"];
-
- $part=substr($content,0,400);
- //Loop out each piece of data
- echo '< div class="index_side">
'.$title.'
- ';
- }
- }
- $pageSupport->standard_navigate(); //Call this function in the class to display paging HTML
- //Close the database
- mysql_close($con);
- ?> ;
-
Copy code
|
Statement of this Website
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
Latest Articles by Author
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31