hr-web/inc/conn.php

<?php
        include("inc/class.DBI");
        include("inc/stuff.php");
        function DBOpen($db = "education", $user = "dpavlin", $pass = "", $host = "") {
                global $DBD, $DBH;
                if ($DBH && $DBH->dbh) return;
                $str = "dbi:$DBD:$db";
                if ($host) $str .= ";host=$host";
                $DBH = new DBI($str, $user, $pass);
                if (!$DBH->dbh) {
                        $err = "";
                        if ($DBH) $DBH->errstr;
                        if (!$err) $err = "???";
                        echo "<PRE>[Cannot connect to &quot;$db&quot;: $err]</PRE><BR>\n";
                        unset($GLOBALS['DBH']);
                        exit;
                }
                $DBH->dbh_do("SET DATESTYLE='ISO'");
        }
        function DBClose() {
                global $DBH;
                if (!$DBH || !$DBH->dbh) return;
                $DBH->disconnect();
                unset($GLOBALS['DBH']);
        }
        function &DBQuery($q) {
                global $DBH;
                if (!$DBH || !$DBH->dbh) return array();
                $DBH->errstr = "";
                $ret = array();
                // Win1250 -> ISO8859-2
                $q = strtr($q, "ðèæÐÈÆ", "¹ðèæ¾©ÐÈÆ®");
                #echo "<tt>[$q]</tt><br>\n";
                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	dpavlin	1.1	<?php
2			include("inc/class.DBI");
3			include("inc/stuff.php");
4	dpavlin	1.5	function DBOpen($db = "education", $user = "dpavlin", $pass = "", $host = "") {
5	dpavlin	1.1	global $DBD, $DBH;
6			if ($DBH && $DBH->dbh) return;
7	dpavlin	1.4	$str = "dbi:$DBD:$db";
8			if ($host) $str .= ";host=$host";
9			$DBH = new DBI($str, $user, $pass);
10	dpavlin	1.1	if (!$DBH->dbh) {
11	dpavlin	1.4	$err = "";
12			if ($DBH) $DBH->errstr;
13	dpavlin	1.1	if (!$err) $err = "???";
14	dpavlin	1.4	echo "<PRE>[Cannot connect to "$db": $err]</PRE><BR>\n";
15			unset($GLOBALS['DBH']);
16			exit;
17	dpavlin	1.1	}
18			$DBH->dbh_do("SET DATESTYLE='ISO'");
19			}
20			function DBClose() {
21			global $DBH;
22			if (!$DBH \|\| !$DBH->dbh) return;
23			$DBH->disconnect();
24	dpavlin	1.4	unset($GLOBALS['DBH']);
25	dpavlin	1.1	}
26			function &DBQuery($q) {
27			global $DBH;
28			if (!$DBH \|\| !$DBH->dbh) return array();
29	dpavlin	1.4	$DBH->errstr = "";
30	dpavlin	1.1	$ret = array();
31	ravilov	1.6	// Win1250 -> ISO8859-2
32			$q = strtr($q, "ðèæÐÈÆ", "¹ðèæ¾©ÐÈÆ®");
33	ravilov	1.7	#echo "<tt>[$q]</tt><br>\n";
34	dpavlin	1.1	if (eregi('^\s*SELECT', $q)) {
35			$sth = $DBH->prepare($q);
36			if (!$sth) return array();
37			$sth->execute();
38			$ret = array();
39			while ($row = $sth->fetchrow_array())
40			array_push($ret, $row);
41			$sth->finish();
42	ravilov	1.6	} else array_push($ret, $DBH->dbh_do($q));
43	dpavlin	1.1	return $ret;
44			}
45			?>