Read all of the tables under Mysql a library Table_mysql

Let's look at the code first:

<?php
require ' class/db.php ';
 
$sql = "SELECT * from Information_schema.tables where table_schema= ' ecshop ' and table_type= ' base table ' ORDER by Table_row S desc ";
 
$arr = $db->queryarray ($sql);
 
Var_dump ($arr);
foreach ($arr as $k => $v) {
 $tbname = $v->table_name;
 $rows = $v->table_rows;
 echo $tbname. '-';
 echo $rows;
 Echo ' <br> ';
>

TABLE_NAME Table name

Number of Table_rows table records

Data_length data length.

["Table_catalog"]=>

Null

["Table_schema"]=>

String (Ten) "Leo_ecshop"

["table_name"]=>

String (9) "Ecs_goods"

["Table_type"]=>

String (a) "BASE TABLE"

["ENGINE"]=>

String (6) "MyISAM"

["VERSION"]=>

String (2) "10″

["Row_format"]=>

String (7) "Dynamic"

["Table_rows"]=>

String (1) "7″

["Avg_row_length"]=>

String (3) "286″

["Data_length"]=>

String (4) "2008″

["Max_data_length"]=>

String (15) "281474976710655″

["Index_length"]=>

String (5) "11264″

["Data_free"]=>

String (1) "0″

["Auto_increment"]=>

String (1) "8″

["Create_time"]=>

String (19) "2016-11-15 22:27:40″

["Update_time"]=>

String (19) "2016-12-04 11:25:55″

["Check_time"]=>

String (19) "2016-12-04 11:19:50″

["Table_collation"]=>

String (UTF8_GENERAL_CI)

["CHECKSUM"]=>

Null

["Create_options"]=>

String (0) ""

["Table_comment"]=>

String (0) ""