Page Navigator - PHP Best Codes

Most of PHP scripts as guestbook, webboard, online catalog, etc. have many records in database. So, not good idea to show them in one page. This tutorial will show you how to create the page navigator and apply it.

This tutorial require 1 PHP file and 1 table of mySQL database.

1. page.php
2. Database "tutorial" and table "name_list" with 2 fields: id(auto_increment), name(varchar, 50) and put some records about 20 - 30 records into this table. (directly by phpMyAdmin)

Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 164 Warning: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 165 Warning: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: A link to the server could not be established in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 165 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 171 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 171 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 173 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 192 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 192 <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <table border="1"> <tr> <td>No.</td> <td>Name</td> </tr> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 219 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/k/k/r/kkr152/html/phpfreecode/page_navigator.htm on line 229 </table> </body> </html> <a target="_blank" href="http://www.phpfreecode.com/">PHP Free Code</a>

Page Navigator Next Code