Image not display using PHP and MySQL

Question

Below is my code for display information of an image including its file, but this is not displaying, I don't know why.

 <?php
      include('config/dbconnect.php');  
      if(isset($_GET['id'])) 
      { 
            $id = $_GET['id'];
            $sql = mysqli_query($con, "SELECT * FROM collage WHERE id = '$id'");
            while($row = mysqli_fetch_array($sql)) {
                  $name = $row['name'];
                  $content = $row['content'];
                  $size = $row['size'];
                  $type = $row['type'];
                  $date_upload = $row['date_upload'];
                  $file = $row['file'];
            }
      }
?>
<div class='body-content'>
<div class='img-name-cont'><h3><?php echo $name; ?></h3></div>
<div class='img-detail-cont'>upload: <?php echo $date_upload; ?><br>type: <?php echo $type; ?><br>size: <?php echo $size; ?>KB </div>
<div class='img-file-cont'>
<img src="img/collage/<?php echo $row['file'] ?>" style="width:130px; height:100%"></div>
<div class='img-content-cont'><?php echo $content; ?></div>
</div>

do you get any error code in code inspector?? PS: your code can be injected by sql injection — Jacky Shek
– Jacky Shek, Commented Jul 8, 2016 at 4:07
After <?php add error_reporting(E_ALL);ini_set('display_errors',1); And write $sql = mysqli_query($con, "SELECT * FROM collage WHERE id = '$id'") or die (mysqli_error($con)); and check for errors — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jul 8, 2016 at 4:20

Vipin Mohan · Accepted Answer · 2016-07-08 05:23:31Z

2

First of all use inspect to check whether the image is actually pointed to by the code. that is the actual loation might not be pointed at. what is your folder structure.

" style="width:130px; height:100%">

your code is ok. as long as php echo $row['file'] returns a file

answered Jul 8, 2016 at 5:23

Vipin Mohan

1,6311 gold badge15 silver badges23 bronze badges

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

Comments

dulaj sanjaya · Accepted Answer · 2016-07-08 05:04:56Z

The problem here is "Your all the variables are local to the while loop". so you can't access it outside of the while loop. Try this code.

 <?php
      include('config/dbconnect.php');  
      if(isset($_GET['id'])) 
      { 
            $id = $_GET['id'];
            $sql = mysqli_query($con, "SELECT * FROM collage WHERE id = '$id'");
            while($row = mysqli_fetch_array($sql)) {
        ?> 

                  <div class='body-content'>
                  <div class='img-name-cont'><h3><?php echo $row['name']; ?></h3></div>
                  <div class='img-detail-cont'>upload: <?php echo $row['date_upload']; ?><br>type: 
                  <?php echo $row['type']; ?><br>size: <?php echo $row['size']; ?>KB </div>
                  <div class='img-file-cont'>
                  <img src="img/collage/<?php echo $row['file']; ?>" style="width:130px; height:100%"></div>
                  <div class='img-content-cont'><?php echo $row['content']; ?></div>
                  </div>
        <?php
            }
      }
?>

graceth · Accepted Answer · 2016-07-08 05:44:02Z

0

Be sure to check echo $row['file'] if it returns the correct string of your image path with the correct file extension .

answered Jul 8, 2016 at 5:44

graceth

1788 bronze badges

Comments

Ashish4434 · Accepted Answer · 2016-07-08 06:16:49Z

0

try this one :
first of all you have to check if your image path ok or not using this php function:


 <?php
     $img=getimagesize($imagewithpath);
      if($img=="") 
      { echo "there is no image ";} 
 else{  ?> <img src="<?php echo $imagewithpath; ?>" style="width:130px; height:100%">  <?php  } ?>

answered Jul 8, 2016 at 6:16

Ashish4434

1186 bronze badges

Comments

halfer · Accepted Answer · 2020-03-17 00:32:08Z

0

As answered by Dulaj Sanjaya all your variables are local so you can't use that outside of while.

Second if you want to use your code then you have taken all data of $row in different variables then used outside of file then why don't you used same $file for image why you have used $row['file']?

Simply replace this line as

<div class='img-file-cont'>
                  <img src="img/collage/<?php echo $file; ?>" style="width:130px; height:100%"></div>

edited Mar 17, 2020 at 0:32

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Jul 8, 2016 at 5:21

Passionate Coder

7,3042 gold badges24 silver badges50 bronze badges

Collectives™ on Stack Overflow

Image not display using PHP and MySQL

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related