php 与 oracle11g 基本操作

来源：互联网发布：剑三怎么导出脸型数据编辑：程序博客网时间：2024/05/21 07:26

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