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

Attached Files

To view attachments in this forum your post count must be 1 or greater. You currently have 0 posts.

__________________

If `id` is always to be an integer, it would be wise to add: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.

__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum | My Blog
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall

this is cool script, thanks mod too much

you're welcome

__________________

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

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

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

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

i believe it works

__________________

Well, great tutorial. +rep

__________________
Free Web Templates like WebSpell, FrontPage and more.

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

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

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