RE: [PHP-DB] Storing 4KB jpeg images on hospital web server

best sore the image on the filesystem and use that field to store the path and image name. Its simpler to manage Bastien

From: "Chetan Graham" <chetan_graham@amritatech.com> To: php-db@lists.php.net Subject: [PHP-DB] Storing 4KB jpeg images on hospital web server Date: Thu, 8 Mar 2007 07:06:39 +0300 (EAT) Hi to All, There is a page on our hospitals website where a patient can look at the choice of different doctors with their credentials, publications, hobbies, etc.Each doctor has or will have a 3-4KB jpeg image as well. We are using MySQL5.0.2.7 with PHP5.2.1 My question concerns the following: The existing table's fields with one for the image: TABLE finddoc id-int,not null, auto inc., unsigned, name varchar(25), desig varchar(30), dept varchar(20), email varchar(50), image varchar(6000), qualification varchar(100), publications longtext, areaofinterest longtext, not null, achievements longtext not null, My job is to develop a page where a admin user can create and edit existing doctor profiles. My question is about the image uploading part. I have a feeling the one field given to me for images is quite limited. Would it not be better to add another table with all the image info. such as the following? CREATE TABLE image ( image_id int(10) unsigned NOT NULL auto_increment, image_type varchar(50) NOT NULL default '', image longblob NOT NULL, image_size bigint(20) NOT NULL default '0', 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) ); This will give greater control of the images or better manipulation of data. If it is recommended by you php/mysql higher souls to add a table such as this. Then I have more questions. Or perhaps the existing table is fine. One might guess I inherited this project. Blessings, Chetan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________ Win a trip for four to a concert anywhere in the world! http://www.mobilelivetour.ca/