//参数
$host='127.0.0.1';
$user='root';
$pwd='lmutidao'; //数据库密码
$dbs='information_schema';
$schema='apoyl'; //输入对应的数据库
$table='apoyl_new'; //表名
$sql="select concat(round(sum(DATA_LENGTH/1024/1024),4),'MB') as data,TABLE_ROWS as rows from TABLES where table_schema='".$schema."' and table_name='".$table."'"; //sql获取表大小,总行数
//连接数据
$conn=connectDb();
mysql_select_db($dbs,$conn) or die('db failure!');
$re=mysql_query($sql,$conn);
$arr=mysql_fetch_row($re);
function connectDb(){
global $host,$user,$pwd;
$conn=mysql_connect($host,$user,$pwd) or die('mysql failure!');
return $conn;
}
?>
数据库:<?php echo $schema?>
表:<?php echo $table?>
表大小:<?php echo $arr[0]?>
总记录数:<?php echo $arr[1]?>