Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- 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){
- global $cn;
- pg_query_params($cn,$sql,$param);
- return pg_fetch_all($res);
- //pg_fetch_all : ambil semua nilai
- }
- /*function getAll ($sql){
- $res=mysql_query($sql);
- $ret=array();
- while($row=mysql_fetch_row($res)){
- $ret[]=$row;
- }
- return $ret;
- }*/
- print_r(
- getAll
- ('SELECT * FROM xuser WHERE za=$1'
- , array(1)
- )
- );
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement