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