explain to him that there is a perfomance hit to storing images in the db as well as causing some db bloat. You will also need to handle the output of the images differently to ensure that they show up

see these example for getting info in and out of the db



From: "Chetan Graham" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Storing 4KB jpeg images on hospital web server
Date: Thu, 8 Mar 2007 12:35:08 +0300 (EAT)

>  i do know there's no problem upload 4kb img to database
> but is different case for.. 1mb pic.. it always fail.
>> >>
>> >> CREATE TABLE image (
>> >> image_id int(10) unsigned NOT NULL auto_increment,
>> >> image_type varchar(50) NOT NULL default '',
> my application said is header
> ----------------------------------------------------------------
>> >> image longblob NOT NULL,
>> >> image_size bigint(20) NOT NULL default '0',
> u don't need size.. since is able to count/strlen from image
> -------------------------------------------------------------
>> >> image_name varchar(255) NOT NULL default '',
>> >> image_date datetime NOT NULL default '0000-00-00 00:00:00',
>> >> UNIQUE KEY image_id (image_id)
>> >> );
>> >>
> what u mention above, i suggest to use cms like jomlaa

Chetan wrote: I googled the jomlaa(when I first saw it I automatically
thought you were speaking your native nepalise language or something.
Indeed it is like mambo.  I will download either one and look into the CMS
aspect of it.
Back to the Hospital website.  Now the Web Boss wants to put the images in
the DB.  I do feel the webserver folders would simply and well.
However, we do what the boss says.
Again, thankyou all for your quick and wonderful help.
Blessings, Chetan

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RealLiveMoms: Share your experience with Real Live Moms just like you http://www.reallivemoms.ca/

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to