Results 1 to 4 of 4

Thread: uploading file in to mysql database in php?

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2009
    Posts
    4

    uploading file in to mysql database in php?

    i want to collect job seekers online, so that i have a registration form that includes name, email, and CV's. so can i upload the cv in to the table along with the name and email?.
    or how can i use it?
    or can i store it in a different folder? but if i store it in a folder, how do i know whose CV is that because name and email is in table and cv is in other folder?
    any idea how to solve such kind of problem?
    thanks

  2. #2
    PowerPoster
    Join Date
    Sep 2003
    Location
    Edmonton, AB, Canada
    Posts
    2,629

    Re: uploading file in to mysql database in php?

    I have no idea what a CV is, but if it's an image of some kind then I would suggest storing it as a file on the server and not in your database. you can name it according to their name (assuming there will be no duplicate names), or the unique ID for that person in the database. you can look up how to upload files here.

  3. #3
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: uploading file in to mysql database in php?

    A CV (Curriculum Vitae) is an in-depth document describing a person's education, qualifications, awards, and so on. Usually when applying for jobs a specifically tailored résumé is used instead, but some employers expect a CV.

    I agree that a file should generally not be stored in a database.

  4. #4
    Hyperactive Member
    Join Date
    Jan 2009
    Posts
    448

    Re: uploading file in to mysql database in php?

    I personally would have them upload there CV into a folder on your server with a unique name(meaning something that cant be duplicated). Then while they are uploading and getting there unique filename insert that into the database under two fields. One for the filename and the other for the extension. Then when they want to view it open the CV file by the filename and extension combined.
    If I helped you please rate me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width