A Perl Script and two Perl Modules which will allow you to easily display, search and sort any MySQL Tables in a standard Web BrowserThis is a must-have utility if you are a developer or have MySQL applications running on your Website or Web Server. This is how it works:
Step # 1 - Select a Table
Once installed and you point your browser to the script, you are presented with a Drop-Down Box listing all tables in your current database like so
Step # 2 - Define how Table should be displayed
You define how the script should display each field in the table. You can
Choose the order in which fields are displayed
Choose whether a filed is visible or not
Choose the data Type. Currently supports the following display formatting:
Boolean 1 or 0
Boolean YES or NO
Currency
Date
Email (long and/or short URL format)
IP to integer or Integer to IP
Integer
Text 25, Text 255 or Text any length
URL link - short and/or long
Save the view.
Step #3 - View/Sort/Search MySQL Table Data
Once Defines you can:
Search tables in any field for records
Containing or matching,
Less than, Less or equal to
Greater than, Greater or equal to
Order by an column or Reverse order
Choose how many results should be returned |