[SOLVED] PHP function to display a database / table structure?

[hatrickpatrick]

My webhosts cpanel is down for maintenence, including phpMyAdmin, and I need to view my database structure... Is there any function in PHP to display the database structure (like the "Export" function in PHPMyAdmin)?

 

Thanks

[trq]

You could run a SHOW TABLES query from within php, more a mysql question though really.

 

There is no specific function that does what your looking for. There is however a bunch of mysql functions that will get you the data you want. Take a look at the mysql functions in the manual.