public function dbSize()
{
$sql = "SHOW TABLE STATUS FROM " . DBNAME;
if (defined("TABPREFIX")) {
$sql .= " LIKE '" . TABPREFIX . "%'";
}
$mysqli = self::connect();
$result = $mysqli->query($sql);
$size = 0;
while ($row = $result->fetch_assoc()) {
$size += $row["Data_length"] + $row["Index_length"];
}
return tosize($size);
}
/**
* 获取数据库的使用的大小
* @return string 返回数据库的大小
*/
public function dbSize()
{
$sql = 'SHOW TABLE STATUS FROM ' . DBNAME;
if (defined('TABPREFIX')) {
$sql .= ' LIKE "' . TABPREFIX . '%"';
//获取表中的带表前缀的表
}
$mysqli = self::connect();
$result = $mysqli->query($sql);
$size = 0;
while ($row = $result->fetch_assoc()) {
$size += $row['Data_length'] + $row['Index_length'];
//如果有多个表，让他叠加
}
return tosize($size);
}
/**
* 获取数据库使用大小
* @return string 返回转换后单位的尺寸
*/
public function dbSize()
{
$sql = "SHOW TABLE STATUS FROM " . self::$master['db_name'];
$sql .= " LIKE '" . self::$master['db_prefix'] . "%'";
$pdo = self::achieveConn(TRUE);
$stmt = $pdo->prepare($sql);
//准备好一个语句
$stmt->execute();
//执行一个准备好的语句
$size = 0;
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$size += $row["Data_length"] + $row["Index_length"];
}
return tosize($size);
}
public function dbSize()
{
$sql = "SHOW TABLE STATUS FROM " . DBNAME;
if (defined("TABPREFIX")) {
$sql .= " LIKE '" . TABPREFIX . "%'";
}
$pdo = self::connect();
$stmt = $pdo->prepare($sql);
//准备好一个语句
$stmt->execute();
//执行一个准备好的语句
$size = 0;
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$size += $row["Data_length"] + $row["Index_length"];
}
return tosize($size);
}
/**
* 获取数据库的大小
* @return string 返回转变好格式的数据库的大小
*/
public function dbSize()
{
$sql = 'SHOW TABLE STATUS FROM ' . DBNAME;
if (defined('TABPREFIX')) {
$sql .= ' LIKE "' . TABPREFIX . '%"';
}
$pdo = self::connect();
$stmt = $pdo->prepare($sql);
$stmt->execute();
$size = 0;
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$size += $row['Data_length'] + $row['Index_length'];
}
return tosize($size);
}
