File: db_oracle.php

package info (click to toggle)
phpreports 0.4.9-2
  • links: PTS
  • area: main
  • in suites: lenny, squeeze
  • size: 684 kB
  • ctags: 1,426
  • sloc: php: 3,377; xml: 203; makefile: 29; sql: 18; sh: 17; python: 10
file content (44 lines) | stat: -rwxr-xr-x 840 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<?php
	class PHPReportsDBI {
		function db_connect($oArray) {
			return ociPLogon($oArray[0], $oArray[1], $oArray[2]);
		}

		function db_select_db($sDatabase) {
			return null;
		}

		function db_query($oCon,$sSQL) {
			$oStmt = ociParse($oCon,$sSQL);
			ociExecute($oStmt);
			return $oStmt;
		}

		function db_colnum($oStmt) {
			return ociNumCols($oStmt);
		}

		function db_columnName($oStmt,$iPos) {
			return ociColumnName($oStmt,$iPos);
		}
		
		function db_columnType($oStmt,$iPos) {
			return ociColumnType($oStmt,$iPos);
		}

		function db_fetch($oStmt) {
			$aArray = Array();
			if(!@ociFetchInto($oStmt,&$aArray,OCI_ASSOC+OCI_RETURN_NULLS))
				return false;
			return $aArray;
		}

		function db_free($oStmt) {
			return ociFreeStatement($oStmt);
		}

		function db_disconnect($oCon) {
			return ociLogoff($oCon);
		}
	}	
?>