How to Show All Tables of a MySQL Database Using PHP


In this article, we show how to show all tables of a MySQL database using PHP.

This way, you can see all tables that have been created for a certain database.

The general MySQL code to make a column a primary key is shown below.

So the above is the MySQL code to show all the tables for a database, where you put the name of the database in place of database_name.

We'll now show how to tie this in with the PHP code to show all tables of a MySQL database.

So, first, we must connect to the database.

After this, we create a $showtables variable which queries the database for all the tables.

After this, we use a while loop to low through all the tables.

We then echo out the table.

Actual PHP Output