mysql - Count number of SQL tables in PHP? -


i have database many tables. wondering how can use php count total number of tables in database?

you can do

select count(*) information_schema.tables table_schema = 'dbname'; 

or

use databasename; show tables; select found_rows(); 

Comments