<?php
//session_start();
//
	// Functions for export to csv.
	function setExcelContentType() {
		if(headers_sent())
			return false;
		//
		header('Content-type: application/vnd.ms-excel');
		return true;
	}

	function setDownloadAsHeader($filename) {
		if(headers_sent())
			return false;
		//
		header('Content-disposition: attachment; filename=' . $filename);
		header('Pragma: no-cache');
		header('Expires: 0');
		return true;
	}

	function csvFromResult($stream, $result, $showColumnHeaders = true) {
		if($showColumnHeaders) {
			$columnHeaders = array();
			$nfields = mysql_num_fields($result);
			for($i = 0; $i < $nfields; $i++) {
				$field = mysql_fetch_field($result, $i);
				$columnHeaders[] = $field->name;
			}
			fputcsv($stream, $columnHeaders);
		}
		//
		$nrows = 0;
		while($row = mysql_fetch_row($result)) {
			fputcsv($stream, $row);
			$nrows++;
		}
		//
		return $nrows;
	}

	function csvFileFromResult($filename, $result, $showColumnHeaders = true) {
		$fp = fopen($filename, 'w');
		$rc = csvFromResult($fp, $result, $showColumnHeaders);
		fclose($fp);
		return $rc;
	}

	function csvToExcelDownloadFromResult($result,$asFilename = 'data.csv',$showColumnHeaders = true) {
		setExcelContentType();
		setDownloadAsHeader($asFilename);
		return csvFileFromResult('php://output', $result, $showColumnHeaders);
	}


	// Functions for export to excel.
	function xlsBOF() {
		echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
		return;
	}
	function xlsEOF() {
		echo pack("ss", 0x0A, 0x00);
		return;
	}
	function xlsWriteNumber($Row, $Col, $Value) {
		echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
		echo pack("d", $Value);
		return;
	}
	function xlsWriteLabel($Row, $Col, $Value ) {
		$L = strlen($Value);
		echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
		echo $Value;
		return;
	}

	function xlsProcess($filename){
		//
		header("Content-Type: application/force-download");
		header("Content-Type: application/octet-stream");
		header("Content-Disposition: attachment;filename=".$filename);
		header("Content-Transfer-Encoding: binary");
		//
		xlsBOF();

		// make column headers from selected fields
		// Make a top line on your excel sheet at line 1 (starting at 0)
		// The first number is the row number and the second number is the column, both are start at '0'
        require_once('../../connect.php');
        $db=db_connect();
        if (isset($_SESSION['sch_id'])){
            $schID=$_SESSION['sch_id'];
        }

		//$fields = $queryHandle->columnCount();
        $result3 = $db->query("Describe registered_details_temptt");
       $colums=$result3->fetchAll(PDO::FETCH_COLUMN);
        $ttype=$_SESSION['ttype'];
$schk=strtoupper("Student Bio-data");
        xlsWriteLabel(0,0, "Federal Polytechnic Ede");
        xlsWriteLabel(1,0, $schk);
        xlsWriteLabel(2,0, $ttype);
        $i = 0;

        //==================
//        $objPHPExcel->getActiveSheet()->mergeCells('A1:E4');
        //===================
         foreach($colums as $col){

            xlsWriteLabel(4,$i, $col);
            $i++;
      }

		$xlsRow = 5;
		// Put data records from mysql by while loop.

        $Query="select * from registered_details_temptt";

      $result = $db->query($Query);
		while($row=$result->fetch(PDO::FETCH_ASSOC)){
			$xlsCol = 0;
			foreach($row as $value) {
				xlsWriteLabel($xlsRow,$xlsCol,$value);
				$xlsCol++;
			}
			$xlsRow++;
		}

		xlsEOF();

	}
?>