Displaying BLOB image from database yii 2

Question

Hello I am using a table for the blob images that contains the images and a client column to reference it the question is how can I display an image blob based on the clientid so that I can show it in the webpage using yii 2?

Here is a screenshot of the table.

Because in this particular article I got the impression it is only uploading the image as BLOB. Yii2 Display image stored in BLOB database field

But how do I make it so that I would only returning/displaying the blob from the database?

EDIT 1

I converted the answer into yii code.

Controller

public function DisplayBlob($clientid){
      $model = new Slimages();

      return $model->DisplayBlob($clientid);

    }

Here is the model.php

 public static function DisplayBlob($clientid){
    return static::find()->where(['clientid' => $clientid])->asArray()->all();
 //     $db = $db = mysqli_connect("localhost","root","","myenrollment"); //keep your database name
 //     $sql = "SELECT * FROM slimages WHERE clientid = $clientid"; // pass your clientid here
    // $statement = $db->query($sql);
    // $result = mysqli_fetch_array($statement);
    // return $result;
    //echo '<img src="data:image/jpeg;base64,'.base64_encode($result['Picture'] ).'"/>';
  }

View file

 <td colspan="2"><?php 
            $result = SiteController::DisplayBlob($_user);
            foreach($result as $image){
             // echo  'hello';
                echo '<img src="data:image/jpeg;base64,'.base64_encode($image['Picture'] ).'" height="100" width="100"/>';
            }


            ?></td>

Mahamadali · Accepted Answer · 2016-08-25 08:21:55Z

1

$db = mysqli_connect("localhost","root","","database"); //keep your database name
$sql = "SELECT * FROM table_name WHERE clientid = $id"; // pass your clientid here
$statement = $db->query($sql);
$result = mysqli_fetch_array($statement);
echo '<img src="data:image/jpeg;base64,'.base64_encode($result['Picture'] ).'"/>';

Note : Please change the db details , table and column names as per your requirement.

i hope this will help you. Feel free to comment.

answered Aug 25, 2016 at 8:21

Mahamadali

3294 silver badges11 bronze badges

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

1 Comment

user3606724 Over a year ago

I got it working on my webpage, but I am just wondering if there's any way of doing this in yii code?

Collectives™ on Stack Overflow

Displaying BLOB image from database yii 2

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related