Yes, use BLOB and TEXT fields.
http://www.mysql.com/doc/B/L/BLOB.html
What you do, is use the upload function in the browser (multipart) to upload the data (or use simple form tags to capture it) and then insert the data into a mysql record.
Many banner/advertising services do that, storing the binary logos/ads in the database itself. It makes for a cleaner disk, at the cost of having to pump the binary data out and flag it properly.
In uploading a file, just take the variable you store it in, and assign it to a MYSQL field, rather than output to a disk file.
I would _strongly_ suggest a resume database stick with text files, but if you really want people to be able to upload their resumes, you'd want to figure out how you will do it. If they are zip or doc format, they can't be read on-line by most people.
I'm trying to finish up the multiple file upload module, and when it's done, it could be used to attach the graphics to the resume's html file. But, again, there are security and other problems with allowing people to upload random data.
I _strongly_ urge you both to think about using text fields, and maybe seeing how the big boys like Monster.com and Thingamajob.com do it.
There are lots of benefits, including security advantages.
PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
http://www.mysql.com/doc/B/L/BLOB.html
What you do, is use the upload function in the browser (multipart) to upload the data (or use simple form tags to capture it) and then insert the data into a mysql record.
Many banner/advertising services do that, storing the binary logos/ads in the database itself. It makes for a cleaner disk, at the cost of having to pump the binary data out and flag it properly.
In uploading a file, just take the variable you store it in, and assign it to a MYSQL field, rather than output to a disk file.
I would _strongly_ suggest a resume database stick with text files, but if you really want people to be able to upload their resumes, you'd want to figure out how you will do it. If they are zip or doc format, they can't be read on-line by most people.
I'm trying to finish up the multiple file upload module, and when it's done, it could be used to attach the graphics to the resume's html file. But, again, there are security and other problems with allowing people to upload random data.
I _strongly_ urge you both to think about using text fields, and maybe seeing how the big boys like Monster.com and Thingamajob.com do it.
There are lots of benefits, including security advantages.
PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
