create an image database

They have: 1 posts

Joined: Jan 2010

Hi folks, my first time in the forum so thanks to all in advance. I want to build a website which is able to search a collection of images I have collected. I want to be able to search by date, topic, name. Is there an affordable and out of the box method for doing this? If there isn't, can someone recommend how I might go about doing this.
Again thanks for all replies

Au

JeevesBond's picture

He has: 3,955 posts

Joined: Jun 2002

Hi Au, welcome to the forums! Smiling

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

a Padded Cell our articles site!

stokes1900's picture

They have: 55 posts

Joined: Oct 2010

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.

He has: 7 posts

Joined: Feb 2011

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);
} ?>

They have: 3 posts

Joined: Feb 2011

Great post thanks a lot.

They have: 3 posts

Joined: Apr 2011

. 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..=)

They have: 4 posts

Joined: Nov 2011

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.

They have: 20 posts

Joined: Jan 2012

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

They have: 25 posts

Joined: Jan 2012

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;

They have: 11 posts

Joined: Oct 2010

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

They have: 5 posts

Joined: Aug 2012

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

They have: 1 posts

Joined: Aug 2012

How to create image database in mysql?

Regards,
Sabareesh

They have: 2 posts

Joined: Aug 2012

create table table name (
image_id serial,
image_name varchar(255) not null,
mime_type varchar(255) not null,
image_size int not null,
image_data longblob not null,

primary key (image_id),
index (filename)
);

They have: 1 posts

Joined: Sep 2012

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

They have: 1 posts

Joined: Dec 2012

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..

They have: 15 posts

Joined: Dec 2012

great post thanks a lot !!!

They have: 15 posts

Joined: Dec 2012

great post thanks a lot !!!

They have: 8 posts

Joined: Dec 2012

hmm really a nice post.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.