Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

[Jaan]

Okay..I'm going to show y'all how to show your images.. those which are in your DB It's very very simple.. so..

First of all we must connect to our database

<?php

$username = "";
$password = "";
$host = "localhost";
$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());

@mysql_select_db($database) or die("Can not select the database: ".mysql_error()); 

@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

$id = $_GET['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)){
die("Please select your image!");
}else{ 

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."'");
$row = mysql_fetch_array($query);
$content = $row['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');
echo $content;

} 

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.

<?php

$username = "";
$password = "";
$host = "localhost";
$database = "";

@mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error());

@mysql_select_db($database) or die("Can not select the database: ".mysql_error());

$id = $_GET['id'];

if(!isset($id) || empty($id)){
die("Please select your image!");
}else{

$query = mysql_query("SELECT * FROM tbl_images WHERE id='".$id."'");
$row = mysql_fetch_array($query);
$content = $row['image'];

header('Content-type: image/jpg');
echo $content;

}

?>

It works perfectly


Enjoy
If you have questions then please feel free to ask

[John]

If `id` is always to be an integer, it would be wise to add:

if(!is_int($id) {
die("That image is not valid.");
} 

That way your code is not nearly as vulnerable to SQL injections. I would also add mysql_real_escape_string($id) inside the query too - but not absolutely necessary. Other than that, nice tutorial.

[danchoivt]

this is cool script, thanks mod too much

[Jaan]

you're welcome

[ClassicGlory]

Jaan,

I loved your easy to follow instructions but I want to do something slightly different. I have a MySQL db and want to display a Blob image from it into a table populated by PHP.
I have a MySQL query which selects all records from the database and then displays the text content from each record on a row in the table.
I want one of the table cells in each row to display the blob image.

How do I do this?

Regards

CG

[Jaan]

I believe.. then you should create a real images from those blobs.. use this tutorial to create those images:

Create files with php

there.. this blob will be this $content.. so replace it..

and then.. after your script ends.. just delete those images.. then just use

unlink(); 

but..when you're creating a name for your file.. use

uniqid(); 

then when you have lot's of users it won't delete someone else image

i believe it works

[ReekenX]

Well, great tutorial. +rep

[Asinox]

Hi everybody, sorry with my english... this is my first post here....
i hav a question

¿how ill show all images from my DDBB where i hav user ID?

this tutorial show just 1 images ....but if i hav a lot of picture and i need to show all of the USER ID x?

im trying to do a while but i cant do this work

Some Help?

Thanks

[coated_pill]

i have a script to show thumbnails in table but the image become corrupted in the net.. how would i solve this problem?? please help me thank you

[coated_pill]

if you need the script i would gladly show you .. i was wondering if i did the right thing on the MySQL dbase