MySQL Blobs - That old chestnut

NickH

An old chestnut I know but I am attempting to display images from a database blob field. The code works on Unix based hosting but does not on Win2K. I can confirm that the image is uploaded to the MySQL database since I have a commercial MySQL manager with a Blob viewer. This has an image option that displays the image as it should be. When attempting to view the image from the database with a php routine however, the dreaded X appears. Does anyone have any ideas. Viewing script is as follows.

<?php
// database connection
include "connect.php";
if (!$db)
{
echo 'Could not establish a database connection !!<br><br>';
exit;
};

mysql_select_db('db1');

$sql = "SELECT * FROM rbt100 WHERE image_id=".$_GET["iid"];
$result = mysql_query ($sql);
if (mysql_num_rows ($result)>0) {
$row = @mysql_fetch_array ($result);
$image_type = $row["image_type"];
$image = $row["image"];

Header ("Content-type: $image_type");
print $image;
}
?>

AstroTeg

I don't know the solution for you. But your problem is a great reason for storing images in the file system and NOT in the database.

Here, if you saved them in the file system, you would have had to just update your code to point or use the new file system's directory structure and naming conventions (if done right, this would have been one change in a config file). Then in the database, you just store the image file name (I'd recommend keeping as much path info out of the database in cases like yours).

xxdrossxx

The problem lies in the image code that you inserted into the database. These are a few prepping functions that you should use before inserting file-code into a MySQL database:

<?
//'$data' being the image code
$data = addslashes($data);
$data = addcslashes($data, '\0');
?>

Try inserting the image into the database after using those functions, and THEN try grabbing it out using the code that you've supplied. It should work fine.

EDIT: that character within quotes in the second expression seems to be showing up as a unix break character (the square thing). It's meant to be \0 within quotes.