PDO::ERRMODE_EXCEPTION]); $rows = $pdo->query('SELECT group_code, code, code_name, is_active FROM edu_codes ORDER BY group_code, code')->fetchAll(PDO::FETCH_ASSOC); echo count($rows) . ' rows' . PHP_EOL; foreach ($rows as $r) { echo implode(' | ', $r) . PHP_EOL; } echo PHP_EOL . '--- SHOW TABLES ---' . PHP_EOL; $tables = $pdo->query('SHOW TABLES LIKE "edu_%"')->fetchAll(PDO::FETCH_COLUMN); foreach ($tables as $t) echo $t . PHP_EOL; } catch (Exception $e) { echo 'ERROR: ' . $e->getMessage() . PHP_EOL; }