仅仅实现了query功能.<?
$connection = OCILogon ("scott", "tiger","orcl") 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>num</td><td>name</td><td>work</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","orcl") 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>num</td><td>name</td><td>work</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);?>
只要你连接数据库的用户名有权限建表\删表\改表字段等等,
你就能够利用php中的语句操纵数据库。下面有个小例子:
<?php
...
if($conn!=false)
{
$query = "create table test(t1 varchar2(10),t2 number(5))"; $stmt = OCIParse($conn,$query); if(OCIExecute($stmt))
echo "ok";
else
echo "no";
}
?>
同理所得,把sql语句写在php中就ok了。<?php
...
if($conn!=false)
{
$query = "alter table test modify(t1 varchar2(15))"; $stmt = OCIParse($conn,$query); if(OCIExecute($stmt))
{
echo "ok";
}
else
{
echo "no";
}
?>
pear.php.net的DB类就不错!