PHPÁ¬½ÓOracle²¢·ÖÒ³·ÃÎÊ

ʹÓõÄÊÇADODB¿â,ÐèÒªÓÐOCI8¿â.
<?php

//require("adodb5/adodb-exceptions.inc.php");
require("adodb5/adodb.inc.php");
$conn = NewADOConnection("oci8");
$conn->Connect($url, $user, $password, $service_name);
$rs;
try {
$rs = $conn->Execute("SELECT * from (SELECT rownum r,ima_file.* from ima_file) s WHERE s.r >= 9000 AND s.r <= 10000");
} catch(exception $e) {
print_r($e);
}

$i = 0;
echo "<table border=1><caption>IMA_FILE</caption><thead><td>¼ÆÊý</td><td>ÐÐÊý</td><td>ÁϼþºÅ</td><td>Æ·Ãû</td><td>¹æ¸ñ</td></thead>";
foreach($rs as $row) {
echo "<tr><td>" . ++$i . "</td><td>$row[0]</td><td>{$row[1]}</td><td>{$row[2]}</td><td>{$row[3]}</td></tr>";
}
echo "</table>";
?>