Detecting binary image types with PHP . . possible?

[metazai]

Hey - I'm playing around with storing image files as binary data in my MySQL database, and pulling them down using the following code:

PHP Code:

if($id) {  
    $conn = mysql_connect('sqladdress', 'username', 'password') or die ("Problem connecting to the database" . mysql_error() ); 
    $rs = mysql_select_db("databasename", $conn); 
    $query = "select imagebinary,filetype from show_info where id=$id";
    $result = mysql_query($query);

    $data = mysql_result($result,0,"imagebinary");
    $type = mysql_result($result,0,"filetype");

    Header( "Content-type: $type");
    echo $data;
}; 


which is saved as filetype.php, and accessed with:

<img src="filetype.php?id=1">

This works fine, but I'm setting this up for some endusers who don't know a gif from a jpg from a hole in the ground -- is there a way to use PHP to detect the file time for the header information directly from the binary code? Anybody heard of such a thing?

[sde]

i dont understand. you already have the file type there. do you mean when you initially insert the file into the database?

if you do mean when you initially insert the file, check out: getimagesize()

that returns the dimensions along with the file type of the image.

[metazai]

No, actually, I mean when you're pulling it down, but it would work either way. I wasn't aware of that command, and I think it will do what I want on either side, so let me play with that now. Thanks (again)!

[sde]

hey meta, i went to a php meetup at the block last night. it was pretty cool. you should check out the next one.

[metazai]

Maybe I will . . . do they have a website with info?

[sde]

http://php.meetup.com/41/ .. we just registered http://ocphp.com last night so it's not used yet.

[jpwjpw]

try this:

$filetype = explode("/",$_FILES['filename']['type']);

This returns the file format like 'image/jpeg' in an array split by the /(i.e.

$filetype[0] = image
$filetype[1] = jpeg