作者：光明使者之快乐天使_101 | 来源：互联网 | 2018-05-26 12:02
TP获得mysql版本及mysql数据库大小
namespace Admin\Controller;
use Think\Controller;
class SystemController extends AdminController
{
protected function _model(){
return new \Think\Model();
}
public function indexAction()
{
layout( true );
$this->sysinfo = array(
&＃039;os&＃039; => $_SERVER["SERVER_SOFTWARE"], //获取服务器标识的字串
&＃039;version&＃039; => PHP_VERSION, //获取PHP服务器版本
&＃039;time&＃039; => date("Y-m-d H:i:s", time()), //获取服务器时间
&＃039;pc&＃039; => $_SERVER[&＃039;SERVER_NAME&＃039;], //当前主机名
&＃039;osname&＃039; => php_uname(), //获取系统类型及版本号
&＃039;language&＃039; => $_SERVER[&＃039;HTTP_ACCEPT_LANGUAGE&＃039;], //获取服务器语言
&＃039;port&＃039; => $_SERVER[&＃039;SERVER_PORT&＃039;], //获取服务器Web端口
&＃039;max_upload&＃039; => ini_get("file_uploads") ? ini_get("upload_max_filesize") : "Disabled", //最大上传
&＃039;max_ex_time&＃039; => ini_get("max_execution_time")."秒", //脚本最大执行时间
&＃039;mysql_version&＃039; => $this->_mysql_version(),
&＃039;mysql_size&＃039; => $this->_mysql_db_size(),
);
$this->display();
}
private function _mysql_version()
{
$Model = self::_model();
$version = $Model->query("select version() as ver");
return $version[0][&＃039;ver&＃039;];
}
private function _mysql_db_size()
{
$Model = self::_model();
$sql = "SHOW TABLE STATUS FROM ".C(&＃039;DB_NAME&＃039;);
$tblPrefix = C(&＃039;DB_PREFIX&＃039;);
if($tblPrefix != null) {
$sql .= " LIKE &＃039;{$tblPrefix}%&＃039;";
}
$row = $Model->query($sql);
$size = 0;
foreach($row as $value) {
$size += $value["Data_length"] + $value["Index_length"];
}
return round(($size/1048576),2).&＃039;M&＃039;;
}
}不足之处望指点！http://www.yi210.com/archives/919.html
AD：真正免费，域名+虚机+企业邮箱=0元
京公网安备 11010802041100号