Guest User

Untitled

a guest
Dec 26th, 2018
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. function pdo_pgsql($sql){
  2.  
  3. $host = '000.000.000.000';
  4. $user = 'user';
  5. $pass = 'pass';
  6. $db = 'db';
  7.  
  8. try {
  9. $PDO = new PDO( 'pgsql:host=' . $host . ';dbname=' . $db . ';port=5432', $user, $pass, array(
  10. PDO::ATTR_PERSISTENT => true
  11. ));
  12. }
  13. catch ( PDOException $e ) {
  14. echo 'Error: ' . $e->getMessage(); exit;
  15. }
  16.  
  17. $result = $PDO->query( $sql );
  18.  
  19. if (is_array($result)){
  20. $row = $result->fetchAll( PDO::FETCH_ASSOC );
  21. }else{
  22. $row = $result;
  23. }
  24.  
  25. return $row;
  26.  
  27. }
Add Comment
Please, Sign In to add comment