solusi 2021-03

<?php
   include '../koneksi/lokal1.php';
    include 'excel_reader2.php';

     require('spreadsheet-reader-master/SpreadsheetReader.php');

    if ($_POST['upload'] == "upload") {
        $type         =explode(".",$_FILES['namafile']['name']);

        if (empty($_FILES['namafile']['name'])) {
            ?>
                <script language="JavaScript">
                    alert('Oops! Please fill all / select file ...');
                    document.location='./';
                </script>
            <?php
        }
        else if(strtolower(end($type)) !='xls'){
            ?>
                <script language="JavaScript">
                    alert('Oops! Please upload only Excel XLS file ...');
                    document.location='./';
                </script>
            <?php
        }
        else{
        $target = basename($_FILES['namafile']['name']) ;
        move_uploaded_file($_FILES['namafile']['tmp_name'], $target);
        $data    =new Spreadsheet_Excel_Reader($_FILES['namafile']['name'],false);
        $baris = $data->rowcount($sheet_index=0);
        for ($i=3; $i<=$baris; $i++){
            $no     =$data->val($i, 1);
            $noacc     =$data->val($i, 2);
            $plafond    =$data->val($i, 3);
            $os           =$data->val($i, 4);

            $sql ="INSERT INTO aksenplain (no, noacc, plafond,os) VALUES ('$no','$noacc','$plafond','$os')";

            $query=sqlsrv_query($conn, $sql);
            if(!$query){ //ini hrs jelas gagal
                ?>
                    <script language="JavaScript">
                        alert('<b>Oops!</b> 404 Error Server.');

                    </script>
                <?php
                die($sql);
            }
            else{
               //nothing happen?!
            }

        }

        unlink($_FILES['namafile']['name']);
         ?>
         <script language="JavaScript">
                        alert('Good! Import Excel XLS file success...');
                        document.location='./';
                    </script>
                <?php
        }
        exit
    }
    else
    {
        ?>   <script language="JavaScript">
                        alert('NO UPLOAD FOUND');

                    </script>
                <?php

    }
?>