Definisi BLOB
sebenarnya ada cara yang sering digunakan untuk menyimpan image adalah dengan metode PATH, yaitu gambar/file di simpan di subdirektori website kita. namun kali ini kita mencoba menggunakan tipe data BLOB. Apa sih BLOB itu kok dari tadi bahas BLOB hehe… BLOB adalah suatu tipe data di DBMS engine singkatan dari BINARY LARGE ORBJECT.
Kita menggunakan Bahasa Pemrograman PHP dengan Database MySQL, siapkan dulu tabelnya di MySQL:
[sourcecode language=”html”]
CREATE TABLE IF NOT EXISTS `store` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`image` blob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
[/sourcecode]
Buat script index.php sebagai berikut :
[sourcecode langauge=”html”]
<html>
<head>
<title>Upload</title>
</head>
<body>
<form action="index.php" method="POST" enctype="multipart/form-data">
File:
<input type="file" name="image" accept="image/*"><!–We will allow any type of images such as
jpg or png or etc–>
<input type="submit" name="submit" value="Upload">
</form>
<?php
error_reporting(E_ALL ^ E_NOTICE);
//connect to database
mysql_connect("localhost","root","1105") or die (mysql_error());
mysql_select_db("simpangambar") or die (mysql_error());
if(isset($_POST[‘submit’]))
{
//file properties
$file=$_FILES[‘image’][‘tmp_name’];
$image_name=mysql_real_escape_string($_FILES[‘image’][‘name’]);
$image=mysql_real_escape_string(file_get_contents($file));
$image_size=getimagesize($file);
if($image_size==FALSE)
{
echo "That is not an image";
}
else
{
$insert=mysql_query("INSERT INTO store (name,image) VALUES
(‘$image_name’,’$image’)");
if($insert)
{
echo "OK!";
$lastid=mysql_insert_id();
echo "Image<p/>Your image: <img src=get.php?id=$lastid>";
}
else
{
echo "PROBLEM!";
}
}
}
else
{
echo "That is not an image!";
}
?>
</body>
</html>
[/sourcecode]
Kemudian buat 2 buah file sebagai berikut :
1. File img.php, untuk menyimpan data ke dalam database
[sourcecode language=”php”]
<?php
error_reporting(E_ALL ^ E_NOTICE);
mysql_connect("localhost","root","5") or die (mysql_error());
mysql_select_db("simpangambar") or die (mysql_error());
$query = mysql_query("SELECT * FROM store");
while($row=mysql_fetch_array($query))
{
echo $id=$row[‘id’];
echo ". ";
echo $row[‘name’];
echo " ";
echo "<img src=get.php?id=$id>";
echo "<br/>";
}
?>
[/sourcecode]
2. File Get.php, digunakan untuk menampilkan data gambar yang tersimpan di database
[sourcecode language=”php”]
<?php
mysql_connect("localhost","root","") or die (mysql_error());
mysql_select_db("simpangambar") or die (mysql_error());
$id=mysql_real_escape_string($_REQUEST[‘id’]);
$select=mysql_query("SELECT * FROM store where id=$id");
$image_fetch=mysql_fetch_assoc($select);
$image=$image_fetch[‘image’];
header("Content-type: image/*");
echo $image;
?>
[/sourcecode]
Output Program :
