Image and pdf upload to MySQL

[Rob (SA)]

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

[bluewalrus]

I'd recommend just uploading the files to your server and logging their location in the DB.

[Rob (SA)]

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

[timbim]

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.

[Rob (SA)]

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