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

Display Yahoo Answers on your site.

Yahoo Answers has RSS feeds for Latest Questions and different categories. They also have a feed for your questions and starred questions. There is not a feed for your answers list. So I made a PHP script that scrapes the latest 5 from my public profile. You can choose to show or hide different items in the list as well.

Download it here

Examples of what you can do with your own custom styling…

Continue reading Display Yahoo Answers on your site.