Advertisement
Guest User

Untitled

a guest
Jun 26th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.75 KB | None | 0 0
  1. <?
  2.     session_start();
  3.     $cn = pg_connect("host=localhost port=5432 dbname=james user=james password=james");
  4.     if(!$cn)
  5.     {
  6.         die('failed to connect to database');
  7.     }
  8.    
  9.     $s=&$_SESSION;
  10.     $p=&$_POST;
  11.     $g=&$_GET;
  12.     $f=&$_FILES;
  13.    
  14.     //ngambil semua
  15.     //ngambil satu baris
  16.     //ngambil satu nilai
  17.     //melakukan querry begitu saja
  18.    
  19.     function getAll ($sql){
  20.         global $cn;
  21.         pg_query_params($cn,$sql,$param);
  22.         return pg_fetch_all($res);
  23.         //pg_fetch_all : ambil semua nilai
  24.     }
  25.    
  26.     /*function getAll ($sql){
  27.         $res=mysql_query($sql);
  28.         $ret=array();
  29.         while($row=mysql_fetch_row($res)){
  30.             $ret[]=$row;
  31.         }
  32.         return $ret;
  33.     }*/
  34.    
  35.     print_r(
  36.         getAll
  37.         ('SELECT * FROM xuser WHERE za=$1'
  38.         , array(1)
  39.         )
  40.     );
  41.    
  42.    
  43. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement