mySQL BLOB Problem

ziycon · #1 (**permalink**) 17-11-2007, 05:08 AM

I am retrieving a blob from the DB and trying to display it on a page as an image. The problem is i just get the image reference(listing.php?id=3) displaying on the page and a prompt pops up to download the image!?! Below is the code i have to receive the image:

PHP Code:

  $sql_img = "SELECT img_name,img_size,img_type,img_content FROM listings WHERE id = ".$_GET['id']." LIMIT 1";
$data_img = mysql_query($sql_img);
list($name,$size,$type,$content) = mysql_fetch_array($data_img);

header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");

And im displaying it like so:

Code:

<img src="listing.php?id=3">

babyboy808 · #2 (**permalink**) 17-11-2007, 10:40 AM

Wouldn't displaying it at "listing.php?id=3" only be html?

You need to insert the variable that you created for the image into the img.

something like: <img src="$data_img" alt="" />

ziycon · #3 (**permalink**) 17-11-2007, 04:30 PM

Quote:

Originally Posted by babyboy808

Wouldn't displaying it at "listing.php?id=3" only be html?

You need to insert the variable that you created for the image into the img.

something like: <img src="$data_img" alt="" />

That doesn't work either, just prompts me to download the images again!?!

georgiecasey · #4 (**permalink**) 17-11-2007, 07:41 PM

Get rid of header("Content-Disposition: attachment; filename=$name");

That forces the browser to download.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Connecting to 2 Mysql database in the same script??	Ciarán Mc Cann	Coding Help	11	24-07-2007 10:21 AM
PHP mySQL Problem!?	ziycon	Server / Technical Administration Tips and Queries	1	15-07-2007 08:31 PM
mysql	3rigena	Webmaster Discussion	4	24-05-2007 09:33 PM
MySQL Optimisation?	blacknight	Server / Technical Administration Tips and Queries	5	15-01-2007 05:17 PM
CSV to MySQL Conversion Tools?	blacknight	Coding Help	7	04-01-2007 11:00 AM

Sponsored links

mySQL BLOB Problem

mySQL BLOB Problem

Similar Threads

Sponsored links