So I know with a standard mysql call we can do mysql_list_tables
, however is there an equivalent while using PDO? If so, does this return an array? Thanks!
PHP PDO获取所有表
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
4条回答 默认 最新
- dongqian8265 2011-06-22 17:07关注
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';
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报