Tech Info - 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 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 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. Do not use for mega big files (or you could add a WHERE clause). 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.

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.