LOAD,SAVE and RETRIVE PICTURE FROM MySql database USING DELPHI - HELP PLEASE !!!

Question

LOAD,SAVE and RETRIVE PICTURE FROM MySql database USING DELPHI - HELP PLEASE !!!

havsys (Programmer)

(OP)

28 Sep 12 17:03

Hello,

I need help with delphi project. I use delphi 2007 and MySql Database.

1. I want to load picture from TOpenPictureDialog to TImage (or TDBImage).
2. Picture from Timage (or TDBImage) I want to save to MySql database in table Picture field 'IMG'(longblob).
3. I want to retrieve image from my database table 'IMG' and show in TImage (or TDBImage).
4. I will have DBGrid on my main form. When I clik on GBgrid row or when I scroll GBGrid I want to see that picture are changing.
5. How to convert jpg to gif, or how to Shrink picture or limit picture to be H:161px and W:138px, that is a size of my TImage.

My database(MySql) have 4 table (contacts, city, country and picture).
Database will be small maybe 200 contacts so I think that saving picture in database is not a problem.

On my Main form I have DBGrid, TImage (or TDBImage), AddContact button, ChangeContact Button, DeleteContact Button,
ChoosePicture Button, Save and Cancel Button, and DBEdit's from AdoDataSet,
TAdoConnection,TAdoDataSet and DataSource, TOpenPictureDialog.

This is my database:

CODE -->

CREATE TABLE `picture` (
 `ID` int(10) unsigned NOT NULL auto_increment,
 `CAPTION` varchar(45) default NULL,
 `IMG` longblob,
 PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 CREATE TABLE `country` (
 `ID` int(10) unsigned NOT NULL auto_increment,
 `NAME` varchar(45) NOT NULL,
 `AREACODE` varchar(45) default NULL,
 PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 CREATE TABLE `city` (
 `ID` int(10) unsigned NOT NULL auto_increment,
 `NAME` varchar(45) NOT NULL,
 `ZIPCODE` int(5) unsigned default NULL,
 `COUNTRYID` int(10) unsigned default NULL,
 PRIMARY KEY (`ID`),
 KEY `FK_city_1` (`COUNTRYID`),
 CONSTRAINT `FK_city_1` FOREIGN KEY (`COUNTRYID`) REFERENCES `country` (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 CREATE TABLE `contacts` (
 `ID` int(10) unsigned NOT NULL auto_increment,
 `FIRSTNAME` varchar(45) NOT NULL,
 `LASTNAME` varchar(45) NOT NULL,
 `ADDRESS` varchar(45) default NULL,
 `PHONE` int(10) unsigned default NULL,
 `CITYID` int(10) unsigned default NULL,
 `PICID` int(10) unsigned default NULL,
 PRIMARY KEY (`ID`),
 KEY `FK_contacts_1` (`CITYID`),
 KEY `FK_contacts_2` (`PICID`),
 CONSTRAINT `FK_contacts_2` FOREIGN KEY (`PICID`) REFERENCES `picture` (`ID`),
 CONSTRAINT `FK_contacts_1` FOREIGN KEY (`CITYID`) REFERENCES `city` (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Thank you for your time and knowledge.

Come Join Us!

Posting Guidelines

Jobs

LOAD,SAVE and RETRIVE PICTURE FROM MySql database USING DELPHI - HELP PLEASE !!!