PHP PDO fetch all tables?
Execute the query with PDO::query() : SHOW TABLES If you fetch an associative array, the name of the column will be: Tables_in_databasename Note: this will list both tables and views. If you must get only tables use this instead: SELECT TABLE_NAME FROM information_schema. TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='yourdatabasename.
Execute the query with PDO::query(): SHOW TABLES; If you fetch an associative array, the name of the column will be: Tables_in_databasename Note: this will list both tables and views. If you must get only tables, use this instead: SELECT TABLE_NAME FROM information_schema. TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='yourdatabasename.
1 Perfect. Thank you. Correct in t minus 7 minutes.
– Headspin Jun 22 at 17:13.
Do $pdo->query("show tables"); to obtain a result set of tables contained in the current database.
$result = $db->query("show tables"); You can then do fetch on it.
Note: this will list both tables and views. Do $pdo->query("show tables"); to obtain a result set of tables contained in the current database. You can then do fetch on it.
Terms of service. Not the answer you're looking for?
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.