Getting the size of a file

[ChimpFace9000]

Hey, how about next to the link of an attached file, how about the size of the file? Something like...

<?
    $Size = filesize(File_Name);
    $Type = "bytes";
    if($Size > 1024)
        {$Size = $Size / 1024; $Type = "kb";}
    if($Size > 1024)
        {$Size = $Size / 1024; $Type = "mb";}
    $Size = round($Size, 1);
    print "$Size $Type";
?>

I know you could have figured it out your self, but i thought if i did it, you would be more inclined to add it to the page.

[padders]

the files are actually stored in the mysql database so it might be a bit harder than that.

Are you of the people working on V-Bulletin, and if so, is that a no?

[padders]

i am not, the people who are are freedie, ed, jimf, stallion and and john.

i was just saying it would be harder to do than suggested not that either it won't be done or that it can't be done.

the files are not stored in the mysql database..... I am 99% sure of it....

don't think you can put stuff like that into MySQL....

[John]

Well you're 99% wrong then

They are stored in the database.

John

Ok, that was unexpected..... how do you do it?

[parksie]

BLOB fields I expect

BLOB fields?

[parksie]

Binary Large OBject.

Ahhhh, so how do I use these so called "blob fields"?

[parksie]

Er...John....do you.......erm....uh.....know at all???

*runs away and hides in corner*

[John]

Just like you would any other text field - you can just put lots of data into it.

John

So it's.......


CREATE TABLE ......... pagetext MEDIUMTEXT, exething BLOB.......


and how do you insert the data, do you open the file and retreive the contents, then put it in???



I found a little bit of info on mysql.com but it doesn't really say how to use it:

http://www.mysql.com/doc/B/L/BLOB.html

[Active]

Dennis Here is a Tutorial....

http://phpbuilder.com/columns/florian19991014.php3