读取mysql一个库下面的所有的表table
我们先来看代码:
<?php
require'class/db.php';
$sql="select*frominformation_schema.tableswheretable_schema='ecshop'andtable_type='basetable'orderbyTABLE_ROWSdesc";
$arr=$db->queryArray($sql);
//var_dump($arr);
foreach($arras$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)“BASETABLE”
["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-1522:27:40″
["UPDATE_TIME"]=>
string(19)“2016-12-0411:25:55″
["CHECK_TIME"]=>
string(19)“2016-12-0411:19:50″
["TABLE_COLLATION"]=>
string(15)“utf8_general_ci”
["CHECKSUM"]=>
NULL
["CREATE_OPTIONS"]=>
string(0)“”
["TABLE_COMMENT"]=>
string(0)“”