¿À¶óŬ Ç¥ÁØ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);
|
|
|