Re: Alternative methods for storing uploaded images?
"Jacob Kruger" <[email protected]>
| Newsgroups | gmane.comp.php.windows |
|---|---|
| Message-ID | <F2B0EE4E37CD4E8183C5B64CBEA6EDC0@jakesPC> |
Definitely makes sense with regard to site performance, but, sort of in past used something like this in ASP.Net to sort of/partially make sure only signed in users/browsers could then actually 'see' images, etc., but, that could also be handled easily enough using a form of server-side redirect/reroute, etc., and, main thing is was just wondering about it, but, for now, am definitely quite content/happy enough renaming image files and then using the static content/files later on. Stay well Jacob Kruger Blind Biker Skype: BlindZA '...fate had broken his body, but not his spirit...' ----- Original Message ----- From: "Gavin Chalkley" <[email protected]> To: "'Jacob Kruger'" <[email protected]>; <[email protected]> Sent: Thursday, May 10, 2012 8:35 PM Subject: RE: [PHP-WIN] Alternative methods for storing uploaded images? > Jacob, > > I have a gallery i created with a Java template, PHP, and MYSQL. > > In the admin section you create category's and upload the images to a > folder > eg: Pictures > > On upload the script water marks and creates Thumb nails for use in the > gallery. > > http://www.helenshappyhome.co.uk/gallery.php > > Visitors can then select what gallery they wish to view, and the PHP pulls > the relevant images > > Before i did this, i did a lot of looking into it and was advised using > the > DB to store the image/binary would be a big no on performance of the site. > I > do not know how true this is. > > > BR, > > Gav > Skype : squidge1980 > > -----Original Message----- > From: Jacob Kruger [mailto:[email protected]] > Sent: 10 May 2012 19:08 > To: [email protected] > Subject: [PHP-WIN] Alternative methods for storing uploaded images? > > Just wondering if it's better to either store uploaded images, via > something > like a form of CMS, in a static folder, with a unique name based on > something like the data record's id field, when keeping track of it's > location like that, or is it better to actually store the binary data of > the > image file in the mySQL database itself, and then sort of stream it back > out > when displaying the image, and if so, would presume that would be > relatively > simple to implement, but, OTOH, if you were then using the data to then > render static content output for later use, it would, obviously, be better > to keep the image content static as well...? > > Thoughts/examples? > > Stay well > > Jacob Kruger > Blind Biker > Skype: BlindZA > '...fate had broken his body, but not his spirit...' > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php