Works on PHP3 and PHP4 and should work on PHP5 since it uses no deprecated mysql PHP features. The PHP is pretty gruesome but simple and does the job. There is no error recovery or any smart stuff.
Table structures are displayed in the standard 5 columns with no regard to the page width. 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. The structure button is OK for mega files. 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. 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. If the table name is blank it will list all the tables in the specified database. If host name is blank 'localhost' is assumed. You need either a specific MySQL username and password for the database or the root username and password. MySQL Web Viewerĭisplays table data from a MySQL database. 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. We use a simple form based interface shown below.
#Mysql php viewer software
Like all downloaded software we urge caution if you use it.
#Mysql php viewer code
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. We may expand it to let us repair and fix up tables using the same techniques or add a WHERE clause or. It may be useful as a starting point - if so you are welcome.
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. We could not find a simple MySQL web based database viewer.
0 kommentar(er)
