create an image database
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 posted this at 03:15 — 1st February 2010.
He has: 3,952 posts
Joined: Jun 2002
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.
a Padded Cell our articles site!
stokes1900 posted this at 11:03 — 2nd November 2010.
They have: 57 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.
Webtains | Webtains Gmbh
almo3lem posted this at 18:42 — 20th February 2011.
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);
} ?>
mark97 posted this at 15:05 — 26th February 2011.
They have: 3 posts
Joined: Feb 2011
Great post thanks a lot.
cha16ish posted this at 07:58 — 12th April 2011.
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..=)
shownkrystal posted this at 10:26 — 8th November 2011.
They have: 6 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.
background checks
shamskhan posted this at 06:55 — 26th January 2012.
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
panel posted this at 10:21 — 1st February 2012.
They have: 28 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;
panel beater perth l panel beater
NicolaDaly posted this at 09:50 — 2nd February 2012.
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
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.