Solved

display images in php

Posted on 2013-01-01
3
282 Views
Last Modified: 2013-01-16
facing problem in displaying the images that are stored in databases the following code is to display the images

<?php

$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db('upload', $link);

if (!$db_selected) {
    die ('Database error : ' . mysql_error());
}

        $sql = "SELECT * FROM images";
 
       
        header("Content-type: image/jpeg");
        echo mysql_result($result, 0,'imageData');
 
     
?>
the following code is to upload the images in the database
<?php

$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db('upload', $link);
if (!$db_selected) {
    die ('Database error : ' . mysql_error());
}

$maxFileSize = "1000000";

$image_array            = array("image/jpeg","image/jpg","image/gif","image/bmp","image/pjpeg","image/png");

$fileType = $_FILES['userfile']['type'];

 
$msg = '';


if(@$_POST['Submit'])
{


if (in_array($fileType, $image_array))
{


 if(is_uploaded_file($_FILES['userfile']['tmp_name']))
 {
 
 
        if($_FILES['userfile']['size'] < $maxFileSize)
            {
 

                  $imageData =addslashes (file_get_contents($_FILES['userfile']['tmp_name']));
 
        $sql = "INSERT INTO images ( imageData) VALUES ('$imageData')";
 
             
        mysql_query($sql) or die(mysql_error());
            $msg = " Data successfully uploaded";
         }
     else
       {
     
           $msg = ' Error :  File size exceeds the maximum limit ';
             
           }
   }
}
else
{
$msg = 'Error: Not a valid image ';
}

}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html>
     <body>
       <span style="color:#FF0000"><?php echo $msg; ?></span><br />

        <h3>Select File to upload</h3>
 
        <form enctype="multipart/form-data" action="" method="post">
             <input name="userfile" type="file" />
            <input type="submit" value="Submit"  name="Submit"/>
        </form>
    </body>
</html>
i am able to upload the images here in the database but i am unable to display all the images that are stored in the database.help me out experts
0
Comment
Question by:codeoxygen
  • 2
3 Comments
 
LVL 27

Expert Comment

by:Lukasz Chmielewski
ID: 38735888
Try to display it like this:

$db_selected = mysql_select_db('upload', $link);

if (!$db_selected) {
    die ('Database error : ' . mysql_error());
}

        $sql = "SELECT * FROM images";
        $result = mysql_query($sql);
        $row = mysql_fetch_array($result);
        
        header("Content-type: image/jpeg");
        echo $row['imageData'];
 
     
?>

Open in new window

0
 
LVL 27

Expert Comment

by:Lukasz Chmielewski
ID: 38735896
BUT I would definetely recommend to store the images as files having a link in the database to the path where they are. The database can rapidly grow to big size. If that is just for learning purposes, the code provided should be ok.
0
 
LVL 9

Accepted Solution

by:
rinfo earned 500 total points
ID: 38735970
You have mentioned
$sql = "INSERT INTO images ( imageData) VALUES ('$imageData')";
besides you have also mentioned
  $sql = "SELECT * FROM images";
which indicates you have just one field imageData in the images table - of course there could be an id field.
Does it also mean you have only one image in the images tables.
Because you have mentioned
   $sql = "SELECT * FROM images";
        header("Content-type: image/jpeg");
        echo mysql_result($result, 0,'imageData');
if there are multiple rows in the table you have to iterate through the result array to
display images one by one.
I think this is where you are failing.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Who says nothing in life is free? WordPress.com is a freebie. WordPress.org's downloadable publishing platform is free. Heck, even WordPressMU is free. WordPress is an open source project, which means it can be used on any personal or commerc…
How to create your own WordPress Theme Before I begin with the theme design tutorial, I would like to give you the basics of what is required to make a WordPress Theme. The most basic WordPress theme only requires 2 files: a style.css file and an…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now