RE: [PHP-DB] Pictures in MySQL database

Agreed, i think you'll find aan easy way of doing this is to name each image after the primary key to your table (ie 1.jpg, 2.jpg, 3.jpg etc if the primary key is an autonumber. and store them all in a certain file, then when you fetch the record from the table, you can run a simple check to see if there is an image corresponding to the record number in that file, and if so, display it. (if not, you can then use a default image, or a message saying "no image". much easier than putting the binary stuff into a database! -----Original Message----- From: Miles Thompson [mailto:milesthompson@ns.sympatico.ca] Sent: 24 January 2002 14:04 To: php-db@lists.php.net Subject: Re: [PHP-DB] Pictures in MySQL database Re the PLS. Nope, replies to private email are contrary to spirit of the list. Storing inages in a database is not a good practice. Fetches are slow and the database becomes incredibly bloated. Most people store the images on disk and a reference to their location in the database and have found this faster and more reliable. Regards - Miles Thompson At 10:16 AM 1/24/2002 +0100, K wrote: >Hello, > >I would like to create database with many pictures. >I have problem with inserting pictures to table in MySQL. I created table >where one of the name of column is "image". The type of this column is >LONGBLOB. How can I insert picture into this column? I tried insert a file >(e.g. picture.jpg) to column "image" but I received so strange chars >during selecting table. > >Best regards >Kamil >PLS. Send me more info on my private e-mail. -- 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.314 / Virus Database: 175 - Release Date: 11/01/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.314 / Virus Database: 175 - Release Date: 11/01/02