Re: [PHP4BETA] OCIParse & OCIExecute
| From: | Vadim Tkachenko | Date: | Fri, 21 Apr 2000 11:15:18 +0000 |
| Subject: | Re: [PHP4BETA] OCIParse & OCIExecute | ||
| References: | 1 2 3 4 5 | Groups: | php.version4 |
| Request: | Send a blank email to php-version4+get-13876@lists.php.net to get a copy of this message | ||
I try this script on my DB -
result :
from table MANUF - No records found;
from table EMP - EMP SMITH;
My table MANUF -
CREATE TABLE MANUF
VEND_CODE CHAR (6) NOT NULL,
VEND_NAME CHAR (40) NOT NULL,
PRIMARY KEY ( VEND_CODE )
)
INSERT INTO MANUF VALUES ('P-3','My Company');
----------------------------------------------------------------------------
---------------------
$stmt=OCIParse($c1,"SELECT VEND_CODE,VEND_NAME FROM MANUF WHERE
VEND_CODE=:vendcod");
OCIDefineByName($stmt,"VEND_CODE",&$VEND_CODE);
OCIDefineByName($stmt,"VEND_NAME",&$VEND_NAME);
OCIBindByName($stmt,":vendcod",&$vendcod,32);
$vendcod="P-3";
OCIExecute($stmt);
if (OCIFetch($stmt)){
echo "Found record!\n";
echo "$VEND_CODE $VEND_NAME\n";
}else {
echo "No record Found!\n";
};
OCIFreeStatement($stmt);
$stmt=OCIParse($c1,"SELECT EMPNO,ENAME FROM EMP WHERE ENAME=:empname");
OCIDefineByName($stmt,"EMPNO",&$EMPNO);
OCIDefineByName($stmt,"ENAME",&$ENAME);
OCIBindByName($stmt,":empname",&$empname,32);
$empname="SMITH";
OCIExecute($stmt);
if (OCIFetch($stmt)){
echo "Found record!\n";
echo "$EMPNO $ENAME\n";
}else {
echo "No record Found!\n";
};
OCIFreeStatement($stmt);