Introducing aphp efficient data paging class,PHP MYSQL database basic functions,Get sequence ID,Get the Nth column data in the Nth record of strSql, the subscript starts from 1, Get the Nth record of strSql, Get the strSql record set Store in array. ##

The PHP smart paging class allows you to quickly set up page paging without debugging or cumbersome page style settings, making your work and life more convenient.

Introducing a php mysql paging class, which can query information by operating database files, and then use paging. Friends who need it can download it for reference, or they can modify the code themselves to achieve the desired effect. If your friends have better such libraries, you can send them to share and communicate with everyone.

Share aphp paginator program code,Function 1: Generate paging navigation based on the total number of pages, the current page, page grouping and url, Paging function parameter list (how many pages, current page, how many per page, link address). Function 2: According to the number of records, page columns are cleared, $page, current page; $row_num Total number of records; $pagesize: number of records per page; $url record page.

IntroductionA PHP paging display class, is used with MYSQL database, class does not provide the function of connecting to the database, and an external database connection needs to be established . The number of records is displayed per page by default. If not set, the default value is used. Displays the current page and the total number of pages. Display page turning buttons, including home page, next page, previous page, and next page, Display jump page selection box, Display all button components at once. #

What is introduced here is a shared PHP paging class, Parameters: sql statement, number of records per page, transfer link (such as "index.php?" or "index.php?sort =1&", etc.), The output url is index.php?page=23 or index.php?type=1&page=2 ( means page 23 or page Page 2 of Category 1).

Introducing a PHP paging class that connects to the database. A table is also required for testing. At least the fields announceID, announceContent, Get the value of the current page, which page it is, it must be a numeric integer, it must be >0, it must be <=$pageNUM, The first page, the last page page, two pages on the left and right of the current page, a total of five pages.

phpA paging class with relatively high functionality,This class is suitable for paging with database queries, and array paging, including page number index bar style, paging information style, set database type paging, Set array type paging, Database type calculates the total number of rows, Array type calculates the total number of rows, Calculate the total number of pages, calculate the current page number, set the page number index bar. #

Introducing a perfect php article pagination class. __construct is the constructor of SubPages, which is used to run automatically when creating a class. $each_disNums Number of entries displayed per page nums Total number of entries current_num The currently selected page sub_pages The number of pages displayed each time subPage_link Link to each page subPage_type Display the type of paging When subPage_type=1, it is normal paging mode example: 453 records in total, 10 records are displayed on each page, current page 1/453 [Home] [Previous page] [Next page] [Last page] When subPage_type=2, it is the classic paging style example: Current page 1/453 [Home] [Previous page] 1 2 3 4 5 6 7 8 9 10 [Next page] [Last page]

thinkphp comes with page class modifications. The official paging style format is fixed. We have to write the css style ourselves. Sometimes we don’t adapt to copying other people’s styles. , a small change has been added to support incoming styles. Friends can also make some modifications according to their own needs.

Introduces the common PHP encapsulated paging tool class in detail, which has certain reference value. Paging is basically used in every project, so encapsulate it into a Tool classes can be called directly in the future (although the TP framework is very powerful, it is not a bad idea to seal one yourself.), which saves time and effort and earns 'work points'.

Share a paging tool class implemented in php, Think of the middle one as a sliding fixed-length ruler, put $this-> _totalShowPages is treated as a sliding fixed-length ruler, then $this->_totalPages is a wooden block of a given length, and the ruler slides on this wooden block.