Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include "excel_reader2.php";
- include 'koneksi.php';
- // file yang tadinya di upload, di simpan di temporary file PHP, file tersebut yang kita ambil
- // dan baca dengan PHP Excel Class
- $data = new Spreadsheet_Excel_Reader($_FILES['fileexcel']['tmp_name']);
- $hasildata = $data->rowcount($sheet_index=0);
- for ($i=2; $i<=$hasildata; $i++)
- {
- $nis = $data->val($i,1);
- $nama = $data->val($i,2);
- $username = $data->val($i,3);
- $password =md5($data->val($i,4));
- $jenis_kelamin = $data->val($i,5);
- $absen = $data->val($i,6);
- $kelas = $data->val($i,7);
- $jurusan = $data->val($i,8);
- $query = "INSERT INTO siswa (nama_siswa,nis_siswa,username_siswa,password_siswa,jenis_kelamin_siswa,absen_siswa,kelas_siswa,jurusan_siswa)
- VALUES ('$nama','$nis','$username','$password','$jenis_kelamin','$absen','$kelas','$jurusan')";
- $hasil = mysql_query($query);
- }
- if ($hasil)
- {
- header('location:home.php?page=daftarkelas&info=import siswa berhasil');
- }
- else
- {
- header('location:home.php?page=daftarkelas&info=import siswa gagal');
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement