displaying uploaded image

Expand Post »

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.

Similar Threads

Generate Thumbnail images on the fly. in PHP
displaying image from database in PHP
displaying images in PHP
displaying images in MySQL
Displaying images from mysql database in PHP

chitra1

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

24 posts
since Dec 2007

Permalink

Jun 1st, 2008

Re: displaying uploaded image

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

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';
    }
?>

Vai

Reputation Points: 12

Solved Threads: 5

Junior Poster in Training

Offline

74 posts
since Jan 2008

Permalink

Jun 2nd, 2008

Re: displaying uploaded image

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.

iFuseDan

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

4 posts
since Jul 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Should I echo out password value in the password field?

Next Thread in PHP Forum Timeline: for loop inside if statement

DaniWeb Message

Cancel Changes

User Name
Password