Image display from Mysql issue

[gnrmatt]

Hi,

 

I am having an issue with displaying an image that is uploaded in a mysql database.

 

The table format is

 

-----------------------------------------------------------

|  id  |  name  |    mime    |  size  |  data  |

-----------------------------------------------------------

|    1  |  test  | image/jpeg| 74857 |  BLOB  |

 

 

The data has uploaded fine. I then have the following script on my 'displayimage.php?imgid=1' page...

 

$id = $_GET['imgid'];
$result = mysql_query("SELECT * FROM images WHERE id = '$id'");
while($row = mysql_fetch_array($result))
$size = $row['size'];
$mime = $row['mime'];
$name = $row['name'];
{
header("Content-length: $size");
header("Content-type: $mime");
header("Content-Disposition: attachment; filename=$name");
echo $row['data'];

 

However everytime i try to open this page, Firefox or Internet Explorer just ask's me to try and download the file as a php file. Any ideas what is going wrong?

 

Thanks!

 

Matt

[fugix]

im assuming you have a server that this script is on?

[gnrmatt]

Yes - Connection above:

 

if(isset($_GET['imgid']))
// if id is set then get the file with the id from database

$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);

 

I tried removing the content-disposition header on guidance from a different thread but that also didnt work.

[fugix]

im talking about a web server not a mysql server

[gnrmatt]

Not to worry - Error has been resolved.

 

For reference, I shouldn't have used

while($row = mysql_fetch_array($result))

and instead used

$row = mysql_fetch_assoc($result); 

 

Works a treat now.

[fugix]

okay, i was asking that because if you dont have your php file in a web server directory, it triggers an error like that. glad your resolved the issue