Tech Stuff - PHP SQL Web Viewer

We could not find a simple MySQL web based database viewer. There must be hundreds we thought. Perhaps we looked in the wrong places. Perhaps it's too trivial a requirement. This was put together in a few minutes to list tables in a database, view the data from a defined table and optionally view table structure. It may be useful as a starting point - if so you are welcome. We may expand it to let us repair and fix up tables using the same techniques or add a WHERE clause or.....

Health-Warning: This is made available at your risk, we make no warranty that the code has no bugs in it or that it will even do what we think or say or even say what we think it will. Like all downloaded software we urge caution if you use it.

Web Based MySQL Viewer

We use a simple form based interface shown below. We have disabled the send button in this one but it has a commented-out line that you would change to reflect wherever you run your php scripts from or see minimal HTML version or right click and 'save link target as' - Oh the choices.

MySQL Web Viewer

Displays table data from a MySQL database. You need either a specific MySQL username and password for the database or the root username and password. We recommend the former. If host name is blank 'localhost' is assumed. If the table name is blank it will list all the tables in the specified database. If the database is blank it will give errors! The radio button is used to control whether you want to display the table data or the table structure. Do not use the data button for mega big files - it should work but you will get rather a lot of data - like, all of it! - alternatively, you could add a WHERE clause fired from the form to be more selective. The structure button is OK for mega files.

The first field of each new record is marked in bold, tables are displayed three columns across and data is split at 30 bytes on each line with no regard to spaces. Table structures are displayed in the standard 5 columns with no regard to the page width. There is no error recovery or any smart stuff. You get anything wrong - you get errors.

PHP Module

The PHP is pretty gruesome but simple and does the job. Works on PHP3 and PHP4 and should work on PHP5 since it uses no deprecated mysql PHP features. Right Click and 'save link target as' to a suitable place and rename with .php suffix or whatever your server uses or just cut and paste the body code into another formatted page. Few if any comments - so what's new.

Problems, comments, suggestions, corrections (including broken links) or something to add? Please take the time from a busy life to 'mail us' (at top of screen), the webmaster (below) or info-support at zytrax. You will have a warm inner glow for the rest of the day.