create an image database

Hi Au, welcome to the forums!

You could use one of the many photo galleries out there. Check out Gallery or Zenphoto. Both those should allow searching.

if your question is about how to store images in database then my suggestion is do not store images in database. because your database will become bulky. it is better to store them in different
folder.and only store name in database.

in php & mysql
use this command to create database :

CREATE TABLE `imagesdb` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`photdata` LONGTEXT NOT NULL ,
PRIMARY KEY ( `ID` )
);

use this command in php to encrypt the image :
// filename
$finalimage = chunk_split(base64_encode($filename));
$sql = "INSERT INTO imagesdb SET photo='$finalimage";
mysql_query($sql);
?>

use this command in php to decrypt the image :

while ($row = mysql_fetch_array($result)) {
$thenewimage= $row["photo"];
echo base64_decode($thenewimage);
} ?>

Great post thanks a lot.

. I need some help for my project . I just want to asks for the entities and attributes that can be found in a condominium business,, please help me. thank you..=)

If you a create an image database then you can use best one software is php and vb.net.It's a very nice and you can easily using this software database.

you can create image database in MS SQLSERVER and you can make it front end in window application in c# and vb.net etc....

very amzaing .... me also working on this

SQL statements to create the database you need:

create database files;
use files;

CREATE TABLE files (
id int(11) NOT NULL auto_increment,
shortName varchar(50) default NULL,
mimeType varchar(30) default NULL,
mimeName varchar(50) default NULL,
fileContents blob,
PRIMARY KEY (id)
) TYPE=MyISAM;

storing images in a mysql database.

$handle = fopen("testpic.jpg", "rb");
$img = fread($handle, filesize('testpic.jpg'));
fclose($handle);
//die($img);

$img = base64_encode($img);

database_connect
('localhost', 'root', 'admin', 'img_test', &$db_selected, &$connection);

$sql = "insert into pictures values(null,'$img','jpg','female')";

mysql_query($sql) or die('Bad Query at 12');

echo "Success! You have inserted your picture!";
?>

______________________________________________________
Application Support

do NOT use database for storing images. use plain files instead, or you'll get performance problems when database becomes large enough

How to create image database in mysql?

Regards,
Sabareesh

CREATE TABLE `imagesdb` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`photdata` LONGTEXT NOT NULL ,
PRIMARY KEY ( `ID` )
);

use this command in php to encrypt the image :
// filename
$finalimage = chunk_split(base64_encode($filename));
$sql = "INSERT INTO imagesdb SET photo='$finalimage";
mysql_query($sql);
?>

use this command in php to decrypt the image :

while ($row = mysql_fetch_array($result)) {
$thenewimage= $row["photo"];
echo base64_decode($thenewimage);
} ?>
SQL server

please help,i am doing thesis in image segmentation in matlab,can any tell me how to create dataset from an image so that i can used for clustering purpose..

great post thanks a lot !!!

great post thanks a lot !!!

hmm really a nice post.