tp获得mysql版本及mysql数据库大小
sysinfo = array(
'os' => $_server[server_software], //获取服务器标识的字串
'version' => php_version, //获取php服务器版本
'time' => date(y-m-d h:i:s, time()), //获取服务器时间
'pc' => $_server['server_name'], //当前主机名
'osname' => php_uname(), //获取系统类型及版本号
'language' => $_server['http_accept_language'], //获取服务器语言
'port' => $_server['server_port'], //获取服务器web端口
'max_upload' => ini_get(file_uploads) ? ini_get(upload_max_filesize) : disabled, //最大上传
'max_ex_time' => ini_get(max_execution_time).秒, //脚本最大执行时间
'mysql_version' => $this->_mysql_version(),
'mysql_size' => $this->_mysql_db_size(),
);
$this->display();
}
private function _mysql_version()
{
$model = self::_model();
$version = $model->query(select version() as ver);
return $version[0]['ver'];
}
private function _mysql_db_size()
{
$model = self::_model();
$sql = show table status from .c('db_name');
$tblprefix = c('db_prefix');
if($tblprefix != null) {
$sql .= like '{$tblprefix}%';
}
$row = $model->query($sql);
$size = 0;
foreach($row as $value) {
$size += $value[data_length] + $value[index_length];
}
return round(($size/1048576),2).'m';
}
}不足之处望指点!http://www.yi210.com/archives/919.html
ad:真正免费,域名+虚机+企业邮箱=0元