<?php
date_default_timezone_set('Asia/Manila');
$sqlUser = 'autoph_arnel';
$sqlDatabase = 'autoph_connect';
$sqlPass = 'Hke@2001';
$toDate = date_create() ->format("m/d/Y"); // for viewing date only

$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(). '.'); 

$reqKey = $_REQUEST['reqSoldKey']; // Expect LoginName, LoginPassword 
$reqEmpID= $_REQUEST['reqSoldEmpID']; // Expect LoginName, LoginPassword  
 
 
 

//====================================================================== 
//======================================================================================================================================================================================================================================
if($reqKey == 110706102477){ 
	
	$return_arr = Array();
   
	$sql = "SELECT * FROM db_vehicle_inventory WHERE `released_by` ='$reqEmpID' AND `sold` = 1 ORDER BY brand_code ASC";
	
	$sqlTable = mysql_query($sql, $conn);
	while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{ 
        $return_arr[]= $sqlRecord;
       
	}
	
	$json = json_encode($return_arr);
	 

	$did_something += 1;
	
    
}
 

 

if($did_something === 0)
{
	$msg = did_nothing_message;
	$json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]);
}
echo $json;
 
 
?>