예제 #1
0
 function getConn($name, $rw)
 {
     if (!in_array($name, $this->ar_name)) {
         $conn = $rw ? pg_connect("dbname={$name} user=dbguest password="******"dbname={$name}");
         if ($conn) {
             $this->ar_conn["{$name}"] = $conn;
             $this->ar_name[] = $name;
             return $conn;
         } else {
             return 0;
         }
     } else {
         return $this->ar_conn["{$name}"];
     }
 }
예제 #2
0
function authnk8($db, $tabl, $ar, $db2)
{
    global $conn;
    $conn = pg_connect('dbname=' . $db);
    if (!$conn) {
        return 0;
    } else {
        if (!$db2) {
            $db2 = $db;
        }
        $SQL = "SELECT * FROM {$tabl} WHERE ";
        $ad = 0;
        while (list($k, $v) = each($ar)) {
            if ($ad) {
                $SQL .= 'AND ';
            }
            $x = pg_escape_string($v);
            $SQL .= " {$k}='{$x}' ";
            $ad = 1;
        }
        $SQL .= ';';
        $r = newQuery($SQL, 0);
        $n = pg_num_rows($r);
        pg_free_result($r);
        pg_close($conn);
        if ($n > 0) {
            $conn = pg_connect("dbname={$db2} user=dbguest password="******"dbname={$db2}");
            return 1;
        }
    }
}