Page 1 of 1

Store File, or just path?

Posted: Wed Jan 11, 2006 3:59 pm
by gotlisch
Hi,

I'm pretty much trying to create an admin page where I can upload images to the server and then display these images. I've know how to upload a whole file to MySQL, but can I then retrieve the file and display it, or is this just for actually downloading the file. Should I store the path instead if I just want to display the image?


Cheers

Mikael

Posted: Wed Jan 11, 2006 4:05 pm
by jwalsh
I personally store the filename only, and link to the original. Mainly because I'm anal about MySQL backups regularaly, and it takes forever with all the binary content.

Posted: Wed Jan 11, 2006 6:33 pm
by John Cartwright
We've had this discussion several times throughout the forum, so it shouldn't be too hard to dig up why it is a bad idea. Although it does seem like a good idea, it is infact much slowwwwwwwwer than storing the filename.

Thanks...

Posted: Thu Jan 12, 2006 2:50 am
by gotlisch
Thanks guys,

I will go with the file path then....