Php + oracle paging

The following is a paging example program, which may seem complicated, but you only need to use it to find that everything is so simple: example. php (as the mainstream development language) & lt ;? Php (as the mainstream development language, but you only need to use it to find that "everything is so simple ":)
Example. php (as the mainstream development language)
$ Conn = maid ("test", "123456", "test123 ");
Include_once "pager. inc. php (as the mainstream development language )";
?>

/** Start paging test */

// {Initial paging object
$ Pager = new pager ();
/** Split select id, name, age from test where age> 20 order by id desc */
$ SqlArr = array (conn => $ conn, // Database link
Fields => "id, name, age", // query the subject sentence
Table => "test", // table name
Condition => "age> 20", // query condition
Order => "order by id desc" // sorting method
);
If (! $ Pager-> listn ($ sqlArr, 10, $ page) // 10 entries are displayed on each page.
{
$ Pager-> errno = 10;
Die ($ pager-> errmsg ());
}
//}}}

// {Data Display
For ($ I = 0; $ I <count ($ pager-> result); $ I ++)
{
$ Tmp = $ pager-> result [$ I];
Echo "id:". $ tmp [ID]."
";
Echo "name:". $ tmp [NAME]."
";
Echo "age:". $ tmp [AGE]. ""
}
//}}}

// {Display page link
Echo $ pager-> page. "/". $ pager-> totalpage. "total". $ pager-> total. "record ";
If ($ pager-> prev! = 0)
Echo "(as the mainstream development language) _ SELF? Page = ". $ pager-> prev."> Previous page ";
Else
Echo "previous page ";

If ($ pager-> next! = 0)
Echo "(as the mainstream development language) _ SELF? Page = ". $ pager-> next."> next page ";
Else
Echo "next page ";
//}}}
?>