PHP MySQL Functions to list table names in a databases

SHOW 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

SHOW TABLES in PDO

SHOW TABLES from pdo LIKE 't%'

<?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>";
}
?>

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;
}

mysql_list_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++;
}
?>

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author   Watch on YouTube

Connect: