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

Simple Linux User Group (LUG) CMS

I wrote this simple CMS for keeping track of meetings, locations, information, and meeting archives/minutes/files of any sort of club or group events. The backend was created to CMSify the static site built by @thejonmoore of usefulgeek.com It’s not fully featured and may require some manual FTP uploading of your archives, etc, but it has just enough to play with. We ended up just using wiki for our LUG. Check out INKYLUG Indiana and Kentucky Linux Users Group.

download SimpleLUGCMS

Continue reading Simple Linux User Group (LUG) CMS

CSS Javascript Checker

I wrote this little script to disable a login or hide any feature of a site that requires javascript to work properly. It also gives a message that javascript should be enabled. Since you can’t do anything with javascript to check for javascript if it is disabled, it does something when it is enabled. Sure you COULD just use NOSCRIPT but this way makes it more complicated and thus fun. Plus you can get a little more fancy with it.
download it

JSChecker disabled

Continue reading CSS Javascript Checker