本文實例講述了yii2.0框架實現上傳excel文件后導入到數據庫的方法。分享給大家供大家參考，具體如下：
Model模型
?php
/**
* 描述...
* @author zcy
* @date 2019/8/13
*/
namespace app\models;
use yii\base\Model;
use yii\db\ActiveRecord;
use yii\web\UploadedFile;
class uploadForm extends ActiveRecord
{
public $file;
public function rules()
{
return [
[['file'],'file', 'skipOnEmpty' => false,'extensions' => 'xls,xlsx'],
];
}
public function attributeLabels()
{
return [
'file'=> '上傳文件'
];
}
public function upload()
{
$file = UploadedFile::getInstance($this, 'file');
if ($this->rules()) {
$tmp_file = $file->baseName . '.' . $file->extension;
$path = 'upload/' . 'Files/';
if (is_dir($path)) {
$file->saveAs($path . $tmp_file);
} else {
mkdir($path, 0777, true);
}
$file->saveAs($path . $tmp_file);
return true;
} else {
return '驗證失敗';
}
}
}
Views視圖
?php
use yii\widgets\ActiveForm;
$model = new app\models\uploadForm();
$form = ActiveForm::begin([
'id' => 'upload',
'options' => ['enctype' => 'multipart/form-data'],
])
?>
?= $form->field($model,'file')->fileInput(['multiple'=>'multiple']) ?>
button>上傳/button>
?php ActiveForm::end() ?>
Controller控制器
?php
/**
* 描述...
* @author zcy
* @date 2019/8/16
*/
namespace app\controllers;
use app\models\uploadForm;
use Yii;
use yii\web\Controller;
use yii\web\UploadedFile;
class UploadController extends Controller
{
/**
* 導入
* @author zcy
* @date 2019/8/16
*/
public function actionImport()
{
$model = new uploadForm();
if (Yii::$app->request->isPost) {
$model->file = UploadedFile::getInstance($model,'file');
// if ($model->upload()) {
// print EOT
// script>alert('上傳成功')/script>
//EOT;
// } else {
// print EOT
// script>alert('上傳失敗')/script>
//EOT;
// }
if (!$model->upload()) {
print EOT
script>alert('上傳失敗')/script>
EOT;
}
}
$ok = 0;
if ($model->load(Yii::$app->request->post())) {
$file = UploadedFile::getInstance($model,'file');
if ($file) {
$filename = 'upload/Files/' . $file->name;
$file->saveAs($filename);
if (in_array($file->extension,array('xls','xlsx'))) {
$fileType = \PHPExcel_IOFactory::identify($filename);//文件名自動判斷類型
$excelReader = \PHPExcel_IOFactory::createReader($fileType);
$phpexcel = $excelReader->load($filename)->getSheet(0);//載入文件并獲取第一個sheet
$total_line = $phpexcel->getHighestRow();//總行數
$total_column = $phpexcel->getHighestColumn();//總列數
if (1 $total_line) {
for ($row = 2;$row = $total_line;$row++) {
$data = [];
for ($column = 'A';$column = $total_column;$column++) {
$data[] = trim($phpexcel->getCell($column.$row));
}
$info = Yii::$app->db->createCommand()
->insert('{{%shop_info}}',['shop_name' => $data[0],'shop_type' => $data[1]])
->execute();
if ($info) {
$ok = 1;
}
}
}
if ($ok == 1) {
echo "script>alert('導入成功');window.history.back();/script>";
} else {
echo "script>alert('操作失敗');window.history.back();/script>";
}
}
}
} else {
return $this->render('import',['model' => $model]);
}
}
}
更多關于Yii相關內容感興趣的讀者可查看本站專題：《Yii框架入門及常用技巧總結》、《php優秀開發框架總結》、《smarty模板入門基礎教程》、《php面向對象程序設計入門教程》、《php字符串(string)用法總結》、《php+mysql數據庫操作入門教程》及《php常見數據庫操作技巧匯總》
希望本文所述對大家基于Yii框架的PHP程序設計有所幫助。
您可能感興趣的文章:- YII2框架中日志的配置與使用方法實例分析
- YII2框架中查詢生成器Query()的使用方法示例
- YII2框架中使用RBAC對模塊，控制器，方法的權限控制及規則的使用示例
- YII2框架中behavior行為的理解與使用方法示例
- YII2 全局異常處理深入講解
