uploading file in to mysql database in php?

[mekelle]

i want to collect job seekers online, so that i have a registration form that includes name, email, and CV's. so can i upload the cv in to the table along with the name and email?.
or how can i use it?
or can i store it in a different folder? but if i store it in a folder, how do i know whose CV is that because name and email is in table and cv is in other folder?
any idea how to solve such kind of problem?
thanks

[kows]

I have no idea what a CV is, but if it's an image of some kind then I would suggest storing it as a file on the server and not in your database. you can name it according to their name (assuming there will be no duplicate names), or the unique ID for that person in the database. you can look up how to upload files here (http://ca2.php.net/manual/en/features.file-upload.post-method.php).

[penagate]

A CV (Curriculum Vitae) is an in-depth document describing a person's education, qualifications, awards, and so on. Usually when applying for jobs a specifically tailored résumé is used instead, but some employers expect a CV.

I agree that a file should generally not be stored in a database.

[ngreenwood6]

I personally would have them upload there CV into a folder on your server with a unique name(meaning something that cant be duplicated). Then while they are uploading and getting there unique filename insert that into the database under two fields. One for the filename and the other for the extension. Then when they want to view it open the CV file by the filename and extension combined.