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);
?>