how to display images stored in a mysql database using PHP

Question

I have been trying to display image from database using php but i am only getting download prompt whenever i use or click the link. what i want to do is, i want to display it on the web browser. And want to use it in tags.

my code is:

require_once('dbconfig.php');
        $cont=mysql_connect($dbhost,$dbuser,$dbpass) or die("Error Connecting the Database");
        $seldatabase=mysql_select_db($dbselect,$cont);
        $insert = "SELECT `p_mime`, `p_name`, `p_size`, `p_data` FROM $dbtbl_reg_details WHERE `id` = $id";
        $query = mysql_query($insert);
        if ($query)
        {
            if (mysql_num_rows($query)==1)
            {
                $row = mysql_fetch_assoc($query);
                header("Content-Type: image/png");
                header("Content-Length: ". $row['p_size']);
                header("Content-Disposition: inline; filename=". $row['p_name']);
                echo $row[p_data];
            }
        else
        {
            echo "image with id = ".$id." does not exist";
        }
    }
    else
    {
        echo "query failed, image with id = ".$id." does not exist";
    }

And when i use inline for Content-Disposition: then my web page returns a script error on the browser.

So, what should i do to display images on web pages while retrieving it from mysql database

why do you want to store images in database?

Your Common Sense
– Your Common Sense

2010-08-16 08:12:57 +00:00
Commented Aug 16, 2010 at 8:12 — Your Common Sense
– Your Common Sense, Commented Aug 16, 2010 at 8:12
Related: stackoverflow.com/questions/3748/…

Pekka
– Pekka

2010-08-16 08:31:38 +00:00
Commented Aug 16, 2010 at 8:31 — Pekka
– Pekka, Commented Aug 16, 2010 at 8:31

ovais.tariq · Accepted Answer · 2010-08-16 11:11:06Z

1

if (mysql_num_rows($query)==1)
{
    while( @ob_end_clean() );

    header("Content-type:  image/png");
    header("Content-Length: ". $row['p_size']);
    header("Content-Disposition: attachment; filename=\"{$row['p_name']}\"");

    die($row[p_data]);
}

edited Aug 16, 2010 at 11:11

answered Aug 16, 2010 at 9:41

ovais.tariq

2,62517 silver badges12 bronze badges

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

1 Comment

Shiv Deepak Over a year ago

hi! this "' . $row['p_name'] . '"' is returning me a syntax error

Haim Evgi · Accepted Answer · 2010-08-16 08:12:22Z

0

why u have echo hi; ?

its probably cause an error

and also add exit in the end (to sure you dont echo anything after)

echo $row[p_data];
exit;

answered Aug 16, 2010 at 8:12

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

1 Comment

Shiv Deepak Over a year ago

hi i have removed that echo hi and made Content-Disposition: to inline.. now getting an error "The image “127.0.0.1/isc2011/photo.php?id=2” cannot be displayed, because it contains errors." I have uploaded the file properly, what could be the reason!?

Collectives™ on Stack Overflow

how to display images stored in a mysql database using PHP

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related