从数据库显示图像

Question

Table User

image(blob type)  
------------------------------
0xFFD8FFE0     

myController

function displayImage($id)
{

        $this->autoRender = false;


        $peoples=TableRegistry::get('peoples');      
        $peoples=$peoples->getRecord([ 'image'])->first();   

        header('Content-Type: image/jpeg');

         echo $peoples['image']; 
}

Model

function getRecord($fields)
{
    return $this->find('all')->select($fields);
}

But when I set this:

<img id="imgPreview" src="displayImage/30">

the image does not show anything. When I use myController/displayImage/30 this shows Resource id #170 to me!

Why is this? How can I display the image?

Answer 1

You're trying to fetch an image from a user ID?

If that is the case

$peoples = TableRegistry::get('Peoples');
$peoples->find('all');
$peoples->matching('Users', function($q) use($id) {
   return $q->where(['Users.id' => $id]);
});

$result = $peoples->first();
$result->users[0]->image;