اتصال به دیتابیس PostgreSQL در برنامه‌های PHP

PG_URI=postgresql://root:2aCRtMfc2oMou67U2GftmLmd@annapurna.liara.cloud:32655/postgres

<?php
$uri = getenv("PG_URI");

try {
  $uriParts = parse_url($uri);

  $host = $uriParts['host'];
  $port = $uriParts['port'];
  $user = $uriParts['user'];
  $pass = $uriParts['pass'];
  $dbname = ltrim($uriParts['path'], '/');

  // Create a new PDO instance with persistent connection enabled
  $pdo = new PDO(
      "pgsql:host=$host;port=$port;dbname=$dbname",
      $user,
      $pass,
      array(
          PDO::ATTR_PERSISTENT => true
      )
  );

  $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  echo "Connected to PostgreSQL database successfully with persistent connection!";
} catch (PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}
?>