Filesize

[DaveTomneyUK]

Hi,

How do I do this does someone know? I made a database with filesize records.

CREATE TABLE `portal_gallery_video` (
  `id` int(11) NOT NULL auto_increment,
  `size` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;

and in the 'size' I insert the size but if I type 1200 it says its 1200kb is there a way if its over 1000 it make it say 1.2mb or 12mb instead of kb all the time?

[devinemke]

function filesize_format($filesize)
{
	$size_array = array(1 => 'B', 1024 => 'KB', 1048576 => 'MB');
	foreach ($size_array as $key => $value)
	{
		if ($filesize >= $key)
		{
			$filesize_formatted = number_format(round($filesize / $key, 2) , 2) . ' ' . $value;
		}
	}
	return $filesize_formatted;
}

where filesize is simply an integer (the number of bytes)

[DaveTomneyUK]

ya but how would i work it in to my code I use this.

$result = mysql_query("SELECT size FROM gallery WHERE active='1'");

while ($row = mysql_fetch_array($result)) {

echo "<td align=\"center\" width=\"40%\" class=\"row1\" valign=\"center\"><font class=\"forumlink\">"._GALLERY_SIZE." : $size</td>";
}

[devinemke]

echo '<td align="center" width="40%" class="row1" valign="center"><font class="forumlink">' . _GALLERY_SIZE . ' : ' . filesize_format($size) . '</td>';

[DaveTomneyUK]

Perfect but there is a small problem when I type in '1948' it says its '1.90KB' instead of '1.90MB' or to make it MB would I have to type it as '194800'?

[devinemke]

DaveTomneyUK wrote:

Perfect but there is a small problem when I type in '1948' it says its '1.90KB' instead of '1.90MB' or to make it MB would I have to type it as '194800'?

why would you expect '1948' to give you '1.90MB'? 1948 bytes is not 1.90MB.

[DaveTomneyUK]

When I look on my PC it says size '1948KB' in windows explorer. Thanks for your helpits working perfect now. All I needed to do was change '1948' to '1994655' so it shows '1.90MB'