Re: [PHP4BETA] OCI8 and PHP4

i've already found the script - works fine with the current CVS of php4 - told the user to a) use current CVS, or b) wait for b3 tc On Fri, 1 Oct 1999, Paul Dumais wrote: > >> 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 > > > -- > PHP 4 Beta > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany