Phpadodb paging implementation code

Php uses adodb paging to implement code The code is as follows:

Include ("adodb/adodb. inc. php"); // contains the adodb class library file
Include ("adodb/adodb-pager.inc.php"); // contains the adodb-pager class library file
$ Conn = NewADOConnection ('mysql'); // creates an adodb object and declares that the database type is mysql.
$ Conn-> Connect ("localhost", "root", "1981427", "test"); // Connect to the database, where mydb is the database name
$ SQL = "select * from tablename1"; // defines the SQL statement to be executed

$ Pager = new ADODB_Pager ($ conn, $ SQL); // Create a paging object based on the connection object and SQL statement
$ Pager-> Render (3); // output the page with three records on each page
?>

The code is as follows:

Include ("adodb/adodb. inc. php"); // contains the adodb class library file
Include ("adodb/adodb-pager.inc.php"); // contains the adodb-pager class library file
$ Conn = NewADOConnection ('mysql'); // creates an adodb object and declares that the database type is mysql.
$ Conn-> Connect ("localhost", "root", "1981427", "test"); // Connect to the database, where mydb is the database name
$ SQL = "select id as 'number', username as 'name', password as 'password' from tablename1"; // define the SQL statement to be executed

$ Pager = new ADODB_Pager ($ conn, $ SQL); // Create a paging object based on the connection object and SQL statement
$ Pager-> Render (2); // output the page with two records on each page
?>