Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function pdo_pgsql($sql){
- $host = '000.000.000.000';
- $user = 'user';
- $pass = 'pass';
- $db = 'db';
- try {
- $PDO = new PDO( 'pgsql:host=' . $host . ';dbname=' . $db . ';port=5432', $user, $pass, array(
- PDO::ATTR_PERSISTENT => true
- ));
- }
- catch ( PDOException $e ) {
- echo 'Error: ' . $e->getMessage(); exit;
- }
- $result = $PDO->query( $sql );
- if (is_array($result)){
- $row = $result->fetchAll( PDO::FETCH_ASSOC );
- }else{
- $row = $result;
- }
- return $row;
- }
Add Comment
Please, Sign In to add comment