-
Notifications
You must be signed in to change notification settings - Fork 0
/
upload.php
87 lines (81 loc) · 2.83 KB
/
upload.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<?php
include "conn/koneksi.php";
include "import/excel_reader2.php";
$dataUpload = $_GET['data'];
if ($dataUpload == 'training') {
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
$baris = $data->rowcount($sheet_index = 0);
for ($i = 2; $i <= $baris; $i++) {
$jk = $data->val($i, 2);
$ppdb = $data->val($i, 3);
$bhs_indonesia = $data->val($i, 4);
$matematika = $data->val($i, 5);
$bhs_inggris = $data->val($i, 6);
$ipa = $data->val($i, 7);
$ips = $data->val($i, 8);
$skhu = $data->val($i, 9);
$jurusan = $data->val($i, 10);
if ($baris) {
$import = mysql_query(
"INSERT INTO data_training (jk,ppdb,bhs_indonesia,matematika,bhs_inggris,ipa,ips,skhu,jurusan)
VALUES ('$jk','$ppdb','$bhs_indonesia','$matematika','$bhs_inggris','$ipa','$ips','$skhu','$jurusan')"
);
if ($import) {
$sts[] = 'Data berhasil disimpan';
header('location:data_training.php?status_import=sukses-import');
} else {
header('location:data_training.php?status_import=gagal-import');
$sts[] = 'Data gagal disimpan';
}
}
}
} else if ($dataUpload == 'user') {
$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++) {
$nisn = $data->val($i, 2);
$nama = $data->val($i, 3);
$jenis_kelamin = $data->val($i, 4);
$asal_sekolah = $data->val($i, 5);
if ($baris) {
$import = mysql_query("INSERT INTO data_siswa VALUES ('$nisn','$nama','$jenis_kelamin','$asal_sekolah')");
$import2 = mysql_query("INSERT INTO user VALUES ('$nisn','$nama','$nisn','siswa')");
if ($import && $import2) {
$sts[] = 'Data berhasil disimpan';
header('location:data_user.php?status_import=sukses-import');
} else {
header('location:data_user.php?status_import=gagal-import');
$sts[] = 'Data gagal disimpan';
}
}
}
} else if ($dataUpload == 'uji') {
$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++) {
$jk = $data->val($i, 2);
$ppdb = $data->val($i, 3);
$bhs_indonesia = $data->val($i, 4);
$matematika = $data->val($i, 5);
$bhs_inggris = $data->val($i, 6);
$ipa = $data->val($i, 7);
$ips = $data->val($i, 8);
$skhu = $data->val($i, 9);
$jurusan = $data->val($i, 10);
if ($baris) {
$import = mysql_query("INSERT INTO data_uji (jk,ppdb,bhs_indonesia,matematika,bhs_inggris,ipa,ips,skhu,jurusan_asli)
VALUES ('$jk','$ppdb','$bhs_indonesia','$matematika','$bhs_inggris','$ipa','$ips','$skhu','$jurusan')");
if ($import) {
$sts[] = 'Data berhasil disimpan';
header('location:uji_rule.php?status_import=sukses-import');
} else {
header('location:uji_rule.php?status_import=gagal-import');
$sts[] = 'Data gagal disimpan';
}
}
}
}