<script type="text/javascript" src="../jquery/load.js"></script> <?php include '../excel/excel_reader2.php'; include '../koneksi.php'; $dbase = new koneksi(); $data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']); $baris = $data->rowcount($sheet_index = 0); $sukses = 0; $gagal = 0; for ($i = 2; $i <= $baris; $i++) { $kd_barang = $data->val($i, 2); $nm_barang = $data->val($i, 3); $merk = $data->val($i, 4); $tipe_barang = $data->val($i, 5); $tgl_pembelian = $data->val($i, 6); $harga_barang = $data->val($i, 7); $status = $data->val($i, 8); $ket = $data->val($i, 9); $hasil = $dbase->insertBarang($kd_barang, $nm_barang, $merk, $tipe_barang, $tgl_pembelian, $harga_barang, $status, $ket); if ($hasil) { $sukses++; } else { $gagal++; } if ($i == $baris) { header("location:it.php"); echo "<div id='loading'><h3> Proses Import Data Pegawai Selesai</h3>"; echo "<p>Jumlah data sukses diimport : " . $sukses . "<br>"; echo "Jumlah data gagal diimport : " . $gagal . "<p></div>"; } }