How to upload image(photo), and path entry in database with update functionality Follow @yiiframework

I saw many posts that community newbie is confuse in image/photo upload with random name. so I post this topic covering all useful things regarding to image/photo upload(not covering image attribute related functionality)

View : ¶

_form.php file:

..
//form options array...
'htmlOptions' => array(
        'enctype' => 'multipart/form-data',
    ),
...
..
//Other elements
..
..
<div class="row">
        <?php echo $form->labelEx($model,'image'); ?>
        <?php echo CHtml::activeFileField($model, 'image'); ?>  // by this we can upload image
        <?php echo $form->error($model,'image'); ?>
</div>
<?php if($model->isNewRecord!='1'){ ?>
<div class="row">
     <?php echo CHtml::image(Yii::app()->request->baseUrl.'/banner/'.$model->image,"image",array("width"=>200)); ?>  // Image shown here if page is update page
</div>
..
..
Other elements
..
..

.. ..

Model : ¶

just add below line in rules() method in Model

array('image', 'file','types'=>'jpg, gif, png', 'allowEmpty'=>true, 'on'=>'update'), // this will allow empty field when page is update (remember here i create scenario update)

for all others rules you had to give scenario for insert and update as the rule will apply on both page( Insert and Update ) i.e:

array('title, image', 'length', 'max'=>255, 'on'=>'insert,update'),

.. .. Now comes the main part,

Controller : ¶

Create controller will upload image with random name and enter required database entry.

public function actionCreate()
    {
        $model=new Banner;  // this is my model related to table
        if(isset($_POST['Banner']))
        {
            $rnd = rand(0,9999);  // generate random number between 0-9999
            $model->attributes=$_POST['Banner'];
 
            $uploadedFile=CUploadedFile::getInstance($model,'image');
            $fileName = "{$rnd}-{$uploadedFile}";  // random number + file name
            $model->image = $fileName;
 
            if($model->save())
            {
                $uploadedFile->saveAs(Yii::app()->basePath.'/../banner/'.$fileName);  // image will uplode to rootDirectory/banner/
                $this->redirect(array('admin'));
            }
        }
        $this->render('create',array(
            'model'=>$model,
        ));
    }

Now comes the update action,

public function actionUpdate($id)
    {
        $model=$this->loadModel($id);
 
        if(isset($_POST['Banner']))
        {
            $_POST['Banner']['image'] = $model->image;
            $model->attributes=$_POST['Banner'];
 
            $uploadedFile=CUploadedFile::getInstance($model,'image');
 
            if($model->save())
            {
                if(!empty($uploadedFile))  // check if uploaded file is set or not
                {
                    $uploadedFile->saveAs(Yii::app()->basePath.'/../banner/'.$model->image);
                }
                $this->redirect(array('admin'));
            }
 
        }
 
        $this->render('update',array(
            'model'=>$model,
        ));
    }

Above example is Upload image in specific folder and enter require entry in database. On update it will overwrite image in folder and update the data.

Total 9 comments

#12985

Shahcheraghean at 2013/04/25 05:00am

saving 2 or 3 files

when i try your code for insert, it insert 1 record contain filename with random number and 2 record contain just random numbers?

#10394

kiran sharma at 2012/10/25 09:41am

@Giacomo

Ok, so you want to store default.jpg in database and no saveAs function on empty image field.

so, just do following step:

set fileName default.jpg on empty field as

if(empty($uploadedFile))
  $fileName = 'default.jpg';  // write this code below $fileName = "{$rnd}-{$uploadedFile}";

and for saveAs function use below code,

if(!empty($uploadedFile))
   $uploadedFile->saveAs(Yii::app()->basePath.'/../banner/'.$fileName);

I had tested it and working fine... :D

#10349

Giacomo at 2012/10/22 05:12am

Help

Hi, if no image is submitted the page freezes. I've to do something like

if($uploadedFile != null){
     $rnd = rand(0,9999);  
     $fileName = "{$rnd}-{$uploadedFile}"; 
 }else{
      $fileName = 'default.jpg';    
 }

in order to prevent it. Also i've to do the same here

if($model->save())
{    if($uploadedFile != null){
          $uploadedFile->saveAs(Yii::app()->basePath.'/../banner/'.$fileName);
     } 
           $this->redirect(array('admin'));
}

This declaration inside rules

'allowEmpty' => true,'on'=>'insert,update'

should not prevent this error?

Thanks for your help

#9034

kiran sharma at 2012/07/15 02:41am

@kmindi

yes, i think that part was missing. @kmindi, thankx for update.

#9032

kmindi at 2012/07/14 04:11pm

multipart/form-data

I could not get it to work until i added

'htmlOptions' => array(
        'enctype' => 'multipart/form-data',
    ),

to my options array to the form (using EBootstrapActiveForm)

I updated the article to contain that information too ...

#8961

kiran sharma at 2012/07/10 01:06am

@shaan360

@shaan360, its ok if you do not add scenario on update. you specify in model and not specify in model as $model->scenario='update' than its ok, if you specify user define scenario the you have to specify in controller. cheers..

#8954

shaan360 at 2012/07/09 02:31pm

setting the scenario

and dont forget to set the scenario

$model->scenario='update';

#8913

kiran sharma at 2012/07/07 01:14am

@speedlog

@speedlog, yes you rite, but this is just for demo purpose as upload image with random name.

#8907

Mariusz W. at 2012/07/06 03:11pm

Random is not good

Better way is first save record and than save image, where in file name should be Primary Key of this record (PK guarantee unique). All involved in transaction and when file will not be saved than rollback.

Please login to leave your comment.

How to upload image(photo), and path entry in database with update functionality Follow @yiiframework

View : ¶

Model : ¶

Controller : ¶

Total 9 comments

Leave a comment

Yii Supporters