오라클 표준sql문장 oci 함수이용
#*****************************************************
# SELECT 문 예제
#*****************************************************
$query = " SELECT EMPID, EMPNM FROM EMPTB WHERE EMPID='01' " ;
// echo"<PRE>$query</PRE>";
$stmt = OCIParse($conn,$query);
OCIExecute($stmt,OCI_DEFAULT);
WHILE(OCIFetchInto($stmt,&$col,OCI_ASSOC+OCI_RETURN_NULLS))
{
#*****************************************************
# UPDATE 문 예제
#*****************************************************
$query ="UPDATE EMPTB
SET EMPNM = '홍길동'
WHERE EMPID = '01'
" ;
// echo"<PRE>$query<br></PRE>";
$stmt = OCIParse($conn,$query);
OCIExecute($stmt,OCI_DEFAULT);
OCIFreeStatement($stmt);
#*****************************************************
# INSERT 문 예제
#*****************************************************
$query = "INSERT INTO EMPTB ( EMPID, EMPNM )
VALUES ('$ID','$NAME' )";
$stmt = OCIParse($conn,$query);
OCIExecute($stmt,OCI_DEFAULT);
OCIFreeStatement($stmt);
}
include "database.cfg";
$conn = OCILogon("$db_id","$db_password","$db_sid");
$query = " SELECT EMPID, EMPNM FROM EMPTB WHERE EMPID='01' " ;
// echo"<PRE>$query</PRE>";
// echo"<PRE>$query</PRE>";
$stmt = OCIParse($conn,$query);
OCIExecute($stmt,OCI_DEFAULT);
OCIFetchInto($stmt,&$col,OCI_ASSOC+OCI_RETURN_NULLS) ;
$rh3_useGb = $col[RECNUM] ;
OCIFreeStatement($stmt);
OCILogoff($conn);
|
|
|
