[amazonify]032152599X:left[/amazonify]
As our data getting mobile and copying picture is annoying for me I decide to save the picture in the database (mysql).
Another challenge came when other division need the data exported in a directory with same dimension (135 x 180 pixel).
Structure for table ‘student_pic’ :
CREATE TABLE `student_pic` (
`image_id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(50) NOT NULL default ”,
`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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3385 ;
Yes, I use mysql 5 ( 5.0.45)
About