php 与 oracle11g 基本操作

数据表,sequence,触发器创建：http://blog.csdn.net/e421083458/article/details/8944164

<?php
$conn = oci_connect('SCOTT', 'TIGER', '192.168.1.244:1521/orcl'); // 建立连接
if(!$conn){
$e = oci_error();
print htmlentities($e['message']);
exit;
}
//查询数据
$query = 'select * from EXAMPLE order by id desc';
$rs = oci_parse($conn,$query);
if(!$rs){
$e = oci_error($conn);
print htmlentities($e['message']);
exit;
}
$result = oci_execute($rs,OCI_DEFAULT);
if(!$result){
$e = oci_error($result);
echo htmlentities($e['message']);
exit;
}
//打印执行结果
print '<table border="1">';
while($row = oci_fetch_array($rs, OCI_RETURN_NULLS)) {
print '<tr>';
foreach($row as $item){
print '<td>'.($item?htmlentities($item):'').'</td>';
}
print '</tr>';
}
print '</table>';

//插入数据方式一：
$query = "INSERT INTO EXAMPLE(name,phone,address)values('1111','22222','444444')";
$rs = oci_parse($conn,$query);
$t1 = xdebug_time_index();
for($i=0;$i<1;$i++){
oci_execute($rs);//默认方式直接上传
}
$t2 = xdebug_time_index();
print ($t2-$t1);


//插入数据方式二：
$query = "INSERT INTO EXAMPLE(name,phone,address)values('1111','22222','444444')";
$rs = oci_parse($conn,$query);
$result = oci_execute($rs,OCI_DEFAULT);//默认方式直接上传
print_r($result);
if(!$result){
oci_rollback($conn);
oci_close($conn);
}
oci_commit($conn);


oci_close($conn);
?>