PHP with PDO returning BLOB records with foreach

Question

Good afternoon guys, I’m new here (first question), but Stack has already helped me in several situations.

That’s the problem:

I am developing an application and on a given page there is a user profile page. On this page, a div that displays photos of users belonging to the same industry as the logged in user.

Query:

$query3 = "SELECT USR.EMAIL, USR.IMG_PERFIL, IMG.IMAGEM FROM IN_USUARIOS USR, IN_IMAGENS IMG WHERE USR.IMG_PERFIL = IMG.ID AND USR.SETOR =:setor AND USR.ID !=:id";

Running:

$stmt3 = $conn->prepare($query3);
$stmt3->bindValue(':setor',$result1['SETOR']);
$stmt3->bindValue(':id',$result1['ID']);
$stmt3->execute();
$result3=$stmt3->fetchAll(PDO::FETCH_ASSOC);

*$result1 = Returns all user data

Listing:

 <ul class="friends">
  <?php
   foreach($result3 as $key => $value ) 
    { 
      echo
        '<li>
          <div class="profile-pic">
            <img width="35" height="35" title="'. $value['EMAIL'] .'" src="data:image/jpeg;base64,'.base64_encode(stream_get_contents($value['IMAGEM'])).'">
          </div>
         </li>';
    }
  ?

The code presents the images, but always the same, in case the image of the last colleague in the data array: (should come the image corresponding to each of the logged user’s colleagues.

• notice that a title will be in the image according to the email of the colleague, this is working, bringing the emails of each of the colleagues.

var_dump($result3):

    array(4) {
  [0]=>
  array(3) {
    ["EMAIL"]=>
    string(30) "[email protected]"
    ["IMG_PERFIL"]=>
    string(1) "4"
    ["IMAGEM"]=>
    resource(3) of type (stream)
  }
  [1]=>
  array(3) {
    ["EMAIL"]=>
    string(29) "[email protected]"
    ["IMG_PERFIL"]=>
    string(1) "6"
    ["IMAGEM"]=>
    resource(4) of type (stream)
  }
  [2]=>
  array(3) {
    ["EMAIL"]=>
    string(26) "[email protected]"
    ["IMG_PERFIL"]=>
    string(1) "7"
    ["IMAGEM"]=>
    resource(5) of type (stream)
  }
  [3]=>
  array(3) {
    ["EMAIL"]=>
    string(26) "[email protected]"
    ["IMG_PERFIL"]=>
    string(1) "5"
    ["IMAGEM"]=>
    resource(6) of type (stream)
  }

}

• Viewing code from page:

I must be forgetting some detail in this my foreach. I count on your help.

Thank you.