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.

SHOW TABLES FROM database_name;

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.

<?php $user = "user"; $password = "password"; $host = "host"; $connection= mysql_connect ($host, $user, $password); if (!$connection) { die ('Could not connect:' . mysql_error()); } $showtables= mysql_query("SHOW TABLES FROM database_name"); while($table = mysql_fetch_array($showtables)) { // go through each row that was returned in $result echo($table[0] . "<br>"); // print the table that was returned on that row. } ?>

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