MySQL PHP Table Viewer with Pagination and Sorting

Basic PHP MySQL table viewer. Just tell it the table you want to view and it does all the rest! Automatically lists all your fields and values for specified table; providing ASC and DESC sorting for each. Also has prevnext and number paging.

Options include:

  • Nice fields (on/off) – “field_name” gets changed to “Field Name”
  • Page numbers (on/off)
  • Prev / Next (on/off)
  • Limit per page

Demo / Download:
http://blog.drale.com/tableview/

GitHub:
http://github.com/drale/DBTableViewer

Screenshot:
screenshot

Import NetStumbler Data To MySQL Database

Wrote a little program that imports your NetStumbler text file export into a MySQL database. Very simple program that runs automatically using the data file uploaded into same directory. No fancy file uploading nor does it include viewing and sorting or doing anything with the data, yet. It also does not check against previous entries, so you’ll have to dump your MySQL before importing again.. The newest release checks for duplicates using MAC on import. That is up to you what you need it in a database for.

(excuse my poor versioning, etc, first time really trying to keep up with version numbers, details of improvements and GPL)

ns2db-v1.1b-with-viewer.zip – bug fix for lat/long field (thanks pixel), checks against MAC to prevent duplicates on import

ns2db-v1.1b.zip – added table view of data

ns2db-v1.0.zip