psql與php

<?php
 // 串連，選擇資料庫
 $dbconn = pg_connect("host=192.168.1.254 dbname=jz user=postgres password=123456 port=5432")
 or die('Could not connect: ' . pg_last_error());

 if($dbconn)
 {
 print "OK! Has connected" . "<br>";
 }
 else
 {
 print "Error! Connect failure" . "<br>";
 }

 // 執行 SQL 查詢
 //$query = "SELECT id,title,code_list FROM article_list_n8 where '600128' =any(code_list) order by id asc limit 10 offset 0";
 $query = "SELECT * FROM article_content where id=11 offset 0 ";

 $result = pg_query($query) or die('Query failed: ' . pg_last_error());

 // 用 HTML 顯示結果

 while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {

 foreach ($line as $col_value) {
 echo $col_value;

 }
 echo "<br/>";
 }

 ?>