//从oracle获取行事历数据
function get_calendar_from_oracle($last_date){
//連接Oracle數據庫kingmes
$conn = oci_connect('fdc','fdc',"(DEscriptION=(ADDRESS=(PROTOCOL =TCP)(HOST=172.16.4.35)(PORT = 1521))(CONNECT_DATA =(SID=kingmes)))", "UTF8");
//檢查是否連接成功
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
echo "<br>--oracle 172.16.4.35連接失敗!--";
return 'connect_fail';
}
//只获取当前月的行事历
$query = "select to_char(AT_DATE,'YYYY/MM/DD HH24:MI:SS'), HOLIDAY_CODE, HOLIDAY_NAME, COMPANY, LAW_HOLIDAY from fnd_company_calendar_v
where AT_DATE>to_date('".$last_date."','YYYY/MM/DD HH24:MI:SS') and TO_CHAR(AT_DATE,'YYYY-MM')=TO_CHAR(SYSDATE,'YYYY-MM') order by at_date ";
$stid = oci_parse($conn, $query); // 配置SQL语句,准备执行
if (!$stid) {
$e = oci_error($conn);
print htmlentities($e['message']);
return 'error';
}
$r = oci_execute($stid, OCI_DEFAULT); // 执行SQL。OCI_DEFAULT表示不要自动commit
if(!$r) {
$e = oci_error($stid);
echo htmlentities($e['message']);
return 'error';
}
$res=array();
$i=0;
while($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
//數組列数
$len=count($row)/2;
$res[$i]=$row;//赋值到数组中
$i++;
}
//關閉連接
oci_close($conn);
return $res;
}
//連接Oracle數據庫kingmes
c o n n = o c i c o n n e c t ( ′ f d c ′ , ′ f d c ′ , " ( D E s c r i p t I O N = ( A D D R E S S = ( P R O T O C O L = T C P ) ( H O S T = 172.16.4.35 ) ( P O R T = 1521 ) ) ( C O N N E C T D A T A = ( S I D = k i n g m e s ) ) ) " , " U T F 8 " ) ; / / 檢查是否連接成功 i f ( ! conn = oci_connect('fdc','fdc',"(DEscriptION=(ADDRESS=(PROTOCOL =TCP)(HOST=172.16.4.35)(PORT = 1521))(CONNECT_DATA =(SID=kingmes)))", "UTF8"); //檢查是否連接成功 if (! co