I am importing csv file on database. But getting this error after submit
Fatal error: Call to undefined method stdClass::getTempName()
Controller
public function actionImportCSV()
{
$model=new UserImportForm;
if(isset($_POST[‘UserImportForm’]))
{
$model->attributes=$_POST[‘UserImportForm’];
if($model->validate())
{
$csvFile->file=CUploadedFile::getInstance($model,'file');
$tempLoc=$csvFile->getTempName();
$sql="LOAD DATA INFILE '".$tempLoc."' INTO TABLE `tbl_emp_master`
FIELDS
TERMINATED BY ','
ENCLOSED BY '\"'
LINES
TERMINATED BY '\n'
IGNORE 1 LINES
(`emp_id`, `name`, `cardnumber`, `uid`, `location`, `grade`, `department`, `emp_type`, `access_group`, `check_in`, `check_out`)";
$connection=Yii::app()->db;
$transaction=$connection->beginTransaction();
try
{
$connection->createCommand($sql)->execute();
$transaction->commit();
}
catch(Exception $e) // an exception is raised if a query fails
{
print_r($e);
exit;
$transaction->rollBack();
}
$this->redirect(array("site/index"));
}
}