Skrive filstørrelse i KB eller MB
Hej,I nedenstående script vises beskrivelse af fil (med link til filen), samt filens størrelse i bytes.
Hvordan ændrer jeg i koden, således, at størrelsen bliver vist i KB hhv. MB?
Koden:
<?
if(isset($_GET['id']))
{
// Connects to your Database
mysql_connect("localhost", "user", "passw") or die(mysql_error()) ;
mysql_select_db("db") or die(mysql_error()) ;
$id = $_GET['id'];
$query = "SELECT name, descr, type, size, content FROM upload WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
list($name, $descr, $type, $size, $content) = mysql_fetch_array($result);
header("Content-Disposition: attachment; filename=$name");
header("Content-length: $size");
header("Content-type: $type");
echo $content;
exit;
}
?>
<html>
<head>
<title>Download File From MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?
mysql_connect("localhost", "user", "passw") or die(mysql_error()) ;
mysql_select_db("db") or die(mysql_error()) ;
$query = "SELECT id, name, descr, size, content FROM upload";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo "Database is empty <br>";
}
else
{
while(list($id, $name, $descr, $size,) = mysql_fetch_array($result))
{
?>
<li><a href="download.php?id=<?=$id;?>"><?=$descr;?></a></li>
<?
}
}
mysql_close($conn);
?>
</body>
</html>
