yii2 服务器端导入数据库文件夹,yii2导入csv到数据库

public function actionCreate()

{

$model = new Import();

if ($model->load(Yii::$app->request->post()) ) {

$model->file = UploadedFile::getInstance($model, 'file');

if ( $model->file )

{

$time = time();

$model->file->saveAs('csv/' .$time. '.' . $model->file->extension);

$model->file = 'csv/' .$time. '.' . $model->file->extension;

$handle = fopen($model->file, "r");

while (($fileop = fgetcsv($handle, 1000, ",")) !== false)

{

$name = $fileop[0];

$age = $fileop[1];

$location = $fileop[2];

// print_r($fileop);exit();

$sql = "INSERT INTO details(name, age, location) VALUES ('$name', '$age', '$location')";

$query = Yii::$app->db->createCommand($sql)->execute();

}

if ($query)

{

echo "data upload successfully";

}

}

$model->save();

return $this->redirect(['view', 'id' => $model->id]);

} else {

return $this->render('create', [

'model' => $model,

]);

}

}