Fetch blob image from table and display it using php sqlite3

Question

I know this question has been asked many times but I couldnot solve this using any of them. I am new to sqlite and cannot understand what I am doing wrong.

WHAT I AM TRYING

I am trying to make a profile view page. I am able to fetch all details from my sqlite database but i am not able to display my profile picture.

TABLE STRUCTURE

    **username|landline|mobile|email|profilepicture**

         john |xxxxxxxx|xxxxxx|[email protected]|blob

WHAT I TRIED

  $sql = "SELECT * FROM profile";
  $query = $db->query($sql);
  while($row = $query->fetchArray(SQLITE3_ASSOC) ){
  echo "NAME = ". $row['user_name'] . "<br/>";
  echo "LANDLINE = ". $row['user_landline'] ."<br/>";
  echo "MOBILE = ". $row['user_mobile'] ."<br/>";
  echo "EMAIL =  ".$row['user_email'] ."<br/>";
  header('Content-Type: image/png');
  echo $row['user_profile_picture'];
  }


  <html>
  <img src='profile.php?imgid=<?php echo $row['user_profile_picture'];?>'/>
  </html>

But the image dosenot show and also the rest of the data dosenot display when i putheader('Content-Type: image/png');

HarryFink · Accepted Answer · 2013-06-06 06:29:06Z

2

Create an image.php:

<?php 
$sql = "SELECT user_profile_picture FROM profile WHERE id = " . $_GET['id'];
$query = $db->query($sql);
$row = $query->fetchArray(SQLITE3_ASSOC);

header('Content-Type: image/png');
echo $row['user_profile_picture'];

In profile.php:

<img src='image.php?id=<?php echo $row['id'];?>'/>

answered Jun 6, 2013 at 6:29

HarryFink

1,0001 gold badge6 silver badges6 bronze badges

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

4 Comments

Avinash Over a year ago

<img src='image.php?id=<?php echo $row['id'];?>'/> what does this mean. mainly what is id

HarryFink Over a year ago

I assume you have an id column (a primary key) in your table.

ADH - THE TECHIE GUY Over a year ago

is this only support if image is png?

HarryFink Over a year ago

Nope, you can also store the image type in the db during upload.

Collectives™ on Stack Overflow

Fetch blob image from table and display it using php sqlite3

WHAT I AM TRYING

TABLE STRUCTURE

WHAT I TRIED

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

WHAT I AM TRYING

TABLE STRUCTURE

WHAT I TRIED

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related