PHP与Oracle的调用

发布网友 发布时间：2022-04-08 04:06

我来回答

共2个回答

懂视网 时间：2022-04-08 08:27

function Query($sql,$prms){ $db = " (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX)(PORT = 1521)) (CONNECT_DATA = (SID=orcl) (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )"; $db_uname = "xxx"; $db_upass = "XXXXXX"; $conn = oci_connect($db_uname, $db_upass, $db); $stmt = oci_parse($conn, $sql); if(is_array($prms)){ foreach ($prms as $key => $val){ oci_bind_by_name($stmt, $key, $val); } } oci_execute($stmt, OCI_DEFAULT); $rownum = oci_fetch_all($stmt, $result); oci_free_statement($stmt); oci_close($conn); return $result; } function BeginTran(){ $db = " (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX)(PORT = 1521)) (CONNECT_DATA = (SID=orcl) (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )"; $db_uname = "xxx"; $db_upass = "xxx"; $conn = oci_connect($db_uname, $db_upass, $db); return $conn; } function CloseConn($conn){ oci_close($conn); } function Commit($conn){ oci_commit($conn); CloseConn($conn); } function RollBack($conn){ oci_rollback($conn); CloseConn($conn); } ?>

<?php
require ‘db.php‘;
// $res = Query("select * from customerinfo where rownum < 100", null);
// for($i = 0;$i< 99;$i++){
// foreach ($res as $data){
//  echo $data[$i];
// }
// }

$sql = "insert into hostparam (paramtype,paramvalue) values (:ptype,:pval)";
$conn = BeginTran();
$num = 0;
try {
 $stmt = oci_parse($conn, $sql);
 $ptype = "1";
 $pval = "2";
 oci_bind_by_name($stmt, ":ptype", $ptype);
 oci_bind_by_name($stmt, ":pval", $pval);
 oci_execute($stmt,OCI_DEFAULT);
 $num = oci_num_rows($stmt);
 Commit($conn);
} catch (Exception $e) {
 RollBack($conn);
}
echo $num;
?>

 

php实现oracle操作

标签：

热心网友 时间：2022-04-08 05:35

写个方法，分隔这几个字符串为数组，然后计算数据长度，有45 ID了，就取出对应的就可以。

使用到的函数： explode(直接得到的就是数组)、count、array[45]
function QS_AR_ID($id,$searchid){
$arrayid = explode("|",$id);

$ctarr = count($arrayid);

if($ctarr>$searchid){

echo $arrayid [$searchid];
}
}