Programming w/ PHP ～ PostgreSQL への接続

Computer

メモ

<?php
$host   = "";
$dbname = "";
$user   = "";
$passwd = "";

$conn = pg_connect("host=$host dbname=$dbname user=$user password=$passwd");

if (!$conn) {
  $error = pg_last_error(); // エラーの取得
  echo "接続失敗";
  exit;
}

$query = "SELECT * FROM xxx;";
$result = pq_query($conn, $query);

while ($row = pg_fetch_assoc($result)) {
  echo $row['column'] . "<br>";
}

pg_close($conn);
?>