yii2 服务器端导入数据库文件夹,yii2导入csv到数据库
{
$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,
]);
}
}
{ $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, ]); } }