<HTML>

<BODY>

<H1>PHP3 mit Oracle</H1>


SELECT * from TEST;
<P>

Ergebnis: <TABLE BORDER=1>
<TR><TH>int

    <?php

    putenv( "ORACLE_SID=rfhs8012_ora9i");
    putenv( "ORACLE_HOME=/soft/oracle-9.0.1");

    $handle = ora_plogon( "feyrer@rfhs8012_ora9i",  "feyrer")
		or die;
    $cursor = ora_open($handle);
    ora_commitoff($handle);

    $query =  "SELECT * FROM test";
    ora_parse($cursor, $query) or die;
    ora_exec($cursor);

    $numcols = 0;
    while(ora_fetch($cursor)) {
        $numcols = ora_numcols($cursor);
        for ($column=0; $column < $numcols; $column++) {
            $data = trim(ora_getcolumn($cursor, $column));
            if($data ==  "") $data =  "NULL";
            echo  "<TR><TD>$data</TD>";
        }
        echo  "</TR>\n";
    } 
    $numrows = ora_numrows($cursor);
    echo  "\n</TABLE><P>\n";
    echo "ROWS RETURNED: $numrows<P>\n";

    ora_close($cursor);

    ?>
<HR>
Hubert Feyrer, 19990417
</BODY>
</HTML>
