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