SHOW:
|
|
- or go back to the newest paste.
1 | <?php | |
2 | include '../koneksi/lokal1.php'; | |
3 | include 'excel_reader2.php'; | |
4 | ||
5 | require('spreadsheet-reader-master/SpreadsheetReader.php'); | |
6 | ||
7 | if ($_POST['upload'] == "upload") { | |
8 | $type =explode(".",$_FILES['namafile']['name']); | |
9 | ||
10 | if (empty($_FILES['namafile']['name'])) { | |
11 | ?> | |
12 | <script language="JavaScript"> | |
13 | alert('Oops! Please fill all / select file ...'); | |
14 | document.location='./'; | |
15 | </script> | |
16 | <?php | |
17 | } | |
18 | else if(strtolower(end($type)) !='xls'){ | |
19 | ?> | |
20 | <script language="JavaScript"> | |
21 | alert('Oops! Please upload only Excel XLS file ...'); | |
22 | document.location='./'; | |
23 | </script> | |
24 | <?php | |
25 | } | |
26 | - | else{ |
26 | + | else{ |
27 | $target = basename($_FILES['namafile']['name']) ; | |
28 | move_uploaded_file($_FILES['namafile']['tmp_name'], $target); | |
29 | $data =new Spreadsheet_Excel_Reader($_FILES['namafile']['name'],false); | |
30 | $baris = $data->rowcount($sheet_index=0); | |
31 | for ($i=3; $i<=$baris; $i++){ | |
32 | $no =$data->val($i, 1); | |
33 | $noacc =$data->val($i, 2); | |
34 | $plafond =$data->val($i, 3); | |
35 | $os =$data->val($i, 4); | |
36 | ||
37 | $sql ="INSERT INTO aksenplain (no, noacc, plafond,os) VALUES ('$no','$noacc','$plafond','$os')"; | |
38 | ||
39 | - | $query=sqlsrv_query($conn, $sql); |
39 | + | $query=sqlsrv_query($conn, $sql); |
40 | if(!$query){ //ini hrs jelas gagal | |
41 | - | if($query){ |
41 | + | |
42 | <script language="JavaScript"> | |
43 | alert('<b>Oops!</b> 404 Error Server.'); | |
44 | ||
45 | </script> | |
46 | <?php | |
47 | die($sql); | |
48 | } | |
49 | else{ | |
50 | - | ?> <script language="JavaScript"> |
50 | + | //nothing happen?! |
51 | } | |
52 | ||
53 | } | |
54 | ||
55 | unlink($_FILES['namafile']['name']); | |
56 | ?> | |
57 | <script language="JavaScript"> | |
58 | alert('Good! Import Excel XLS file success...'); | |
59 | document.location='./'; | |
60 | </script> | |
61 | <?php | |
62 | } | |
63 | exit | |
64 | } | |
65 | else | |
66 | { | |
67 | ?> <script language="JavaScript"> | |
68 | alert('NO UPLOAD FOUND'); | |
69 | ||
70 | </script> | |
71 | <?php | |
72 | ||
73 | } | |
74 | ?> |