Home ❯ MySQL list ❯ List all tables of a database

List all tables of a database

<?php
  
$pdo = new PDO("mysql:host=localhost", "root", ""); 
  
$stmtnTable = $pdo->query('SHOW TABLES FROM `mysql`');
  
$tables_name = $stmtnTable->fetchAll(PDO::FETCH_COLUMN); 
  
foreach($tables_name as $tableName){ 
 
  echo $tableName, '<br>';
 
}
?>

6 Related pages