Import data from CSV sheet to Database in Yii

In this post we will see how we can Import data from CSV sheet to Database in Yii.

For this You just have to download a JPhpExcelReader Extension.

[php]

$itu = CUploadedFile::getInstance($model,’csv_file’);
$data = new JPhpExcelReader($itu->getTempName());

$rows = array();
for($j=1; $j<=$data->sheets[0][‘numRows’]; $j++) {
if($j == 1){
$header = $data->sheets[0][‘cells’][$j];

}else{
$rowData = $data->sheets[0][‘cells’][$j];
$rows[] = array_combine($header,$rowData);
}
}
//Here in $rows you will get all csv sheet data in array format
foreach($rows as $row)
{

//define model
//fieldnames to save in model
//save data in database

}

[/php]

If you find it helpful, Please like this post and share it with your friends.