hmm really a nice post.

Adsystem — Fri, 28 Dec 2012 06:13:30 +0000

great post thanks a lot !!!

giffy — Fri, 14 Dec 2012 05:26:29 +0000

great post thanks a lot !!!

giffy — Fri, 14 Dec 2012 05:26:26 +0000

great post thanks a lot !!!

please help,i am doing thesis

bharat kumar padhi — Mon, 03 Dec 2012 04:19:55 +0000

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

create table table name (

snapshotcrm — Fri, 26 Oct 2012 13:21:59 +0000

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

CREATE TABLE `imagesdb`

dbgurus — Sat, 15 Sep 2012 11:20:46 +0000

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

How to create image database

sabareesh — Fri, 31 Aug 2012 09:19:11 +0000

How to create image database in mysql?

Regards,
Sabareesh

do NOT use database for

MasterOfPuppets — Sat, 18 Aug 2012 22:01:13 +0000

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

storing images in a mysql

NicolaDaly — Thu, 02 Feb 2012 09:50:44 +0000

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

SQL statements to create the

panel — Wed, 01 Feb 2012 10:21:50 +0000

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;