include("globalclass.php");
include("tfcclass.php");
?>
CCHS get card info
if(isset($hidd_oldmfgno))
{
$db="(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 200.1.2.238)(PORT = 1521)))(CONNECT_DATA = (SID = CCHSDEV)))";
$conn=OCILogon("cchs","cchsdev",$db);
$stmt = ociparse($conn,"select carddeposit,cardbal,cardstatus,refillamt,cardno,to_char(cardexpiry,'dd/mm/yyyy') as cardexp from cardmaster where mfgno=$hidd_oldmfgno");
ociexecute($stmt);
while(ocifetch($stmt))
{
$carddeposit=ociresult($stmt,"CARDDEPOSIT");
$cardbal=ociresult($stmt,"CARDBAL");
$cardstatus=ociresult($stmt,"CARDSTATUS");
$cardno=ociresult($stmt,"CARDNO");
$cardexpiry=ociresult($stmt,"CARDEXP");
$refillamt=ociresult($stmt,"REFILLAMT");
}
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
}
?>
CCHS get info Done!