php - Unable to display image

Question

I'm very new to development, and I'm trying to retrieve an image from an SQL server over an odbc connection using the below:

<?php

require ('connect.inc.php');



$sql = "SELECt image FROM test.dbo.clients WHERE id = 1";
$sql_exec = odbc_exec($con, $sql);

if($sql_array = odbc_fetch_array($sql_exec)){
    $image = base64_encode($sql_array['image']);
    header('Content-type: image/jpeg');
    echo "<img src=".$image."/>";
}


?>

The issue is that I'm getting an icon showing a broken image.
The query is correct as when I change it to the code below, it returns this string instead of the image:

Q2hyeXNhbnRoZW11bS5qcGc=

<?php
require ('connect.inc.php');   

$sql = "SELECt image FROM test.dbo.clients WHERE id = 1";
$sql_exec = odbc_exec($con, $sql);

if($sql_array = odbc_fetch_array($sql_exec)){
    $image = base64_encode($sql_array['image']);

    echo $image;
}
?>

I know the code is not correct and might be vulenrable to SQL injection, however I'd appreciate if you can help me retrieve the image.

Many thanks in advance, J

header('Content-type: image/jpeg'); echo $image; ? Your first example echoes out an HTML tag not an image (but with the correct header() for a jpg` the second example echoes out the image but without a header() so it'll default to text/html — CD001
– CD001, Commented Jun 12, 2015 at 14:54

Werner Henze · Accepted Answer · 2015-06-12 14:56:45Z

1

If you decode the base64 string you get, then you'll see that the decoded data is Chrysanthemum.jpg. This is just the filename of the image, not the image data.

You need to either store the image in the database (not the filename) or add some code to read the image from the filesystem.

BTW, Content-Type image/jpeg requires that the data is the raw image, but your content (<img src=...> ...</img>) is an HTML fragment.

answered Jun 12, 2015 at 14:56

Werner Henze

16.8k12 gold badges47 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CD001 Over a year ago

hahahah - should have noticed Q2hyeXNhbnRoZW11bS5qcGc= was a bit short for the full image data :)

Collectives™ on Stack Overflow

php - Unable to display image

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related