Re: [PHP4BETA] OCIParse & OCIExecute
| From: | Vadim Tkachenko | Date: | Fri, 21 Apr 2000 09:55:25 +0000 |
| Subject: | Re: [PHP4BETA] OCIParse & OCIExecute | ||
| References: | 1 2 | Groups: | php.version4 |
| Request: | Send a blank email to php-version4+get-13873@lists.php.net to get a copy of this message | ||
<?
$c1 = ocilogon("xxxxx","xxxx");
echo OCIServerVersion($c1)."\n";
$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-1";
OCIExecute($stmt);
if (OCIFetch($stmt)){
echo "Found record!\n";
echo "$VEND_CODE $VEND_NAME\n";
}else{
echo "Records not Found";
};
OCIFreeStatement($stmt);
OCILogOff($c1);
?>
> please send a complete 20 line testcase of your problem to
> me.
>