corp_html/inc/conn.inc

<?
        require('class.DBI');
        $db="corp";
        $dbh = new DBI("dbi:pg:$db","dpavlin","");

        if (!$WAP && ( strstr($accept,"text/vnd.wap.wml") || strstr($accept,"hdml;version=3.0") ) ) {
                Header("Location: wap.php");
                header("Content-type: text/vnd.wap.wml");
                exit;
        }

        $sql_section="";

        $url=basename($PHP_SELF);
        if ($QUERY_STRING) $url.="?$QUERY_STRING";

        if ($section) $sql_section=" and section='$section'";

        $sth = $dbh->prepare("select item from menu where url = '$url' $sql_section limit 1");
        $sth->execute();
        global $menu_item;
        if ($row=$sth->fetchrow_hash()) {
                $menu_item=$row[0];
        }

        // parse /preview URL

        global $is_preview,$visible_is_true;

        $preview_url="/preview";
        if (substr($GLOBALS[REQUEST_URI],0,strlen($preview_url)) == $preview_url) {
                $is_preview=1;
                $visible_is_true = "true";      // visible can be true or false
        } else {
                $visible_is_true = "visible is true"; // limit output just to visible
        }


?>
1	dpavlin	1.1	<?
2			require('class.DBI');
3			$db="corp";
4			$dbh = new DBI("dbi:pg:$db","dpavlin","");
5
6	dpavlin	1.4	if (!$WAP && ( strstr($accept,"text/vnd.wap.wml") \|\| strstr($accept,"hdml;version=3.0") ) ) {
7	dpavlin	1.2	Header("Location: wap.php");
8	dpavlin	1.3	header("Content-type: text/vnd.wap.wml");
9	dpavlin	1.2	exit;
10			}
11
12	dpavlin	1.6	$sql_section="";
13
14			$url=basename($PHP_SELF);
15			if ($QUERY_STRING) $url.="?$QUERY_STRING";
16
17			if ($section) $sql_section=" and section='$section'";
18
19			$sth = $dbh->prepare("select item from menu where url = '$url' $sql_section limit 1");
20	dpavlin	1.5	$sth->execute();
21			global $menu_item;
22			if ($row=$sth->fetchrow_hash()) {
23			$menu_item=$row[0];
24			}
25
26	dpavlin	1.8	// parse /preview URL
27	dpavlin	1.9
28			global $is_preview,$visible_is_true;
29
30	dpavlin	1.7	$preview_url="/preview";
31	dpavlin	1.8	if (substr($GLOBALS[REQUEST_URI],0,strlen($preview_url)) == $preview_url) {
32			$is_preview=1;
33	dpavlin	1.9	$visible_is_true = "true"; // visible can be true or false
34	dpavlin	1.8	} else {
35	dpavlin	1.9	$visible_is_true = "visible is true"; // limit output just to visible
36	dpavlin	1.8	}
37
38	dpavlin	1.7
39	dpavlin	1.1	?>