PHP and MYSQL word file upload

[PRodgers4284]

Just wondering if this can be done and can i store a word doc or a pdf in a mysql database table. Im doin a project for uni based on a job recruitment website and i want an option to allow users to add a cv to the database and store the doc in a field in the table, is this possible, i was wondering if anyone could point in the right direction on how to do this, i would really appreciate some help.

 

Phil

[pdkv2]

it is possible to store the files in MySql database

i have a code to upload the image in the database as well as retrieve it from the database.

 

you need to cteated the table with the blob field.

 

Cheers

 

[Cognito]

Most recruitment sites use the database to store the file name and sometimes location.... then all your CV's go into a upload folder and in order to get the links you pull them back out via a DB query.

[PRodgers4284]

it is possible to store the files in MySql database

i have a code to upload the image in the database as well as retrieve it from the database.

 

you need to cteated the table with the blob field.

 

Cheers

 

 

Thanks for your reply, is it difficult to do this, im looking to add a word file to the database?

 

Thanks

 

Phil

[Cognito]

I'll expand on my previous post:

 

It is possible to insert almost any binary document into a blob

type field but in most case i would suggest to store the

document outside the database and to store the *address* of the

document into the database.

 

Blobs make database less efficient due to the variation they

introduce in field length.

 

A blobed (?) binary document also takes more space than the

original one.