Retrieving Image File from MySQL using PHP
Many people ask me about this.
Database example:
database name = “test”
table name = “image”
table column 1 = id, data type = int, special attributes = auto_increment, primary key
table column 2 = image, data type = blob
this is the sql script:
use test;
create table image (id int(11) NOT NULL auto_increment, image blob, PRIMARY KEY(id));
this is the php script:
<?
header(”Content-type: image/jpeg”); // act as a jpeg file
mysql_connect(”your_host”,”your_db_username”,”your_db_password”);
mysql_select_db(”test”); // use the ‘test’ database$query = “select image from image where id = $id”;
$result = mysql_db_query(”test”,$query);$row = mysql_fetch_array($result);
$img = $row['image'];echo (”$img”);
?>
There you go, you will see the image that you store in MySQL database using blob data type.
Enjoy! ![]()
About this entry
You’re currently reading “Retrieving Image File from MySQL using PHP,” an entry on Complicated Mind
- Published:
- 31.03.05 / 11:31 pm
- Category:
- Tech Talk

8 Comments
Jump to comment form |