<?php
session_start();
	include("SpreadsheetAPI_pdo_MIS.php");
extract($_POST);
$creterial='';
if(isset($matNo))   $creterial.= $matNo.',';
if(isset($names)) $creterial.= $names.',';
if(isset($course)) $creterial.= $course.',';
if(isset($level)) $creterial.= $level.',';
if(isset($mode)) $creterial.= $mode.',';
if(isset($state)) $creterial.= $state.',';
if(isset($lga)) $creterial.= $lga.',';
if(isset($dob)) $creterial.= $dob.',';
if(isset($gsm)) $creterial.= $gsm.',';
if(isset($sex)) $creterial.= $sex.',';
if(isset($address)) $creterial.= $address.',';
if(isset($town)) $creterial.= $town.',';
if(isset($email)) $creterial.= $email.',';
if(isset($gName)) $creterial.= $gName.',';
if(isset($gGSM)) $creterial.= $gGSM.',';
if(isset($gAddress)) $creterial.= $gAddress.',';
//echo $creterial;
$count=count(explode(',',$creterial));
 $cre=explode(',',$creterial);
$created=$cre[0];
for($i=1;$i<$count-1;++$i){
   $created.=', '.$cre[$i];
}
echo $created;
$_SESSION['colum_item']=$created;
function recordSetToJson($mysql_result,$jsonencode=false,$marker="") {
		$return_arr = array();
		while($datarow = mysql_fetch_assoc($mysql_result)){
			$return_arr[] = $datarow;
		}   		
		if (!$jsonencode)	
			return $return_arr;
		else{
			if ($marker != "")
				return json_encode(array($marker =>$return_arr));			
			else
				return json_encode($return_arr);
		}
	}
	//
	$filename = "extraction.xls";

          //  $Query = "SELECT * from vwAllPayments order by paymentType";
/*require_once('../connect.php');
$db=db_connect();
            $Query1 = $db->query("DROP TABLE IF EXISTS export2016_17; CREATE TABLE export2016_17 (SELECT a.matNo, d.formNo, a.names, a.course, a.levelID, orderID, remitaRRR, transDate, amtPaid, paymentType, transApproved, remark, d.status
FROM remitaorder b, realdata a
LEFT JOIN rawcgpa c ON a.matNo = c.matNo
LEFT JOIN admitted d ON a.formNo = d.formNo
WHERE (
a.matNo = b.regNo
OR a.formNo = b.regNo
)
AND transApproved = 'True' and MONTH(transDate) = '$mt' and Year(TransDate) = '$yr' group by b.remitaRRR order by b.paymentType)");

//$Query="select * from vwBursary";

*/
		if (isset($_REQUEST['JSON'])){
            $result = $db->query($Query);
            if ($result->rowCount() == 0)
				echo "NOT_FOUND";
			else

				echo recordSetToJson($results,true);
		}else {
            //$result=$result1->fetchAll(PDO::FETCH_BOTH);
            // $result=mysql_query($Query,$db);
            //echo 'here';
            // $result = $db->query($Query);

           // xlsProcess($filename);
          //  exit;
        }
?>