<?php
date_default_timezone_set('Asia/Manila');
header('Content-Type: application/json');
 
$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   
//=========================================================
if($ApiKey == 453454353454534523413432){//FOR APPROVAL REST API FUNCTION
    $userID =  $_REQUEST['empID']; // Expect LoginName, LoginPassword*
 
$prfExecomCount = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_validate_links` WHERE `completed` = 0 AND `uid`=$userID AND `link` LIKE '%exapr%' AND `sms_link` !=''"),0);
 

  
	$json = json_encode(["execomCount" => $prfExecomCount]);
    
}
   
echo $json;
 
 
?>