SitePoint Sponsor

User Tag List

Results 1 to 11 of 11
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Which Is The Preffered File Uploads Mechanism

    I am a beginner php programmer but I have been able to designe a web forum, so I am not so much of a newbie. any way I am about to design a site where visitors can upload music. I want to know what is the preferred means of storing this data server or database. Please any one with useful information should please help me out.

  2. #2
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    a little help please

    I just got this job to design a mp3 file upload / download site. I am really considering which upload mechanism to use. what I would really like to know is what the professionals out there are using, and I also seem to have a problem uploading files greater than 1mb to the mysql database. any little information would be of great help. thanks guys in advance.

  3. #3
    SitePoint Evangelist -Oz-'s Avatar
    Join Date
    Nov 2001
    Location
    Phoenix, AZ, USA
    Posts
    406
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    java linked to php works great for me because it displays progress bars and such:
    http://www.jupload.biz . Also with that script allows for drag n drop.
    Oz
    GamersMark - On Target Gaming
    OzTheory - Programming and Web Solutions
    AmIBlocked - Check if you've been blocked on IM

  4. #4
    SitePoint Wizard
    Join Date
    Jan 2004
    Location
    3rd rock from the sun
    Posts
    1,005
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    isempty()

  5. #5
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ----------

    hey guys thanks for the reply, I really liked the script that shows file upload progress, I am sure it will be of help to me. what I really want to Know is: which is the best place to store my files: the mysql db or the webserver file system. some one with a lil experience should please help me out. before I make my decision

  6. #6
    SitePoint Evangelist -Oz-'s Avatar
    Join Date
    Nov 2001
    Location
    Phoenix, AZ, USA
    Posts
    406
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    webserver then store where the files are located in the database.
    Oz
    GamersMark - On Target Gaming
    OzTheory - Programming and Web Solutions
    AmIBlocked - Check if you've been blocked on IM

  7. #7
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks oz for the reply; any particular reason why the webserver is the best choice

  8. #8
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is there ant body here with valuablei information on which file upload mechanism I shld use... file server or db.

  9. #9
    dooby dooby doo silver trophybronze trophy
    spikeZ's Avatar
    Join Date
    Aug 2004
    Location
    Manchester UK
    Posts
    13,807
    Mentioned
    158 Post(s)
    Tagged
    3 Thread(s)
    OK, it's more a matter of preference rather than which method is better.
    From my point of view, I always use a file server and save the path to the file into the database. It makes managing the database easier and also editing the database is a doddle.
    If you have all the files on a server, you can also reduce the size of your database. For example, if you had 100 mp3 files that are 10mb in size that equates to 1000mb - quite a big database in one place. If your files are spilt over 2-3 servers and their location stored in the database you can even out the usage. If you multiply the file count to 1000 or 10,000 it starts to make sense.

    HTH

    Spike
    Mike Swiffin - Community Team Advisor
    Only a woman can read between the lines of a one word answer.....

  10. #10
    SitePoint Zealot logitron's Avatar
    Join Date
    Feb 2006
    Posts
    144
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I definately agree with Spike. Use a File Server and keep a location in a database. You do not want to overload your database with that kind of information. Just way too big. :P

    ~Patrick Smith~

  11. #11
    SitePoint Wizard silver trophy Jelena's Avatar
    Join Date
    Feb 2005
    Location
    Universum, 3rd Corner
    Posts
    3,000
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I'm with spikeZ on this subject. Especially if you are dealing with lots of large files. Although, if you are planning to store them on one server, I would even store only file names in db, and creating full path and URL on the fly. Moving whole site to the different server would mean that you don't need to change a thing
    -- Jelena --


Bookmarks

Posting Permissions

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