Uploading image to mySQL via php

Anon

Hi,

I've checked out the article (url is below) on doing this, but it didn't work.

Here's the error that gets thrown up:
Warning: stat failed for C:\WINNT\TEMP\php19.tmp (errno=2 - No such file or directory) in c:\inetpub\wwwroot\rq\store.php on line 23

It does create the record in the database, but doesn't upload the file I want into the database (it does upload the file name, size, type etc and returns a unique ID)

The line of code that causes the problem is...
$data = addslashes(fread(fopen($formfile, "r"), filesize($formfile)));

And it's the fread() function is what's causing the problem.
Anyone got any suggestions?

PS Here's the article I'm refering to:
http://www.phpbuilder.com/columns/florian19991014.php3

Anon

Here is my code, and it works!
if($submit) {
if(!$image0) { echo $indent."Please specify a file.\n"; }
else {
$imageinfo = getimagesize($image0);
$size = filesize($image0);
if($imageinfo[2] != 2) { echo $indent."File is not a JPEG image.\n"; }
else if($size > $maxfilesize) { echo $indent."Image is too large.\n"; }
else {
echo "<big><big>Width = ".$imageinfo[0]." Height = ".$imageinfo[1]." ".$imageinfo[3]."</big></big>";
$image = addslashes(fread(fopen($image0, "r"), $size));
$query = "site_image SET image='".$image."', width='".$imageinfo[0]."', height='".$imageinfo[1]."', size='".$size."', caption='".$caption."'";
if($image_id) { $query = "UPDATE ".$query." WHERE id=".$news_id; }
else { $query = "INSERT INTO ".$query; }
$query .= ";";
echo $indent."File upload ";
if(mysql_query($query)) { echo "was successful"; }
else { echo "FAILED"; }
echo ".\n";
}
}
}

It makes me wonder if part of your php.ini isn't configured correctly. There are these lines in the ini:
; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =

You can view value by loading up phpinfo().

I hope that helps!

Anon

Thanks. I'll check the code out and see what happens.

But the thing is, I've written code which uploads files to a directory, and that's worked fine - and surely, that uses the temporary directory as well! So I'm confused.

fandelem

check permissions on where you're trying to write to. 9 times out of 10, that's the problem. also make sure the file_exists() before trying to open it, or test for a bad return code on fopen. it's good programming practice.

hth,

kyle

Anon

After much digging, and trying to figure out some trouble I was having, I discovered a problem with my code that might be causing your woes.

Because you are running PHP in a Windows environment, you need to add "b" to your parameters when you call the fopen() function.

This line:
$data = addslashes(fread(fopen($formfile, "r"), filesize($formfile)));
SHOULD be:
$data = addslashes(fread(fopen($formfile, "rb"), filesize($formfile)));

It's in the PHP manaul here:
http://www.php.net/manual/en/function.fopen.php
(read the note)

Happy coding!