Upload File In Database

Yii 1.1 General Discussion
1

Hi,

I have been trying to upload a file to database since 10days but failing each time.

I have tried 2methods:

  1. upload the actual file to DB.

  2. store the path only.

I am pretty sure that the second method should be preferred, I have gone thru many forums but could not find any.

Any help would be of great use to me.

2

Hi shravya.

I have just posted today the solution to second method: "store the path only", please see this message in the next post Image Upload Using Ajax.

I hope this will help you.

3

hi shrav,ya, its better to save path in DB, and sotre file in some folder insiide your Web app.

your model will be like this…




class Item extends CActiveRecord { 	public $image; 	// ... other attributes   	public function rules()	

 {

     	return array(  	

   	array('image', 'file', 'types'=>'jpg, gif, png'),	

 	);  

   } }

try your controller like…




class ItemController extends CController { 

	public function actionCreate() 	

{ 	

	$model=new Item;     	if(isset($_POST['Item'])) 	

	{         	$model->attributes=$_POST['Item'];         	$model->image=CUploadedFile::getInstance($model,'image');  	

   	if($model->save())   

      	{             	$model->image->saveAs('path/to/localFile'); 	// redirect to success page  	

   	}     	}  

   	$this->render('create', array('model'=>$model)); 

	}

and finally view file like…




$form = $this->beginWidget( 	'CActiveForm',  

   array(     	'id' => 'upload-form',     	'enableAjaxValidation' => false,     	'htmlOptions' => array('enctype' => 'multipart/form-data'), 	) ); // ... echo $form->labelEx($model, 'image');

 echo $form->fileField($model, 'image');

 echo $form->error($model, 'image'); 

// ... echo CHtml::submitButton('Submit'); $this->endWidget();

I hope it will help you

4

Hi,

I have tried the above method, but when I upload the file and say create, it says that the field is empty.

this is my code–

model:

array(‘name’, ‘file’, ‘types’=>‘jpg, gif, png’),

view:

<?php

&#036;form = &#036;this-&gt;beginWidget('CActiveForm',  


   array(       


	'id' =&gt; 'upload-form',          


	'enableAjaxValidation' =&gt; false,


        'htmlOptions' =&gt; array('enctype' =&gt; 'multipart/form-data'),   


	  )


 ); 


 echo &#036;form-&gt;fileField(&#036;model, 'name');


 echo &#036;form-&gt;error(&#036;model, 'name'); 





?&gt;


&lt;?php &#036;this-&gt;endWidget(); ?&gt;

controller:

public function actionCreate()

{


	&#036;model=new Event;


	


	


	// Uncomment the following line if AJAX validation is needed


	 &#036;this-&gt;performAjaxValidation(&#036;model);// AJAX VALIDATION





	


	if(isset(&#036;_POST['Event']))


	{


		&#036;model-&gt;attributes=&#036;_POST['Event'];


		&#036;model-&gt;name=CUploadedFile::getInstance(&#036;model,'name');


		 //&#036;model-&gt;name=CUploadedFile::getInstance(&#036;model,'name');


		if(&#036;model-&gt;save())


		{


			//&#036;uploadedFile-&gt;saveAs(Yii::app()-&gt;basePath.'/&#46;&#46;/event/'.&#036;fileName); 


			&#036;model-&gt;name-&gt;saveAs('//attachments/');


			&#036;this-&gt;redirect(array('view','id'=&gt;&#036;model-&gt;ename));


		}


	}


	&#036;this-&gt;render('create',array(


		'model'=&gt;&#036;model,


	));


}

I have noticed that my view file has a widget in a widget. Would that create a problem?

5

Hi all,

I have got the solution…there was some problem with nested widgets…

but I’m unable to give the path in the controller.

I gave something like this which is not working. PLz help

       model-&gt;name-&gt;saveAs('.//attachements/);
6

Try this




$uploadfile= $model->name;

$uploadfile->saveAs(dirname(Yii::app()->basePath) . '/attachments/'.$uploadfile);
7

Thank you,

it worked!!