How to retrieve image from DB using PHP

Question

I'm using the following code retriever image from DB along with other attributes i.e Full Name, Mobile No. etc.But it is showing an empty image box.

require 'database.php';
$MobileNo = null;
if ( !empty($_GET['MobileNo'])) {
$MobileNo = $_REQUEST['MobileNo'];
}

if ( null==$MobileNo ) {
header("Location: index.php");
} else {
$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "SELECT * FROM user where MobileNo = ?";
$q = $pdo->prepare($sql);
$q->execute(array($MobileNo));
$data = $q->fetch(PDO::FETCH_ASSOC);
Database::disconnect();
}
?>
<div class="control-group">
<label class="control-label">Picture</label>
<div class="">
<label class="">
<?php

 $row = $data or die("line 44 not working");
 $s=$row['Picture'];
 echo $row['Picture'];

 echo '<img src="'.$s.'" alt="HTML5 Icon"style="width:128px;height:128px">';
 ?>

 </label>
 </div>
 </div>

Database::disconnect(); <<< guess what that does.

Funk Forty Niner
– Funk Forty Niner

2016-03-13 17:54:19 +00:00
Commented Mar 13, 2016 at 17:54 — Funk Forty Niner
– Funk Forty Niner, Commented Mar 13, 2016 at 17:54
Disconnects DB connection

Zaid
– Zaid

2016-03-13 18:01:35 +00:00
Commented Mar 13, 2016 at 18:01 — Zaid
– Zaid, Commented Mar 13, 2016 at 18:01
There you go ;-)

Funk Forty Niner
– Funk Forty Niner

2016-03-13 18:10:33 +00:00
Commented Mar 13, 2016 at 18:10 — Funk Forty Niner
– Funk Forty Niner, Commented Mar 13, 2016 at 18:10

user5831063 · Accepted Answer · 2016-03-13 18:08:36Z

1

You have disconnected the database before fetching $row = $data or die("line 44 not working");

You need to disconnect it after the variable is set.

if ( null==$MobileNo ) {
header("Location: index.php");
} else {
$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "SELECT * FROM user where MobileNo = ?";
$q = $pdo->prepare($sql);
$q->execute(array($MobileNo));
$data = $q->fetch(PDO::FETCH_ASSOC);


$row = $data or die("line 44 not working");
 $s=$row['Picture']; //This is where you make the change. 
 echo $row['Picture'];
Database::disconnect(); //Now disconnect
}
?>
<div class="control-group">
<label class="control-label">Picture</label>
<div class="">
<label class="">
<?php



 echo '<img src="'.$s.'" alt="HTML5 Icon"style="width:128px;height:128px">';
 ?>

 </label>
 </div>
 </div>

answered Mar 13, 2016 at 18:08

user5831063

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

2 Comments

user5831063 Over a year ago

Is there any error? Does the other elements of the page show up?

Zaid Over a year ago

All other elements are working fine..Only image box is empty.

Collectives™ on Stack Overflow

How to retrieve image from DB using PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related