Uploading an Image and Saving it to a Database in Yii

Uploading an Image and Saving it to a Database in Yii

Last updated:

DISCLAIMER: Most of the time it is not recommended to store images on a database. This tutorial/guide is meant to explain how to do it in the few cases where it is ok to store images in a database.

Assuming you have a table in a database with an attribute called "logo" which is of type "BLOB" and you're using the ActiveRecord model as a FormModel, here's how you should proceed:

In your AR Model:

  • add this line to the rules() method
 <?php
 ['logo', 'file', 'types' => 'jpg,jpeg,png,gif', 'allowEmpty' => true]

  • add a beforeSave() method:

    <?php
public function beforeSave() {
    if ($file = CUploadedFile::getInstance($this, 'logo')) {
        $this->logo = file_get_contents($file->tempName);
    }
    return parent::beforeSave();
}

In the Controller

  • save the model as follows: ("Client" is what my AR model is called. You replace it with your model's name)

    <?php
if (isset($_POST['Client'])) {
    $model = $_POST['Client'];
    $ar = new Client;
    $ar->attributes = $model;
    if ($ar->save()) {
        Yii::app()->user->setFlash('success', 'Client successfully added.');
        $this->redirect(['client/index', 'id' => $ar->id]);
    } else {
        Yii::app()->user->setFlash('error', 'There was an error. Please correct your input and/or try again later');
        $this->refresh();
    }
}

    In the View (where you will place the upload form)

  • make sure your form is of the right type: (pay attention to the "stateful" and "enctype" properties)

    <?php
$form = $this->beginWidget('CActiveForm', [
    'id' => 'Client-form',
    'enableAjaxValidation' => true,
    'enableClientValidation' => true,
    'stateful' => true,
    'htmlOptions' => ['enctype' => 'multipart/form-data'],
]);

  • the form item itself should be of type "fileField":

    <div class="row">
    <?php echo $form->labelEx($model, 'logo'); ?>
    <?php echo $form->fileField($model, 'logo'); ?>
    <?php echo $form->error($model, 'logo'); ?>
</div>

In the View (where you will display the image)

  • base64_encode your image data and send it using this neat trick: (again, "logo" is what my attribute is called. Replace it with yours). Also, the mime type used here should match your image's format. There are many php functions that help you do that.

        <img src="data:image/jpeg;base64,<?= base64_encode($model->logo) ?>" height="100%" width="100%" />

yii blob upload

Archive