<?php
date_default_timezone_set('Asia/Manila');
header('Content-Type: application/json');
error_reporting(0);
$sqlUser = 'autoph_arnel';
$sqlDatabase = 'autoph_connect';
$sqlPass = 'Hke@2001';
$toDate = date_create() ->format("Y/m/d");
 

$conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.');
$db =  mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.');
 
 
$ApiKey= $_REQUEST['apiKey']; // Expect LoginName, LoginPassword   
$empID= $_REQUEST['empID']; // Expect LoginName, LoginPassword   
//=========================================================
if($ApiKey ==  453454353454534523413432){//FOR APPROVAL REST API FUNCTION
  $getMyClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE  `cl_h_emp_id`='$empID'  ORDER BY `cl_h_date_created` DESC");
  
   $return_tag = Array(); 
    //$count =  $count + 1;
 	     
   while($sqlRecord=mysql_fetch_assoc($getMyClearance)){
       $count  = $count + 1;
       $return_tag[]=$sqlRecord;
   }
   if($count == 0 || $count == '0'){
       $visible='true';
   }else{
       $visible='false';
   }
    $json = json_encode([$return_tag, "Visible" => "$visible"]);
}
 
echo $json;
//echo $jsonA;
  
 
?>