mysql - Import Excel in Yii2 -

-

i have yii2 application using advanced template , database mysql, make function import excel file 1 of table, made function in controller named student contains crud of students data.this code

 public function actionimportexcel() {     $inputfile = 'uploads/siswa_file.xlsx';     try{         $inputfiletype = \phpexcel_iofactory::identify($inputfile);         $objreader = \phpexcel_iofactory::createreader($inputfiletype);         $objphpexcel = $objreader->load($inputfile);     } catch (exception $e) {         die('error');     }      $sheet = $objphpexcel->getsheet(0);     $highestrow = $sheet->gethighestrow();     $highestcolumn = $sheet->gethighestcolumn();      for($row=1; $row <= $highestrow; $row++)     {         $rowdata = $sheet->rangetoarray('a'.$row.':'.$highestcolumn.$row,null,true,false);          if($row==1)         {             continue;         }          $siswa = new siswa();         $siswa->nis = $rowdata[0][0];          $siswa->nama_siswa  = $rowdata[0][1];          $siswa->jenis_kelamin  = $rowdata[0][2];          $siswa->ttl  = $rowdata[0][3];          $siswa->alamat  = $rowdata[0][4];          $siswa->telp  = $rowdata[0][5];          $siswa->agama  = $rowdata[0][6];          $siswa->nama_ortu  = $rowdata[0][7];          $siswa->telp_ortu  = $rowdata[0][8];          $siswa->pekerjaan_ortu = $rowdata[0][9];         $siswa->tahun_masuk = $rowdata[0][10];         $siswa->kelas = $rowdata[0][11];         $siswa->save();          print_r($siswa->geterrors());     }     die('okay'); }

but don't know how make button in view make function work. mean want make button when user click button , browse excel file can import file , data inside excel can import database

first should upload file

and processing function

there several parts of code must produce ..

eg view user upload file

view: @app/views/site/upload.php

<?php $form = activeform::begin(['options' => ['enctype' => 'multipart/form-data']]) ?>      <?= $form->errorsummary($model); ?>      <?= $form->field($model, 'imagefile')->fileinput() ?>      <button>submit</button>  <?php activeform::end() ?>

controller: @app/controllers/sitecontroller.php

namespace app\controllers;  use yii; use yii\web\controller; use app\models\uploadform; use yii\web\uploadedfile;  class sitecontroller extends controller {     public function actionupload()     {         $model = new uploadform();          if (yii::$app->request->ispost) {             $model->imagefile = uploadedfile::getinstance($model, 'imagefile');             if ($model->upload()) {                 // file uploaded                 return;             }         }          return $this->render('upload', ['model' => $model]);     } }

model: @app/models/uploadform.php

namespace app\models;  use yii\base\model; use yii\web\uploadedfile;  class uploadform extends model {     /**      * @var uploadedfile      */     public $imagefile;      public function rules()     {         return [             [['imagefile'], 'file', 'skiponempty' => false, 'extensions' => 'png, jpg'],         ];     }      public function upload()     {         if ($this->validate()) {             $this->imagefile->saveas('uploads/' . $this->imagefile->basename . '.' . $this->imagefile->extension);             return true;         } else {             return false;         }     } }

the code this doc


Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more