I am running a website for a client (I'm a Uni student) which is for an employment agency. I've installed MovableType on the server for easy updates for the office workers allowing them to post job vacancies.
In a nutshell, what I want to do is, have a site where users who register and can fill out a brief profile about themselves (which will ideally include uploading their resume/cv).
The problem I'm facing is this. I don't have much php/mysql experience (mysql is running on the host) but I want to allow users to upload their resume when they wish to apply for a position by browsing the MovableType entries. Then browse to their desired *.doc file on their hard drive and upload to the server. The file upload itself should be associated with the user profile, allowing office workers to receive the file, know who is sending it, and which job vacancy their upload is associated with allowing the office staff to grasp which job the user is applying for.
My head is telling me that I will have to do the following:
Have field in the user profile to store the path/name of the uploaded CV.doc.
On uploading and storing the CV, rename it cv_USERID.doc where USERID is the actual id of the users profile.
The people <--> jobs relationship is many to many so I need a link table with userid, jobid fields.
Problem is, I don't know where to start. I get the logic, just the various functions/classes/whatever are confusing me and how exactly do I stitch this together and in what order 😕
Any help appreciated!