ora 8i 例子
<?$connection = OCILogon ("scott", "tiger","web_oa") or die(OCIError($connection));
$query = "select * from emp order by empno desc";
$cursor = OCIParse ($connection, $query) or die(OCIError($connection));$result = OCIExecute ($cursor) or die(OCIError($connection));echo "<table width='100%' border='1' cellspacing='0' cellpadding='0' bordercolorlight='#000000' bordercolordark='#FFFFFF' bgcolor='#CCCCFF'>\n";
echo "<tr bgcolor='#aaaaFF'><td>编号</td><td>姓名</td><td>工作</td></tr>\n";
while (OCIFetchInto ($cursor, $values))
{
echo "<tr>\n";
for($i=0;$i<3;$i++)
{
echo "<td>$values[$i]</td>\n";
}
echo "</tr>\n";
}
echo "</table>";
OCICommit ($connection);
OCILogoff ($connection);?>
<?$connection = OCILogon ("scott", "tiger","web_oa") or die(OCIError($connection));
$query = "select * from emp order by empno desc";
$cursor = OCIParse ($connection, $query) or die(OCIError($connection));$result = OCIExecute ($cursor) or die(OCIError($connection));echo "<table width='100%' border='1' cellspacing='0' cellpadding='0' bordercolorlight='#000000' bordercolordark='#FFFFFF' bgcolor='#CCCCFF'>\n";
echo "<tr bgcolor='#aaaaFF'><td>编号</td><td>姓名</td><td>工作</td></tr>\n";
while (OCIFetchInto ($cursor, $values))
{
echo "<tr>\n";
for($i=0;$i<3;$i++)
{
echo "<td>$values[$i]</td>\n";
}
echo "</tr>\n";
}
echo "</table>";
OCICommit ($connection);
OCILogoff ($connection);?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货