php 操作postgresql

最新推荐文章于 2023-05-30 16:07:52 发布

iteye_8353

最新推荐文章于 2023-05-30 16:07:52 发布

阅读量214

点赞数

分类专栏： postgresql 文章标签： PHP PostgreSQL

postgresql 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

<?php
# $id = $_GET['id'];  
# $db = pg_connect("host=localhost dbname=test user=postgres password=test");  
# $query = 'SELECT * FROM test where id='.$id;  
# $result = pg_query($query) or die('Query failed: ' . pg_last_error());  
# echo "<table>\n";  
# while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {  
#     echo "\t<tr>\n";  
#     foreach ($line as $col_value) {  
#         echo "\t\t<td>$col_value</td>\n";  
#     }  
#     echo "\t</tr>\n";  
# }  
#  
# echo "</table>\n";  
# pg_free_result($result);  
# pg_close($db);  

if(isset($_GET['id'])){
	$id=$_GET['id'];

}else{

	$id=1;
}

$db=pg_connect("host=192.168.1.105  dbname=test  user=postgres  password=test");

$query='select *  from test where  id='.$id;

echo "<hr/>";
echo 'id=';
echo "<br/>";
echo 'id='.$id;
echo "<br/>";
echo $query;
echo "<hr/>";
$result=pg_query($query) or die('Query  failed:'.pg_last_error());
echo "<table>\n";
while ($line=pg_fetch_array($result,null,PGSQL_ASSOC)){
	echo "\t <tr>\n";
	foreach ($line as $col_value) {
		echo "\t\t<td>$col_value</td>\n";  

	}
	echo "\t</tr>\n"; 

}
echo "</table>\n";  
pg_free_result($result);
pg_close($db);

?>

[size=x-small][/size]