Results 1 to 5 of 5

Thread: Image and pdf upload to MySQL

  1. #1
    Join Date
    May 2007
    Location
    South Africa
    Posts
    175
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default Image and pdf upload to MySQL

    Hi Folks,

    I am trying to find a script that will allow me to upload pdf's and images to MySQL and additionally retrieve them at a later stage with a query of some sorts.

    I would appreciate any advice there is to offer ?

    Regards
    Rob

  2. #2
    Join Date
    May 2007
    Location
    Boston,ma
    Posts
    2,127
    Thanks
    173
    Thanked 207 Times in 205 Posts

    Default

    I'd recommend just uploading the files to your server and logging their location in the DB.
    Corrections to my coding/thoughts welcome.

  3. #3
    Join Date
    May 2007
    Location
    South Africa
    Posts
    175
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default

    Hi ,

    Thanks for the reply.

    I am not sure how this would work.

    I have tournaments that take place all over the country and would like the adminitrater to upload the photograph of the champion.

    Once uploaded I have another file that allows the kids to veiw results and of course a photo of the winner.

    Ideas are welcome

    Regards
    Rob

  4. #4
    Join Date
    Jun 2010
    Posts
    13
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default

    You upload the photo and store it in a photos directory. You then store the filename of the photo in the database so that you can then insert the full path into a page, the browser then retrieves the image.

    No point storing images in a database.

  5. #5
    Join Date
    May 2007
    Location
    South Africa
    Posts
    175
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default

    Hi,

    Thanks for the reply, it does make sense.

    I will find a way to load them up.

    My next challenge is to get the image to show when I select a certain event

    Regards
    Rob

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
  •