CSV File To DB In Yii

CSV File Upload

Using the below code i created the form “importcsvform.php”.

importcsvform

<div class="form">
<?php $form=$this->beginWidget('CActiveForm', array(
 'id'=>'csv-form',
 'enableAjaxValidation'=>false,
    'htmlOptions'=>array('enctype' => 'multipart/form-data'),
)); ?>

 <?php //echo $form->errorSummary($model); ?>

 <div class="row">
  <?php echo $form->labelEx($model,'csvfile'); ?>
        <?php 
            $this->widget('CMultiFileUpload', array(
                'model'=>$model,
                'name' => 'csvfile',
                'max'=>1,
                'accept' => 'csv',
                'duplicate' => 'Duplicate file!', 
                'denied' => 'Invalid file type',              
            ));
        ?>
  <?php echo $form->error($model,'csvfile'); ?>
 </div>

 <div class="row buttons">
  <?php echo CHtml::submitButton('Import',array("id"=>"Import",'name'=>'Import')); ?>
 </div>
<?php $this->endWidget(); ?>
</div><!-- form -->

Read CSV In Controller

CSV file contains the data in follwoing format

Name Age
Yii 20
Framework 25
 public function actionImport(){
        $model=new Csv;
  if(isset($_POST['csv']))
  {
   $model->attributes=$_POST['csv'];
            $filelist=CUploadedFile::getInstancesByName('csvfile');
   // To validate 
            if($filelist)
                $model->csvfile=1;
            if($model->validate())
            {
                foreach($filelist as $file)
                {
                    try{
                    $transaction = Yii::app()->db->beginTransaction();
                    $handle = fopen("$file->tempName", "r");
                    $row = 1;
                    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                        if($row>1){
                              $newmodel=new Csv;       
                              $newmodel->name=$data[0];
                              $newmodel->age=$data[1];
                              $newmodel->save();            
                        }
                        $row++;               
                    }
                    $transaction->commit();
                    }catch(Exception $error){
                        print_r($error);
                        $transaction->rollback();
                    }                    
                }                            
            }                        
  }
  $this->render('importcsvform',array(
   'model'=>$model,
  ));        
    }