Insert binary data in to mySQL via PHP

Anon

Hi,

I've read the article on uploading binary data into a blob field (in this case, uploading images...) on this site and I tried to use the script given with it. T

he problem I'm having is that when I go to open the submitted file, the script crashes out saying it can't find the file.

This is odd because I've also written a script that uploads a file to any given directory (via 'copy'), and this also uses my TEMP directory that I'll assume the file is being stored in while it's being uploaded.

<?php
if ($submit) {
$filein = addslashes(fread(fopen($formfile, "rb"), filesize($formfile)));
MYSQL_CONNECT("localhost","james","biteme");
mysql_select_db("rq");
$result = MYSQL_QUERY("INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) VALUES ('$formdescription','". $filein ."','$formfile_name','$formfile_size','$formfile_type')");
$id = mysql_insert_id(); print "Information: '$formfile_name' has been given the ID: $id";
MYSQL_CLOSE();
}
?>

The problem occurs at the fread(fopen()) function - it simply can't read the file, which is what's causing the problem.

Has anyone any suggested solutions?

Thanks & regards,
James.

Anon

I've fixed my original problem, I can now save binary data into the database (it was a problem with the fread, reading the file size etc)

Now I'm having a problem retrieving the image - here's the code - and I can't see any problems. The result it returns is the broken image every time (the little red X).

<?php
if($id) {
@MYSQL_CONNECT("localhost","jay", "x");
@mysql_select_db("rq");
$query = "select bin_data, filetype from binary_data where id=$id";
$result = @($query);
$data = @MYSQL_RESULT($result,0,"bin_data");
$type = @MYSQL_RESULT($result,0,"filetype");
$data = stripslashes($data);
header("Content-type: $type");
echo $data;
};
?>

Any suggestions?

Regards,
James.