note 515 deleted from ref.oracle by sniper
| From: | sniper@php.net | Date: | Mon, 11 Aug 2003 05:10:07 +0000 |
| Subject: | note 515 deleted from ref.oracle by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-53848@lists.php.net to get a copy of this message | ||
Note Submitter: stevel@nettek-llc.com
----
<?php
<br>
<br>putenv(
"ORACLE_SID=sid1");
<br>putenv(
"ORACLE_HOME=/u01/app/oracle/product/8.0.5");
<br>
<br>$handle = ora_plogon(
"SCOTT@sid1", "TIGER")or die;
<br>$cursor = ora_open($handle);
<br>ora_commitoff($handle);
<br>
<br>$query = "SELECT * FROM EMP";
<br>ora_parse($cursor, $query) or die;
<br>ora_exec($cursor);
<br>
<br>echo "<HTML><PRE>\n";
<br>echo "$query\n\n";
<br>$numcols = 0;
<br>while(ora_fetch($cursor)){
<br> $numcols = ora_numcols($cursor);
<br> for($column=0; $column < $numcols; $column++){
<br> $data = trim(ora_getcolumn($cursor, $column));
<br> if($data =="") $data = "NULL";
<br> echo"$data\t";
<br> }
<br> echo "\n";
<br>}
<br>$numrows = ora_numrows($cursor);
<br>echo "\nROWS RETURNED: $numrows\n";
<br>echo "</PRE></HTML>\n";
<br>
<br>ora_close($cursor);
<br>
<br>?>