Results 1 to 3 of 3

Thread: How to store a File in Databes?

  1. #1
    Junior Member
    Join Date
    Jul 2006
    Answers
    3

    How to store a File in Database?

    How to store a file in database. for example if i am upload one resume in database the path will be stored but the information i can't see. any one can please solve this problem?

    Note :This is the question asked by a vistor visitro Rajeswari. I am posting this in proper forum.

    Last edited by admin; 11-28-2006 at 07:20 AM.

  2. #2
    Contributing Member
    Join Date
    Sep 2006
    Answers
    962

    Re: How to store a File in Databes?

    Try to store the file in a column with the data type of BLOB OR CLOB ....

    -------------------
    suresh


  3. #3
    Junior Member
    Join Date
    Dec 2007
    Answers
    12

    Re: How to store a File in Databes?

    you want to store actual data from the file or just the file path???
    if u r storing data then prob. it will increase size of d db.
    instead i'll sugest u to follow these steps (to store only path)
    1.ask user to select the file to be uploaded
    2.copy that file to your application directory(created only to store d uploaded files)
    3.rename the file depending upon d username (u can us ur logic)
    4.now store this new path (appdir/filename.ext)to the db.

    now u can easily show content of uploaded file from appdir/filename.ext

    Note : u must rename d uploaded file to avoid overwriting prob.
    consider i m uploading a.txt and 2mrow u r uploading a.txt then in this case u will be overwritting my file.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact