DaniWeb Forum Index > Web Development > PHP

displaying uploaded image

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 24

Reputation: chitra1 is an unknown quantity at this point

Solved Threads: 1

chitra1

Offline

Newbie Poster

displaying uploaded image

Jun 1st, 2008

Hi,

I am uploading images in a form. But it only sends the images in a folder 'upload' and send only the file name to the database. How do I send the image to the database and retrieve it for display.

•

Join Date: Jan 2008

Posts: 74

Reputation: Vai is an unknown quantity at this point

Solved Threads: 5

Vai

Offline

Junior Poster in Training

Re: displaying uploaded image

Jun 1st, 2008

you are doing fine. Don't store the actual image in your database. To display you can do something like this:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
    // just so we know it is broken
    error_reporting(E_ALL);
    // some basic sanity checks
    if(isset($_GET['image_id']) && is_numeric($_GET['image_id'])) {
        //connect to the db
        $link = mysql_connect("localhost", "username", "password") or die("Could not connect: " . mysql_error());
 
        // select our database
        mysql_select_db("database_name") or die(mysql_error());
 
        // get the image from the db
        $sql = "SELECT image FROM TABLE WHERE image_id=0";
 
        // the result of the query
        $result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
 
        // set the header for the image
        header("Content-type: image/jpeg");
        echo mysql_result($result, 0);
 
        // close the db link
        mysql_close($link);
    }
    else {
        echo 'Please use a real id number';
    }
?>
<?php
    // just so we know it is broken
    error_reporting(E_ALL);
    // some basic sanity checks
    if(isset($_GET['image_id']) && is_numeric($_GET['image_id'])) {
        //connect to the db
        $link = mysql_connect("localhost", "username", "password") or die("Could not connect: " . mysql_error());
 
        // select our database
        mysql_select_db("database_name") or die(mysql_error());
 
        // get the image from the db
        $sql = "SELECT image FROM TABLE WHERE image_id=0";
 
        // the result of the query
        $result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
 
        // set the header for the image
        header("Content-type: image/jpeg");
        echo mysql_result($result, 0);
 
        // close the db link
        mysql_close($link);
    }
    else {
        echo 'Please use a real id number';
    }
?>

•

Join Date: Jul 2006

Posts: 4

Reputation: iFuseDan is an unknown quantity at this point

Solved Threads: 1

iFuseDan

Offline

Newbie Poster

Re: displaying uploaded image

Jun 2nd, 2008

Only think I will point out,

Is that the uploaded image when stored would have to be converted to jpeg for that to exclusively work. When working with files you have the option of giving the uploaded images specific filenames and then rendering them through the use of functions such as imagecreatefromjpeg and imagejpeg. What you might want to do instead of using files and expanding on the database idea, would be to store the mime-type, rather then returning each image as an apparent jpeg.