/*set_include_path('.:/export/vol2/httpd/htdocs//administration/facilities:/php/includes:/export/vol2/httpd/htdocs/includes:/export/vol2/httpd/htdocs/its/oit/includes');
    require $_SERVER['DOCUMENT_ROOT'] . '/administration/facilities/webapps/includes/PHPSpreadsheet/Reader/Xlsx.php';
    foreach (glob("../webapps/includes/PHPSpreadsheet/Reader/*.php") as $filename) { 
        include $filename; 
    }
    
    require("../../webapps/includes/PHPSpreadsheet/Reader/Xlsx.php");
    
    include 'vendor/autoload.php';
	
	use PhpOffice\PhpSpreadsheet\IOFactory;
    use PhpOffice\PhpSpreadsheet\Spreadsheet;
    
    if($_FILES["select_excel"]["name"] != '') {
        $allowed_extension = array('xls', 'xlsx');
        $file_array = explode(".", $_FILES['select_excel']['name']);
        $file_extension = end($file_array);
        if(in_array($file_extension, $allowed_extension)) {
            $reader = IOFactory::createReader('Xlsx');
            $spreadsheet = $reader->load($_FILES['select_excel']['tmp_name']);
            $writer = IOFactory::createWriter($spreadsheet, 'Html');
            $message = $writer->save('php://output');
        } else {
            $message = '<div class="alert alert-danger">Only .xls or .xlsx file allowed</div>';
        }
    } else {
        $message = '<div class="alert alert-danger">Please Select File</div>';
    }
    
    echo $message;
    
	$host = "oitss5.auburn.edu";
	//$host = "oitss7.auburn.edu:4433";
	$db = "FAC_WEBAPPS_dev";
	//$db = "FAC_WEBAPPS";
	$user = "facweb";
	$pass = "adap3fwrs";

	$pdo = new PDO("dblib:host=" . $host . ";dbname=" . $db, $user, $pass);
	$stmt = $pdo->prepare("DELETE FROM dbo.DEPT");
	$stmt->execute();
	
	$targetPath = 'uploads/' . $_FILES['file']['name'];
    move_uploaded_file($_FILES['file']['tmp_name'], $targetPath);
	
	$Reader = new Xlsx();

    $spreadSheet = $Reader->load($targetPath);
    $excelSheet = $spreadSheet->getActiveSheet();
    $spreadSheetAry = $excelSheet->toArray();
    $sheetCount = count($spreadSheetAry);
    
    echo $spreadSheet;
    echo $spreadSheetAry;*/

    /*for ($i = 0; $i <= $sheetCount; $i ++) {
        $name = "";
        if (isset($spreadSheetAry[$i][0])) {
            $name = mysqli_real_escape_string($conn, $spreadSheetAry[$i][0]);
        }
        $description = "";
        if (isset($spreadSheetAry[$i][1])) {
            $description = mysqli_real_escape_string($conn, $spreadSheetAry[$i][1]);
        }

        if (! empty($name) || ! empty($description)) {*/