The Return Of The Image Upload Question

[Anon]

Uploading an image to mysql, for a shopping cart application, I've got a form that posts to this (and more, of course):

$set = "SET name='".$name."', description='".$description."', stock_no='".$stock_no."', summary='".$summary."'";
If ($photo != "none") {
$data = addslashes(fread(fopen($photo, "r"), filesize($photo)));
$set .= ", photo_binary='".$data."', photo_type='".$photo_type."'";
}
If ($item_id > "") {
$sql = "UPDATE items ".$set." WHERE item_id='".$item_id."'";
} Else {
$sql = "INSERT INTO items ".$set.", sub_cat_id='".$sub_cat_id."'";
}

When I echo $sql, I get:
UPDATE items SET name='blah', description=' blah', stock_no='blah', summary='blah', photo_binary='Content-Type: image/pjpeg ÿØÿà\0JFIF...etc. and my HTTP_POST_FILES["photo"] type is empty. On another server where I've got this script working, photo type is not empty, and photo_binary='ÿØÿà\0JFIF...etc. (and it works fine)

So why does one server successfully pull the image type off the front of the image and store it in the $HTTP_POST_FILES["photo"] array and the other server does not? Ideas, anyone?

thanks, as always

[Anon]

hmmmm when i have to upload stuff I just use the copy() function. Here's a exerpt from something i was doing a while back:

if(!$description OR !$adder OR $remotefile=="none"){
echo "Sorry, you missed a field on the form. All fields are required.";
}
else{
// Get the file extension. Only .rep files are allowed.
$filebits=explode(".", $remotefile_name);
if($filebits[1]=="rep"){
// Generate a unique filename...
$localfile="C:\inetpub\wwwroot\newsc\replays\$REMOTE_HOST".time().".rep";

  //Upload the file
  copy($remotefile, $localfile); 

  // cut off the path info to make a relative file path
  $localfile=str_replace("C:\\inetpub\\wwwroot\\newsc\\replays\\","",$localfile); 

  // Store the path to the file in the DB
  $sql="INSERT INTO tgsc_replays VALUES ('', '$adder',".time().",'$description','$localfile','')";
  mysql_query($sql); 

  // Display success/error message
  if(mysql_affected_rows($LINK_ID)) 
    echo "Thanks, your replay was added!"; 
  else 
    echo "Sorry, there was an error, please try again later.";
}
// tell them to get lost if the extension is wrong.
else message("Invalid file type!<br>The file must be a Starcraft game replay file.");

}
}

hope this helps.

[Anon]

Looks like the php .RPMs from Redhat 7.0 are busted for image uploads somehow. I recompiled 4.04pl1 by hand, and it works now!