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.
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.
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.
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.
If you are happy it's OK - but your browser is giving a less than optimal experience on our site. You could, at no charge, upgrade to a W3C standards compliant browser such as Firefox
W3C HTML 4.01
HTML4 vs HTML5
W3C Page Validator
CSS 3 Media Queries
CSS 3 Colors
W3C DOM 3 Core
W3C 3 Events
W3C - WAI
Web Style Guide
A List Apart
Eric Meyer on CSS
Our DOM Pages
CSS Short Cuts
CSS One Page
Copyright © 1994 - 2023 ZyTrax, Inc.
All rights reserved. Legal and Privacy
|site by zytrax
web-master at zytrax
Page modified: January 20 2022.