PRodgers4284 Posted February 12, 2008 Share Posted February 12, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/90669-php-and-mysql-word-file-upload/ Share on other sites More sharing options...
pdkv2 Posted February 12, 2008 Share Posted February 12, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/90669-php-and-mysql-word-file-upload/#findComment-464753 Share on other sites More sharing options...
Cognito Posted February 12, 2008 Share Posted February 12, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/90669-php-and-mysql-word-file-upload/#findComment-464755 Share on other sites More sharing options...
PRodgers4284 Posted February 12, 2008 Author Share Posted February 12, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/90669-php-and-mysql-word-file-upload/#findComment-464756 Share on other sites More sharing options...
Cognito Posted February 12, 2008 Share Posted February 12, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/90669-php-and-mysql-word-file-upload/#findComment-464803 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.