## Heres where I add images to DB with field type of BLOB for image

if ( ($submit == 'Add Image') && ($userid != 'demo') ){
   if ($image != 'none'){
      $name = strtr($name, "'", " ");
      $image = addslashes(fread(fopen($image, "r"), filesize($image)));
      mysql_select_db($dbase) or die( "Unable to select database");
      $query = "insert into images values ('$name','$image')";
      if (mysql_error()){
         echo ("<BR><BR><BR><center> Upload of image failed. It is possible
         echo (" image name is already on file. Try another name.</CENTER>");
         echo ("</BODY></HTML>");
   $submit = 'Image Index';

Here's my image script. I know I should send more information in the Header, but
it works w/out it. Notice that I ommitted the stripslashes. I ran into the same
problem as you are having when I had the stripslashes in it. I would make more
sense to me if you had to use the stripslashes.

mysql_select_db($dbase) or die("Unable to select DB ".$report_to);
$query = "select image from images ";
$query .= "where (image_name = '$name') ";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

Header( "Content-type: image");
echo $image;

Your code.
$query = "SELECT filename, filedata, dateline FROM reviews where id=$id";
$results = dbQuery($query);

$filedata = stripslashes($results["rowData"]["FILEDATA"][0]);
$filename = $results["rowData"]["FILENAME"][0];

if (strstr($HTTP_USER_AGENT,"MSIE")) {
  $attachment = '';
} else {
  $attachment = ' atachment;';

header("Cache-control: max-age=31536000");
header("Expires: " . gmdate("D, d M Y H:i:s",time()+31536000) . "GMT");
header("Last-Modified: " . gmdate("D, d M Y
H:i:s",$results["rowData"]["DATELINE"][0]) . "GMT");
header("Content-disposition:$attachment filename=$filename");
header("Content-Length: ".strlen($filedata));

if ($extension=="gif") {
  header("Content-type: image/gif");
} elseif ($extension=="jpg" or $extension=="jpeg") {
  header("Content-type: image/pjpeg");
} elseif ($extension=="png") {
  header("Content-type: image/png");
} elseif ($extension=="pdf") {
 header("Content-type: application/pdf");
} else {
  header("Content-type: unknown/unknown");
echo $filedata;

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to