本文整理自网络,侵删。
我们先来看代码:
<?php require 'class/db.php'; $sql = "select * from information_schema.tables where table_schema='ecshop' and table_type='base table' order by TABLE_ROWS 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_ROWS 表记录数量
DATA_LENGTH 数据长度。
["TABLE_CATALOG"]=>
NULL
["TABLE_SCHEMA"]=>
string(10) “leo_ecshop”
["TABLE_NAME"]=>
string(9) “ecs_goods”
["TABLE_TYPE"]=>
string(10) “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″
相关阅读 >>
万网独享主机apache为ECSHOP商城添加404页面的方法详解
更多相关阅读请进入《ECSHOP》频道 >>