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
http://www.weberdev.com/get_example-4063.html
http://www.weberdev.com/get_example-4062.html
bastien
From: "Chetan Graham" <chetan_graham@xxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Re: 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
