[PHP-DB] Images and MySQL - please help
Hi, I am trying to do this: - I have an image stored in database 'A' - a php script should load this image, and stamp it with a watermark - then the php script should save the new image (with the watermark) in database 'B' ... How can I do this? I guess somehow I have to buffer the output, manipulate the buffer by adding the watermark, and then insert the image into the database. Is this possible? Any ideas? Thanks! DrTebi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Images and MySQL - please help
Hi DrTebi, fetch the image from database A and put it into a buffer then I guess somehow I have to buffer the output, manipulate the buffer by adding the watermark, and then insert the image into the database B ^^ Regards, Ruprecht -- E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 17-Apr-02 Time: 10:41:33 to be informed - http://www.rheyn.de - This message was sent by XFMail -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Images on MySQL
In my experience storing images on disk is simpler, easier and not messy. I wouldn't think of storing binaries in a MySQL table...It just doesn't seem right, but then again I have never tested this, only relied on my peers telling me It's not right ;) -Lasse - Original Message - From: Clever [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 12:35 PM Subject: [PHP-DB] Images on MySQL Hi, I'm designing a site and I have to store a lot of images. Which is the best for speed? 1) Store all images on a MySQL table? 2) Save them on disk like normal files and only have pointers to them on the database? Thanks a lot Clever Anjos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Images on MySQL
On Thursday 28 March 2002 19:35, Clever wrote: Hi, I'm designing a site and I have to store a lot of images. Which is the best for speed? 1) Store all images on a MySQL table? 2) Save them on disk like normal files and only have pointers to them on the database? 2) -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* The only difference in the game of love over the last few thousand years is that they've changed trumps from clubs to diamonds. -- The Indianapolis Star */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Images on MySQL
I keep hearing this from people (not to store images in mysql), but I would like to hear a bit more about why. Mysql has blob fields, so it seems perfectly reasonable to use them, doesn't it? I'm storing some images in a database and what's attractive to me about it is that I can put the images anywhere I like. I guess I could mount an image directory over NFS, but it seems easier and more consistent to use sql. Any thoughts on this? -Steve On Friday, March 29, 2002, at 05:43 AM, Jason Wong wrote: On Thursday 28 March 2002 19:35, Clever wrote: Hi, I'm designing a site and I have to store a lot of images. Which is the best for speed? 1) Store all images on a MySQL table? 2) Save them on disk like normal files and only have pointers to them on the database? 2) -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* The only difference in the game of love over the last few thousand years is that they've changed trumps from clubs to diamonds. -- The Indianapolis Star */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php