This tutorial will show you how to display your images (binary data) which has been saved in your mySQL database.

It’s very very simple.. so.. simple…. (read also: Storing Images/Binary Files to mySQL in PHP)

First of all we must connect to our database

$username = “”; – It’s your database’s username
$password = “”; – It’s your database’s password
$host = “localhost”; – It’s your database’s host, usually it’s localhost but it can be something else also
$database = “”; – It’s your database

Now let’s connect to the database

@mysql_connect($host, $username, $password) or die(“Can not connect to database:”.mysql_error()); – This connects to your database

@mysql_select_db($database) or die(“Can not select the database: “.mysql_error()); – This will select your database

Now let’s get our id

It will get a id from an URL. blabla.com

So.. your id will be 3 and it will show an image which id is 3

if(!isset($id) || empty($id)){ – If this ID in your url is empty like ?id= of if it’s not even set
die(“Please select your image!”); – lets display an error
}else{ – But if it is set let’s continue with showing our image

$query = mysql_query(“SELECT * FROM tbl_images WHERE id='”.$id.”‘”); – Now let’s select the blob from the table where id is $id (for example: 3)

$row = mysql_fetch_array($query); – Let’s gather our info about image which id is $id into one variable

$content = $row[‘image’]; – Get’s the blob from our table
Now let’s display our image

header(‘Content-type: image/jpg’); – This tells to the browser and to the server that this file will be a jpg file

echo $content; – This will display our blob..

} – Ends else
Okay.. now here’s our full script.

It works perfectly

Enjoy… 🙂     If you have questions then please feel free to ask