Re: Storing 4KB jpeg images on hospital web server
| From: | Bastien Koert | Date: | Thu, 08 Mar 2007 12:29:56 +0000 |
| Subject: | Re: Storing 4KB jpeg images on hospital web server | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43232@lists.php.net to get a copy of this message | ||
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@amritatech.com> 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._________________________________________________________________ RealLiveMoms: Share your experience with Real Live Moms just like you http://www.reallivemoms.ca/my application said is header ----------------------------------------------------------------CREATE TABLE image ( image_id int(10) unsigned NOT NULL auto_increment, image_type varchar(50) NOT NULL default '',u don't need size.. since is able to count/strlen from image -------------------------------------------------------------image longblob NOT NULL, image_size bigint(20) NOT NULL default '0',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.phpimage_name varchar(255) NOT NULL default '', image_date datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY image_id (image_id) );