Advertisement
Guest User

Untitled

a guest
Nov 11th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. /* connection */
  2. $gaSql['user'] = $dbuname;
  3. $gaSql['password'] = $dbpass;
  4. $gaSql['db'] = $dbname;
  5. $gaSql['server'] = $dbhost;
  6.  
  7. $gaSql['link'] = pg_connect(
  8. " host=".$gaSql['server'].
  9. " dbname=".$gaSql['db'].
  10. " user=".$gaSql['user'].
  11. " password=".$gaSql['password']
  12. ) or die('Could not connect: ' . pg_last_error());
  13.  
  14.  
  15. /* query */
  16. $sQuery = "SELECT * FROM person";
  17.  
  18. $rResult = pg_query( $gaSql['link'], $sQuery ) or die(pg_last_error());
  19.  
  20. $iTotal = pg_num_rows($rResult);
  21.  
  22. while ( $aRow = pg_fetch_array($rResult, null, PGSQL_ASSOC) ) {
  23. //do something...
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement