1<?php
2
3class Oracle {
4
5 function connect($username, $password, $dbname, $charset='ZHS16GBK',$pconnect='1') {
6 if($pconnect) {
7 $conn = oci_pconnect($username, $password, $dbname, $charset);
8 }else {
9 $conn = oci_connect($username, $password, $dbname, $charset);
10 }
11
12 if(!$conn) {
13 echo "连接Oracle出错";
14 exit();
15 } else {
16 return $conn;
17 }
18 }
19
20 function query($conn,$sql) {
21 $query = oci_parse($conn,$sql);
22 oci_execute($query);
23 return $query;
24 }
25
26 function fetch_array($query,$type=OCI_ASSOC) {
27 return @oci_fetch_array($query,$type);
28
29 }
30
31 function db_count($query){
32 oci_fetch($query);
33 $count = oci_result($query,1);
34 return $count;
35 }
36
37 function close($conn) {
38 $re = oci_close($conn);
39 return $re;
40 }
41
42 function result($query){
43 oci_fetch($query);
44 return oci_result($query,1);
45 }
46
47}
48
49?>
posted on 2007-06-07 12:53
Maple-x 阅读(1236)
评论(0) 编辑 收藏 引用 网摘