Question
Uploading / searching word documents
I'm jusy working on my first PHP/mySQL project - so far so
good, with it all set up for adding, deleting and editing records.
It's for a small recruitment agency - so in the first instance I've got a table for jobs, which the site owner can add new jobs to the site via a form, and a table for clients, which is populated automatically when the fill in a registration form on the site.
However the guy I'm doing it for wants to have CV's available online - for employers to be able to view. The easiest way I'd imagined that working, would be to upload the CVs as word documents, and hace a field for each client that was the linked ot their CV.doc. Again, so far so good.
But I've been asked if the CVs could be searchable on the site, and I'm not sure if this is possible, as the CV's contents isn't actually a database field - just the filename.
I'm thinking it might be better to maybe have a few fields that could be used to hold pertinent details about each client, rather than rely on the CV's contents - and from there, employers could still download the CV of any that took their interest.
If anyone could give me any tips or pointers with something like that it would be a great help.
Cheers,
Iain
It's for a small recruitment agency - so in the first instance I've got a table for jobs, which the site owner can add new jobs to the site via a form, and a table for clients, which is populated automatically when the fill in a registration form on the site.
However the guy I'm doing it for wants to have CV's available online - for employers to be able to view. The easiest way I'd imagined that working, would be to upload the CVs as word documents, and hace a field for each client that was the linked ot their CV.doc. Again, so far so good.
But I've been asked if the CVs could be searchable on the site, and I'm not sure if this is possible, as the CV's contents isn't actually a database field - just the filename.
I'm thinking it might be better to maybe have a few fields that could be used to hold pertinent details about each client, rather than rely on the CV's contents - and from there, employers could still download the CV of any that took their interest.
If anyone could give me any tips or pointers with something like that it would be a great help.
Cheers,
Iain
