YII file upload not adding to database using form

Question

Im attempting to add a file upload field to a form in YII, while its succesfully submitting and uploading the file to the correct folder, its not adding anything to the database.

Im only learning this platform so any guidance would be great.

Here is my view...

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

Here is my controller...

public function actionEdit() {
    $id = Yii::app()->getRequest()->getQuery('id');
    $model = CustomPage::model()->findByPk($id);
    if (!($model instanceof CustomPage)) {
        Yii::app()->user->setFlash('error',"Invalid Custom Page");
        $this->redirect($this->createUrl("custompage/index"));

    }
    if(isset($_POST['CustomPage'])) {
        $model->attributes = $_POST['CustomPage'];
        $model->image=CUploadedFile::getInstance($model,'slider_image');

        if ($model->validate())    {
            if ($model->deleteMe) {
                $model->delete();
                Yii::app()->user->setFlash('info',"Custom page has been deleted");
                $this->redirect($this->createUrl("custompage/index"));
            } else {
                $model->request_url =  _xls_seo_url($model->title);
                if (!$model->save()) {
                    Yii::app()->user->setFlash('error',print_r($model->getErrors(),true));
                } else {
                    $model->image->saveAs(Yii::app()->baseUrl.'images/'.$model->image);
                    Yii::app()->user->setFlash('success',
                        Yii::t('admin','Custom page updated on {time}.',array('{time}'=>date("d F, Y  h:i:sa"))));
                    $this->beforeAction('edit'); //In case we renamed one and we want to update menu
                }
            }
        }
    }
}

and my model

public function rules()
{
    // NOTE: you should only define rules for those attributes that
    // will receive user inputs.
    return array(
                    // other rules
        array('slider_image', 'file', 'types'=>'jpg, gif, png'),
    );
}

The form itself overall is working fine, unfortunately I dont understand how YII adds to the database

Thanks

Adrian

EDIT: Ive also obviously got a slider_image field in that table

what your Controller code would do is save the file name of the upoloaded file in your database table. Another thing is: your code $model->image=CUploadedFile::getInstance($model,'slider_image'); is referring to the wrong attribute. I think it should be $model->slider_image=CUploadedFile::getInstance($model,'slider_image'); Finally, you need to call $model->slider_image->save('path.to.file'); in order to save the file to disk. — Oladapo Omonayajo
– Oladapo Omonayajo, Commented Sep 30, 2013 at 11:44
Glad I could help. Just posted the solution as an answer so others can find it easily. — Oladapo Omonayajo
– Oladapo Omonayajo, Commented Sep 30, 2013 at 13:37

Oladapo Omonayajo · Accepted Answer · 2013-09-30 14:04:36Z

2

What your Controller code would do is save the file name of the upoloaded file in your database table. Another thing is: your code:

$model->image=CUploadedFile::getInstance($model,'slider_image');

is referring to the wrong attribute. I think it should be:

$model->slider_image=CUploadedFile::getInstance($model,'slider_image');

Finally, you need to call $model->slider_image->save('path.to.file'); in order to save the file to disk

answered Sep 30, 2013 at 14:04

Oladapo Omonayajo

9809 silver badges14 bronze badges

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

Comments

Serhat Akay · Accepted Answer · 2013-09-30 11:45:33Z

0

I believe you get stock at $model->validate(). Because you do copy image above this line copying is fine but you do not go through validation so it never saves to DB.

var_dump($model->validate()); to see what is going on...

answered Sep 30, 2013 at 11:45

Serhat Akay

5343 silver badges10 bronze badges

Collectives™ on Stack Overflow

YII file upload not adding to database using form

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related