Reading an Image file from a mysql database using php

Question

I am trying to display an image, but my webpage displays encoding stuff instead. Below is my code:

<?php ob_start();?>

// html markups goes here

<?php include 'login.php';
if(isset($_GET['productid'])){
    $productid = $_GET['productid'];

    $sql = "select tyre_image from tyres where product_id = '$productid'";
    $result = mysql_query($sql) or die(mysql_error());
    header("Content-type :image/jpg");
    echo mysql_result($result,0);

}

ob_end_flush();

?>

I am using $_GET associative array($_GET['variable']) to get the product ID via a link on another page.

How would I fix this?

why do you save the images into the DB instead of the path?

jcho360
– jcho360

2013-05-09 14:48:44 +00:00
Commented May 9, 2013 at 14:48 — jcho360
– jcho360, Commented May 9, 2013 at 14:48

Community · Accepted Answer · 2021-10-07 05:59:28Z

3

I had no idea the Content-type header was this picky, but change the spacing around the colon (and also image/jpg should be image/jpeg):

header("Content-type: image/jpeg");

Per the answer below, I agree - this fix assumes that this script is just used for displaying an image in your HTML, ala <img src="path/to/your/image.php?productid=123" />.

Further light reading on the image/jpeg MIME type spec here.

edited Oct 7, 2021 at 5:59

CommunityBot

11 silver badge

answered May 9, 2013 at 14:36

jterry

6,2473 gold badges32 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Reading an Image file from a mysql database using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related