How to get database size by php

[php.net]

Hello,

Any one know how to get database size by php

I find that but not worked for me:

<?php
$sql = "SHOW TABLE STATUS";
$result = mysql_query($sql); // This is the result of executing the query
while($row = mysql_fetch_array($result))// Here we are to add the columns 'Index_length' and 'Data_length' of each row
{
$total = $row['Data_length']+$row['Index_length'];
}
echo($total); // here we print the file size in bytes
?>

and that

function getDbSize($dbname){
$size=shell_exec("du -b /var/lib/mysql/$dbname");
$size=explode(' ',$size);
return $size[0];
} 

Any one have other methods?

Thanks

[hermawan]

The second method will not working since you will run the PHP as Guest which don't have access to /var/lib/mysql/* folder.

The first method is reasonable. Try to add a plus "+" sign before the equal "=".

$total += ...

[php.net]

Thanks hermawan,

But any other idea?

[php.net]

i try this code :

<?php 
$sql = "SHOW TABLE STATUS"; 
$result = mysql_query($sql); // This is the result of executing the query 
while($row = mysql_fetch_array($result))// Here we are to add the columns 'Index_length' and 'Data_length' of each row 
{ 
$total += $row['Data_length']+$row['Index_length']; 
} 
echo($total); // here we print the file size in bytes 
?>

Its worked in personal server in my comuter and not work in my server

thanks

[nioton]

well, php.net it is obvious because in your server you have no ROOT access to the database