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