| Server IP : 172.64.80.1 / Your IP : 172.70.50.62 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs/admin_main/ |
Upload File : |
<?php
//die("am Here");
//show status like '%connected%';
include("SpreadsheetAPI_pdoSIWES.php");
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 = "siwes.xls";
if (isset($_REQUEST['ADMIN']) && $_REQUEST['ADMIN']=='SIWES'){
require('../connect.php');
$db=db_connect();
if (isset($_REQUEST['VIEW']) && $_REQUEST['VIEW']=='TRUE'){
$Query = "SELECT * from vwAllPayments order by paymentType";
}else{
$Query="select * from export2016_17";
}
if (isset($_REQUEST['JSON'])){
$result = $db->query($Query);
if ($result->rowCount() == 0)
echo "NOT_FOUND";
else
echo recordSetToJson($results,true);
}else{
xlsProcess($filename);
exit;
}
}else{
echo "Un-authorized User, Access Denied";
}
?>