Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* connection */
- $gaSql['user'] = $dbuname;
- $gaSql['password'] = $dbpass;
- $gaSql['db'] = $dbname;
- $gaSql['server'] = $dbhost;
- $gaSql['link'] = pg_connect(
- " host=".$gaSql['server'].
- " dbname=".$gaSql['db'].
- " user=".$gaSql['user'].
- " password=".$gaSql['password']
- ) or die('Could not connect: ' . pg_last_error());
- /* query */
- $sQuery = "SELECT * FROM person";
- $rResult = pg_query( $gaSql['link'], $sQuery ) or die(pg_last_error());
- $iTotal = pg_num_rows($rResult);
- while ( $aRow = pg_fetch_array($rResult, null, PGSQL_ASSOC) ) {
- //do something...
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement