[RESOLVED] Can files be uploaded to a mysql DB?

[sois]

1. Is this possible?
2. Can the files be made available for download to the public?

I run a league and I (or a few other commissioners) have to upload files to my server each Saturday. Is there a php function that can do this? I don't want to set up FTP accounts for the other commishes as there are quite few. I just want a simple page upload script. I also don't want to chmod 777 to the folders. I got hacked and now I'm freaking out.

Thanks guys.

[wilku]

google would be quicker - second result from "mysql file upload":
http://php.about.com/od/phpbasics/ss/mysql_files.htm

[bradgrafelman]

Yes it's possible. Just make a BLOB column in your SQL table, upload a file to PHP as you would normally, and output the contents of the file into a SQL 'INSERT' query.

Don't forget to use [man]mysql_real_escape_string/man so your query's syntax doesn't get broken.

[sois]

Thanks guys!