Problem Uploading File to mySQL

Anon

New to PHP and mySQL (but have successfully tackled most things).

i am having problems loading a small (16k) JPEG into a mySQL dbase (BLOB field).

I am using a web page to browse and upload.

I get a 'not a valid File-Handle resource' error after:
$data=fread($smallLogo,$smallLogo_size);

Using filetype on the $date variable returned by the form shows that it is a file. - $data which is /var/tmp/php000409

What am I doing wrong?

[deleted]

First of all, I would advise against loading binary data into a MySQL database. It makes no sense and will only slow you down.

Second, 'not a valid filehandle' means you are trying to read from a filehandle that was not opened.
Normally, you will get an error message when you try to open the file.
Check the filename, and see why you are not getting an error from the function that opens the file.

Anon

I take the point about binaries and, yes, I can live without storing them in the database itself.

I do, however, want to nail this one so I can move on.

The 2 lines of code at the heart of this are:-

echo "<br> filetype is ".filetype($smallLogo)."<br>";

this one (correctly) tells me that $smallLogo - from a form - is a file (interrogating the file size and type gives: Original file name:0134613449.gif
Size: 17940
Type: image/gif) - so I thought I'd got a vlid file and path name at this point).

I then try to read the file using

$data=fread($smallLogo,$smallLogo_size);

at which point I get the error. Incidentally $smallLogo is typically of the form :
/var/tmp/php000292

which is what I'd expect.

What else can I check/is there a glaring error here?

Cheers.

Nic

[deleted]

Are you accessing the file through global vars or through the $HTTP_POST_FILES array?

http://www.php.net/manual/en/features.file-upload.php

"In PHP 4, the behaviour is slightly different, in that the new global array $HTTP_POST_FILES is provided to contain the uploaded file information"

http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=77