priyadharshini Posted December 28, 2010 Share Posted December 28, 2010 Hi all, Am developing a consultancy project and i want the uploaded resumes to be placed in the database directly. I used blob in database but it is stored as junk values. I want it to be stored as like uploaded for the content to be searched. Mysql version:5.0 Please provide me some solution as soon as possible. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/222804-storing-uploaded-content-in-database/ Share on other sites More sharing options...
coupe-r Posted December 28, 2010 Share Posted December 28, 2010 Don't store files in your DB!! Instead, store the path to the file on the file root. Makes for a happier DB... Quote Link to comment https://forums.phpfreaks.com/topic/222804-storing-uploaded-content-in-database/#findComment-1152197 Share on other sites More sharing options...
Maq Posted December 28, 2010 Share Posted December 28, 2010 Don't store files in your DB!! Instead, store the path to the file on the file root. Makes for a happier DB... Then there's no way to search the resumes. OP have a look at http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html. I believe you have to store as a 'text' type to use this. If you really want to have good search capabilities it may be worth looking into something like lucene. Quote Link to comment https://forums.phpfreaks.com/topic/222804-storing-uploaded-content-in-database/#findComment-1152251 Share on other sites More sharing options...
priyadharshini Posted December 29, 2010 Author Share Posted December 29, 2010 That url Page not found... Suggest me some ideas to convert the uploaded resumes in word and pdf to text and storing it in database Quote Link to comment https://forums.phpfreaks.com/topic/222804-storing-uploaded-content-in-database/#findComment-1152466 Share on other sites More sharing options...
Maq Posted December 29, 2010 Share Posted December 29, 2010 That url Page not found... The period got appended: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html Quote Link to comment https://forums.phpfreaks.com/topic/222804-storing-uploaded-content-in-database/#findComment-1152591 Share on other sites More sharing options...
n1concepts Posted December 29, 2010 Share Posted December 29, 2010 Hi, There is a way to search the resumes (files) but you will have to write extra code to parse the content of each file (resume) and save that excerpt in another field along with maybe afew other field such as ones to classify or mark the resume's content to a specific category. It is true that it's NOT a good idea to try and store files in the actual database; set the path to location is best and use FILE functions to read content from the resume and save in other "text" fields - those "VCHAR" field types can then be queried from the db. Quote Link to comment https://forums.phpfreaks.com/topic/222804-storing-uploaded-content-in-database/#findComment-1152598 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.