无法从数据库加载图像

Question

I'm trying to load images stored in a database, but is not working. I only can see the links but, no images. I'm using longblob in the field where the pictures are stored.

JavaScript:

  <script>

    $(document).ready(function(){
         $.ajax({type: "POST",
                 url: "cargaImg.php",
                 success:function(data) {
                    $('#pinta').html(data);
                    }

         });  
    });
  </script> 

PHP

(images.php)

 <? require('conecta.php');
   $stmt=$oConni->prepare("SELECT PIC FROM FOTOS WHERE ID_PIC=?");
   $stmt->bind_param('i',$_GET['id']);
   $stmt->execute();
   $stmt->store_result();
   $stmt->bind_result($Foto);
   while ($stmt->fetch()) {
     header('Content-Type: image/jpeg');
     print $Foto;
   }
 ?>

(cargaImg.php)

    <?php
        require('conecta.php');
        ini_set('display_errors',1); error_reporting(E_ALL);  

        $cSQL="SELECT ID_PIC, PIC, NOMBRE FROM FOTOS";

        $stmt=$oConni->prepare($cSQL) or die($oConni->error);
        //$stmt->bind_param('i',$_POST['local']);
        $stmt->execute();                               
        $stmt->bind_result($id, $pic, $nombre);
        //$i=0;
        echo '<table cellspacing="0">';
        while ($stmt->fetch()) {

            if (!empty($pic)){ ?>
            <tr><td><img class="sifoto" src="images.php?id=<?=$id?>" width="60" height="60"  /></td></tr>
            <?}
            echo'<tr><td value="'.$id.'"><a target="_blank" href="'.$nombre.'">Enlace</a></td></tr>'; 
            //$i++;
        }   
        $stmt->close();
        echo'</table>';

     ?>

Answer 1

SOLVED: i need this: $stmt->store_result();

    <?php
        require('conecta.php');
        ini_set('display_errors',1); error_reporting(E_ALL);  
        $cSQL="SELECT ID_PIC, PIC, NOMBRE FROM FOTOS";
        $stmt=$oConni->prepare($cSQL) or die($oConni->error);
        //$stmt->bind_param('i',$_POST['local']);
        $stmt->execute(); 
        $stmt->store_result();
        $stmt->bind_result($id, $pic, $nombre);
        //$i=0;
        echo '<table cellspacing="0">';
        while ($stmt->fetch()) {

            if (!empty($pic)){ 
            echo'<tr><td><img class="sifoto" src="images.php? id='.$id.'" width="100" height="100"  /></td></tr>';
            }
            echo'<tr><td value="'.$id.'"><a target="_blank" href="'.$nombre.'">Enlace</a></td></tr>'; 
            //$i++;
        }   
        $stmt->close();
        echo'</table>';

?>