Print database

[53329]

I'm sure someone somewhere has made one but I can't find a script for it.  I'm looking for a script that will take all of my database and print the database tables, columns and values into an HTML table.

 

PHP version is 4.4.7

OS is Linux

 

Thanks in advance for any input.

[zampu]

try

SELECT * FROM table1

SELECT * FROM table2

 

cant have THAT many tables can ya?

[BlueSkyIS]

1. connect to MySQL

2. Loop over your list of table names, SELECT * from each one

3. For each table in the database, start an HTML table, for each row start an HTML row, enclose each record in a <TD>

 

 

[53329]

Yeah I've done that before.  I could probably work it out.  If I get anything good I'll post it in according forum.  I was trying to get it to work for any tables and columns but I just might be able to figure it out with what I have and a little know how.

[53329]

Scratch that, I can't at all.  I wanted something that found all the table names, then the columns, then the values for all the rows.  Basically I wanted to echo my entire database regardless of the names of tables or columns in the database.  Something generic because I have about a hundred tables.  Seems impossible....