Content- type won't change, dynamic image

bakermx · 07-30-2008, 06:37 PM

Hi, I came across an issue while trying to dyamically change the content-type to the right type for an image

Here is show.php

Code:

<?php
include('inc/db.php');

$id = $_GET['id'] ;

   $query = "SELECT imgdata,type FROM pics WHERE id=$id";
   $result = MYSQL_QUERY($query);
   $data = MYSQL_RESULT($result,0,"imgdata");
   $type = MYSQL_RESULT($result,0,"type");
   Header( "Content-type: $type ");
echo $data;

?>

and here is the database structure

Code:

CREATE TABLE pics (
	id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	type TEXT,
	caption VARCHAR(255),
	albumid INT(10) NOT NULL,
    imgdata LONGBLOB )

Does anyone see any issues with these?

Any Help would be appreciated,
thanks.

- The issue is it outputs the data as text/plain ,
I failed to mention this previously

buggabill · 07-31-2008, 09:07 PM

Are you storing the full type like 'image/jpeg' or something like 'jpeg'?

php Code:

// This would be appropriate for jpegs
header("Content-type: image/jpeg");

If the content type is not correct, the browser may default to text/plain.

xenon · 07-31-2008, 09:09 PM

Binary data does not equal plain text. You can't store binary data in a varchar field. Use the blob type instead.

buggabill · 08-01-2008, 03:12 PM

Quote:

sql Code:

CREATE TABLE pics (
    id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    type TEXT,
    caption VARCHAR(255),
    albumid INT(10) NOT NULL,
    imgdata LONGBLOB )

They are storing the imgdata in a LONGBLOB field.

xenon · 08-01-2008, 09:34 PM

Right. Didn't see that. My bad. However, you should try putting an exit; after that echo, and remove the ?> sign from the end. That way, you're making sure that nothing after that point will be sent to the browser. And, you should use the same content type the image had before inserting it into the database. You're probably doing that already, I assume.

bakermx · 08-02-2008, 02:22 PM

I'm using image/foo.
It is stored in the database for that particular image so that it always has the right type. I know it's selecting the right content-type also because if I echo out the type instead, i get image/jpeg for a jpeg image and the same with png.
It worked on zymic.com's servers, but not 1and1.com's so it puzzles me.