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 | ?> |