Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- extension=pdo_pgsql
- extension=pgsql
- sudo systemctl restart apache2
- ;extension=bz2
- ;extension=curl
- ;extension=fileinfo
- ;extension=gd2
- ;extension=gettext
- ;extension=gmp
- ;extension=intl
- ;extension=imap
- ;extension=interbase
- ;extension=ldap
- ;extension=mbstring
- ;extension=exif ; Must be after mbstring as it depends on it
- ;extension=mysqli
- ;extension=oci8_12c ; Use with Oracle Database 12c Instant Client
- ;extension=odbc
- ;extension=openssl
- ;extension=pdo_firebird
- ;extension=pdo_mysql
- ;extension=pdo_oci
- ;extension=pdo_odbc
- extension=pdo_pgsql
- ;extension=pdo_sqlite
- extension=pgsql
- ;extension=shmop
- ;extension=bz2
- ;extension=curl
- ;extension=fileinfo
- ;extension=gd2
- ;extension=gettext
- ;extension=gmp
- ;extension=intl
- ;extension=imap
- ;extension=interbase
- ;extension=ldap
- ;extension=mbstring
- ;extension=exif ; Must be after mbstring as it depends on it
- ;extension=mysqli
- ;extension=oci8_12c ; Use with Oracle Database 12c Instant Client
- ;extension=odbc
- ;extension=openssl
- ;extension=pdo_firebird
- ;extension=pdo_mysql
- ;extension=pdo_oci
- ;extension=pdo_odbc
- extension=pdo_pgsql
- ;extension=pdo_sqlite
- extension=pgsql
- ;extension=shmop
- <?php
- $params = [
- 'host' => '[IP Address]',
- 'user' => '[username]',
- 'pwd' => '[password]',
- 'db' => '[dbname]'
- ];
- $dsn = sprintf('pgsql:host=%s;dbname=%s;user=%s;password=%s',
- $params['host'],
- $params['db'],
- $params['user'],
- $params['pwd']);
- try {
- $dsn = sprintf('pgsql:host=%s;dbname=%s;unix_socket=%s',
- $params['host'], $params['db'], $params['sock']);
- $opts = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION];
- $pdo = new PDO($dsn, $params['user'], $params['pwd'], $opts);
- } catch (PDOException $e) {
- echo $e->getMessage();
- } catch (Throwable $e) {
- echo $e->getMessage();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement