<?
    session_start();
    $cn = pg_connect("host=localhost port=5432 dbname=james user=james password=james");
    if(!$cn)
    {
        die('failed to connect to database');
    }

    $s=&$_SESSION;
    $p=&$_POST;
    $g=&$_GET;
    $f=&$_FILES;

    //ngambil semua
    //ngambil satu baris
    //ngambil satu nilai
    //melakukan querry begitu saja

    function getAll ($sql,$param=array()){ //ambil semua baris
        global $cn;
        //global $cn : fungsi ini bisa mengakses variabel2 yang di luar fungsi
        $res=pg_query_params($cn,$sql,$param);
        if($res) return pg_fetch_all($res);
        return array();
        //pg_fetch_all : ambil semua nilai
    }

    function getLine($sql,$param=array()){ //ambil 1 baris pertama
        global $cn;
        $res = pg_query_params($cn,$sql,$param);
        if($res) return pg_fetch_assoc($res);
        return array();
    }

    function getOne($sql,$param=array()){ //ambil 1 nilai
        global $cn;
        $res = pg_query_params($cn,$sql,$param);
        if($res){
            $row=pg_fetch_row($res);
            if(isset($row[0])) return $row[0];
        }
        return false;
    }

    //pg_fetch_array : mengambil hasil berdasarkan index SELECT maupun nama SELECT ; contoh : $row[1];

    //pg_fetch_assoc , contoh : $row['nama'];

    /*function getAll ($sql){
        $res=mysql_query($sql);
        $ret=array();
        while($row=mysql_fetch_row($res)){
            $ret[]=$row;
        }
        return $ret;
    }*/

    /*pg_query_params($cn
                    ,'SELECT * FROM xuser WHERE za=$1 or znama=$2'
                    ,array($x,$y)
                    );*/

    print_r(
        getAll
        ('SELECT * FROM xuser WHERE za=$1'
        , array(1)
        )
    );


?>