Using SHOW TABLE with PDO and mysql_list_tables mysql_tablename php function for name and list database tables

We can list tables present in a database by using this query

SHOW TABLES

Using this we can develop a PHP script to display all tables.

<?Php
require "config.php"; // Database Connection

$result = $dbo->query("SHOW TABLES");

while ($row = $result->fetch(PDO::FETCH_NUM)) {
echo $row[0]."<br>";
}
?>

Show tables of a database

We can display tables of a database by changing the above query.

SHOW TABLES in PDO

Above query will return all the tables of the database pdo
Similarly if we want to list all the tables starting with char t then we can use LIKE command. Here is the query.

SHOW TABLES from pdo LIKE 't%'

Above query can be placed inside the PHP code (shown above ) to display matching tables. For easy understanding here again the php code.

<?Php
require "config.php"; // Database Connection

$result = $dbo->query("SHOW TABLES from pdo LIKE 't%'");

while ($row = $result->fetch(PDO::FETCH_NUM)) {
echo $row[0]."<br>";
}
?>

Using MySQLI

if($stmt = $connection->query("SHOW TABLES")){
  echo "No of records : ".$stmt->num_rows."<br>";
  while ($row = $stmt->fetch_array()) {
echo $row[0]."<br>";
  }
}else{
echo $connection->error;
}

This old MySQL extension was deprecated in PHP 4.3.0 and was removed in PHP 7

Use SHOW TABLE query in place of mysql_list_tables().

mysql_list_tables()

We can display a list of tables present in a database by using mysql_list_tables() function. Connection has to be established before call of this function. The result pointer returned by this function is used by mysql_tablename() function to display the name of the tables.


<?Php

$list = mysql_list_tables ("sql_tutorial");

$i = 0;

while ($i < mysql_num_rows ($list)) {

$tb_names[$i] = mysql_tablename ($list, $i);

echo $tb_names[$i] . "<BR>";

$i++;

}

?>

PHP MySQL Functions to list table names in a databases

Show tables of a database

mysql_list_tables()