PHP Upload...with MySQL?

[influx]

Hi all,

I have a website for friends of mine to come, register, log in, and access a few members pages (all working very well). However, my latest project for the members section is to add a upload documents page for my friends to upload Word documents (.doc) to my website. Since there will be many members at my site, I was wondering...is there a possibility to store the .doc files in my MySQL database? Or should I save all the documents in a folder on my server with the username as the document name? Thanks a lot!

[drew010]

you can store the documents in the mysql database. create a blob field in a table and when they upload the file, you can do something like this:
$file = file_get_contents($_FILES['file']['tmp_name'];
$file = addslashes($file);
mysql_query("INSERT INTO files VALUES('username', '$file');

also, if you arent familiar with file uploads
in the $_FILES['file'] part, ['file'] refers to the name of the field in your form.
be sure to stripslashes when you pull the doc file out of the database as well.

[influx]

great, thanks...

is there any chmod'ing i need to do?

also, what do you suggest to cap the filesize for the .doc files?

Thanks!

-influx

[drew010]

no you dont need any chmoding since its in the database. and since they are .docs they probably wont get too large. i wouldnt worry about it unless friends start upping 20 mb files.

[Pests]

You have to remember there is a 2mb default limit on file uploads. This can be changed in the php.ini file.