View difference between Paste ID: 8w5AKxez and 9zSyPBdz
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
?>