数据表,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); ?>