Re: [PHP4BETA] OCI8 and PHP4
| From: | Paul Dumais | Date: | Fri, 01 Oct 1999 17:42:10 +0000 |
| Subject: | Re: [PHP4BETA] OCI8 and PHP4 | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-5069@lists.php.net to get a copy of this message | ||
>> On Thu, 30 Sep 1999, Kees Leune wrote:
>>
>> An example can be found on:
>> http://prsrvr:2080/~kees/test.php
>>
>> system info is at
>> http://prsrvr:2080/~kees/php.php
>>
>> Is this a known problem, and if so, can I solve it somehow?
> Then Thies replied:
>
> oci8 works in php4 - confirmed by a lot of people.
>
> i'm sorry http://prsrvr:2080 is nothing i can reach via
> the internet -
> please give us far more deteil (wich version of php4, what configure
> options, what is actually your problem...)
>
>
> regards,
> tc
I did some sleuthing and found his server. The complete URI is
http://prsrvr.kub.nl:2080/~kees/test.php
Here is the contents of test.php
output
<?php
putenv("ORACLE_HOME=/net/prsrvr/srv/home/oracle/product/8.0.5");
$c1 = OCILogon("kees", "cjlkees", "prak");
$stmt = OCIParse($c1, "select title,price from books");
OCIExecute($stmt);
$nrows = OCIFetchStatement($stmt,$results);
if ( $nrows > 0 ) {
print "<TABLE BORDER=\"1\">\n";
print "<TR>\n";
while ( list( $key, $val ) = each( $results ) ) {
print "<TH>$key</TH>\n";
}
print "</TR>\n";
for ( $i = 0; $i < $nrows; $i++ ) {
reset($results);
print "<TR>\n";
while ( $column = each($results) ) {
$data = $column['value'];
print "<TD>$data[$i]</TD>\n";
}
print "</TR>\n";
}
print "</TABLE>\n";
} else {
echo "No data found<BR>\n";
}
print "$nrows Records Selected<BR>\n";
OCIFreeStatement($stmt);
OCILogoff($conn);
echo "<PRE>";
include "query.txt";
?>
--
Paul E. Dumais
Founder / Chief Technologist
MooseFactory.com
323.993.5915