As a follow-up from the How to upload a file using a model wiki entry that explains how to save a file to the filesystem, this article will do the same using a blob field in the database.
The first step is to change the model in order to self manage the file:
class Candidate extends CActiveRecord { /** * Property for receiving the file from the form * It should be different from any other field in the database */ public $uploadedFile; public function rules() { return array( array('uploadedFile', 'file', 'types'=>'jpg, gif, png'), ); } /** * Saves the name, size, type and data of the uploaded file */ public function beforeSave() { if($file=CUploadedFile::getInstance($this,'uploadedFile')) { $this->file_name=$file->name; $this->file_type=$file->type; $this->file_size=$file->size; $this->file_content=file_get_contents($file->tempName); } return parent::beforeSave(); } }
Do not forget to give a rule for this attribute as it has to be safe. Is also a good practice to delete any rule referring to the other 4 fields (file_name, file_type, file_size, file_content), as they are not supposed to be modified by massively assigned inputs.
In the view we can put:
<div class="row"> <?php echo $form->labelEx($model,'uploadedFile'); <?php echo $form->fileField($model,'uploadedFile'); <?php echo $form->error($model,'uploadedFile'); </div>
In the view we put the code:
echo CHtml::link(my_link_name,array('displaySavedImage','id'=>$model->primaryKey));
So it generates link like http://myserver/yii/myapp/index.php?r=candidate/displaySavedImage&id=1
Where Candidate is current model.
To show saved image we can write an action in Controller:
/** * Opens the dialog in browser to open/save the image. */ public function actionDisplaySavedImage() { $model=$this->loadModel($_GET['id']); header('Pragma: public'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Content-Transfer-Encoding: binary'); header('Content-length: '.$model->file_size); header('Content-Type: '.$model->file_type); header('Content-Disposition: attachment; filename='.$model->file_name); echo $model->file_content; }
Note $_GET['id'] as passed argument of loadModel function.
Total 7 comments
Error 403
You are not authorized to perform this action.
im getting this error when i click the link to display in from link " http://localhost/yii/test3/index.php?r=patient/displaySavedImage&id=4"
It doesn't work. I get the following hyperlink displayed in view:
/connectUm/index.php/candidate
which points to:
/connectUm/index.php/candidate/displaySavedImage/1
but no image is displayed.
It should be noted that images can be displayed inline via the data URI scheme.
How do we display an image retrieved from a blob? See the last part of the tutorial, you have to create an action this porpouse.
Or save it to disk on the server? You have not to copy, you can create an action like actionDisplaySavedImage.
If you want to save directly in the disk, there is another tutorial about it, see here
If the answer to how to display the image from a blob is that we must temporarily copy it to a location on the server and reference it there, then how do we retrieve the blob and write to an image file on the server?
How do we take the image in the blob and get it to show up in an image tab or other container?
when i run it i get error undefined index:id
and if i do print_r($_GET); to see what values are set i get an empty array
Leave a comment
Please login to leave your comment.