hr-web/inc/conn.php

<?php
        include("inc/class.DBI");
        include("inc/stuff.php");
        function DBOpen($db = "education", $user = "dpavlin", $pass = "") {
                global $DBD, $DBH;
                if ($DBH && $DBH->dbh) return;
                $DBH = new DBI("dbi:$DBD:$db", $user, $pass);
                if (!$DBH->dbh) {
                        $err = $DBH->errstr;
                        if (!$err) $err = "???";
                        echo "[Cannot connect to &quot;$db&quot;: $err]<BR>\n";
                        unset($DBH);
                }
                $DBH->dbh_do("SET DATESTYLE='ISO'");
        }
        function DBClose() {
                global $DBH;
                if (!$DBH || !$DBH->dbh) return;
                $DBH->disconnect();
                unset($DBH);
        }
        function &DBQuery($q) {
                global $DBH;
                if (!$DBH || !$DBH->dbh) return array();
                $ret = array();
                if (eregi('^\s*SELECT', $q)) {
                        $sth = $DBH->prepare($q);
                        if (!$sth) return array();
                        $sth->execute();
                        $ret = array();
                        while ($row = $sth->fetchrow_array())
                                array_push($ret, $row);
                        $sth->finish();
                } else
                        array_push($ret, $DBH->dbh_do($q));
                return $ret;
        }
?>
1	<?php
2	include("inc/class.DBI");
3	include("inc/stuff.php");
4	function DBOpen($db = "education", $user = "dpavlin", $pass = "") {
5	global $DBD, $DBH;
6	if ($DBH && $DBH->dbh) return;
7	$DBH = new DBI("dbi:$DBD:$db", $user, $pass);
8	if (!$DBH->dbh) {
9	$err = $DBH->errstr;
10	if (!$err) $err = "???";
11	echo "[Cannot connect to "$db": $err]<BR>\n";
12	unset($DBH);
13	}
14	$DBH->dbh_do("SET DATESTYLE='ISO'");
15	}
16	function DBClose() {
17	global $DBH;
18	if (!$DBH \|\| !$DBH->dbh) return;
19	$DBH->disconnect();
20	unset($DBH);
21	}
22	function &DBQuery($q) {
23	global $DBH;
24	if (!$DBH \|\| !$DBH->dbh) return array();
25	$ret = array();
26	if (eregi('^\s*SELECT', $q)) {
27	$sth = $DBH->prepare($q);
28	if (!$sth) return array();
29	$sth->execute();
30	$ret = array();
31	while ($row = $sth->fetchrow_array())
32	array_push($ret, $row);
33	$sth->finish();
34	} else
35	array_push($ret, $DBH->dbh_do($q));
36	return $ret;
37	}
38	?>