RE: [PHP-DB] Another Image prob

Don't think that was the answer he was looking for =]. Here's how I retrieve images stored as blobs. $query = "select File, Type from Pictures_Data where id=$id"; $result = mysql_query($query); $data = mysql_result($result, 0, "File"); $type = mysql_result($result, 0, "Type"); Header( "Content-type: image/$type"); echo "$data"; Btw, if you are going to be storing a large number of pictures or other binary files as blobs, try to put them in their own table. I original had one table with miscellanous information in it as well as the blobs, and it did get slow on certain queries. Creating two tables with the records linked via id solved the problem. Regarding the post about storing blobs in databases. I agree that in days past that it was not a good idea to do such because it does have a serious impact on database performance. However, has anyone been paying attention to the cost of hardware these days? Anyone with a serious project should have plenty of money to throw hardware at the problem. Perhaps not elegant, but I think performance and ease will beat elegant any day of the week. My personal preference for storing images as blobs is that it makes the syncing of my servers much easier. Rather than using MySQL replication and rsync to keep the same content on my servers, I can simply use MySQL replication and not have to worry about my image data and the image being out of sync. Course perhaps a dedicated machine to store the images served to multiple frontend servers via NFS might work better, but again, performance has been sufficient so far in my experience that I'm not worried about it. I would be interested in other's thoughts on how to best tackle the problem in a multiple server situation. HTH -- Barry Jeung Team Lynx, Inc. Senior System Engineer 1217 Montgomery Avenue http://www.TeamLynx.com Second Floor E-Mail: BJeung@TeamLynx.com San Bruno, CA 94066-1521 Phone: 650.589.3200 Fax: 650.589.2555 > -----Original Message----- > From: Rick Emery [mailto:remery@excel.com] > Sent: Friday, September 14, 2001 10:58 AM > To: php-db@lists.php.net > Subject: RE: [PHP-DB] Another Image prob > > > The consensus is that it is best if you DO NOT store the > images as blobs in > a database. Rather, store the images in separate files and > store the names > of those files in the database. Then retrieve the file names for the > database, open the image files, and then send the images to > the client's > browser. Storing images as blobs tends to make the database unwieldy. > > -----Original Message----- > From: Todd Moy [mailto:metonym@metonym.org] > Sent: Friday, September 14, 2001 1:46 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Another Image prob > > > I'm new at this and i'm sure that this has been answered before, but > anyway... > I am trying to retrieve images from a MySQL database. They > are stored as > BLOBs with the following table format: > > Database metonym_metonym - table imgs > Field Type Attributes Null Default Extra > fk_proj_id int(3) No 0 > imgname varchar(30) > imgtype varchar(20) > img blob > > Keyname Unique Field > PRIMARY Yes fk_proj_id > > Is it possible to do this with a printf/ img src statement? > Also, I have heard some talk about header information on > retrieval-> how > does this relate to retrieving an image? > > Bear in mind that these images are being uploaded via HTML form > Thanks in advance > METONYM > > -- > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > >