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); }