0

I have inserted image into database and store name in the table. my image is saved in a folder named 'Uploads'. Now need to retrieve image from the databse and display it. when I try to display It only shows the image name which is taken from my table.but it does not show the image.

retrieving code is given below

$sql="SELECT * FROM candi_profile WHERE can_email='{$_SESSION['usr_email']}'";

$result=mysqli_query($con,$sql);
if(!$result) die(mysqli_error($con));
  <div class="container">

        <!-- Page Header -->
        <div class="row">
            <div class="col-lg-12">
                <h1 class="page-header">Employer Dashboard 
                   
                </h1>
            </div>
        </div>
        <!-- /.row -->

        <!-- Projects Row -->
        
        <div class="row">
            <div class="col-md-4">
        <?php
          while($rows=mysqli_fetch_array($result)){
              $c_id = $rows['can_id'];
            var_dump($c_id);
             ?>
             
            <p class="lead"><?php echo $rows['can_name'] ?></p>
            <div class="profile-sidebar">
                <!-- SIDEBAR USERPIC -->
                
                <div class="profile-userpic">
                        <p class="lead">
                         <?php echo $rows['pic_name'] ?></p>
                </div>
                
                <!-- END SIDEBAR USERPIC -->

                <!-- SIDEBAR USER TITLE -->
                <div class="profile-usertitle">
                    <div class="profile-usertitle-name">
                        Marcus Doe
                    </div>
                    <div class="profile-usertitle-job">
                       <?php echo $rows['can_city'] ?>
                   <i class="glyphicon glyphicon-map-marker">
                        </i>
                    </div>
                        
                    <div class="profile-usertitle-job">
                         <i class="glyphicon glyphicon-envelope"></i>
                      <?php echo $rows['can_email'] ?>
                    </div>
                        
                    <div class="profile-usertitle-job">
                        <?php echo $rows['can_country'] ?>
                    </div>
                </div>
                <!-- END SIDEBAR USER TITLE -->
                
                <!-- SIDEBAR BUTTONS -->
                <div class="profile-userbuttons">
                    <hr>
                </div>
                
                <!-- END SIDEBAR BUTTONS -->
                <!-- SIDEBAR MENU -->
      
            <?php
            }
            ?>          
            </div>

enter image description here enter image description here

Community
  • 1
  • 1
Deepashika
  • 87
  • 1
  • 2
  • 9
  • 1
    Add your full path where you store image.Like `http://localhost/test/images/test1.php` – Nikhil Vaghela Jul 25 '16 at 06:10
  • you have to store only paht of the images in database not an image. – Devsi Odedra Jul 25 '16 at 06:11
  • this sort of question has been asked thousands of times before – e4c5 Jul 25 '16 at 06:12
  • 1
    Possible duplicate of [How to retrieve images from MySQL database and display in an html tag](http://stackoverflow.com/questions/7793009/how-to-retrieve-images-from-mysql-database-and-display-in-an-html-tag) – Idan Jul 25 '16 at 06:23

5 Answers5

2

I assume that the content of $rows['pic_name'] is string only as said on your question.

Put an image attribute and call the path of the image with the corresponding filename save on the database. 

<img src = "<path>/<?php echo $rows['pic_name'] ?>" />

NOTE:

Make sure the image is existing on your desire path.

Edmar
  • 21
  • 5
2

you can use this code to retrieve image from database

<?php
include 'connection.php'
?>
<?php

$result = mysql_query("SELECT * FROM table") or die(mysql_error()); 


?>

<table border="1" cellpadding="5" cellspacing="5">
<tr> <th>Image</th></tr>

<?php

while($row = mysql_fetch_array($result)) {

$id = $row['id'];

?>
    <tr>

        <td><img src="uploads/<?php echo $row['pic_name'];?>" alt=" " height="75" width="75"></td>

   </tr>

<?php   
} 
}

?>
</table>
Vamsi Abbineni
  • 479
  • 3
  • 7
  • 23
1

Use image tag to display the image and give it path to the image folder

<img src="your path/<?php echo $rows['pic_name'] ?>" />
Owais Aslam
  • 1,577
  • 1
  • 17
  • 39
0

friend instead of making images folder you should make a new image column(i.e "imageColumn ") type as blob then You need to create another php script to return the image data, e.g. getImage.php.

home.php(or display image page) code

<body>
<img src="getImage.php?id=1" width="175" height="200" />
</body>

Then getImage.php is

<?php

  $id = $_GET['id'];
  // do some validation here to ensure id is safe

  $link = mysql_connect("localhost", "root", "");
  mysql_select_db("dvddb");
  $sql = "SELECT imageColumn FROM Tablename WHERE id=$id";
  $result = mysql_query("$sql");
  $row = mysql_fetch_assoc($result);
  mysql_close($link);

  header("Content-type: image/jpeg");
  echo $row['imageColumn '];
?>
Hassan Saeed
  • 6,326
  • 1
  • 39
  • 37
0
  1. First fetch image from database using query
  2. The imagejpeg() function is an inbuilt function in PHP which is used to display image to browser or file.
  3. Get data using function ob_get_contents();
  4. Display image in page with height and width
$id = $_GET['id'];    
$sql = "select image from table where id='".$id."'";    
$res = mysqli_query($sql);    
$row = mysqli_fetch_assoc($res);    

$image = $row['image'];    
ob_start();    
imagejpeg($image, null, 50);        
$data = ob_get_contents();    
ob_end_clean();    
echo "<img src='data:image/jpg;base64,'".base64_encode($data)."' style='border:1px 
black; border-radius:10px; width:100px; height:125px;'>";
Sreejith N
  • 25
  • 5