php连接与操作PostgreSQL数据库的方法

本文实例讲述了php连接与操作PostgreSQL数据库的方法。分享给大家供大家参考。

具体实现方法如下:


$pg=@pg_connect("host=localhost user=postgres password=sa dbname=employes") 

or die("can't connect to database."); 

$query="select * from employes order by serial_no"; 

//$query="insert into employes values(10008,'susan','1985-09-04','80','50')"; 

$result=@pg_query($pg,$query) or die("can't run query to table."); 

//echo pg_num_rows($result); //输出多少条记录被查询 

//if($result) 

//{ 

//echo "recrods inserted sucessfully!"; 

//echo pg_affected_rows($result);//输出多少条记录被插入 

//} 

//实例一[pg_fetch_row] 

echo "<table border=1>"; 

echo "<tr>"; 

echo "<td>serial_no</td>"; 

echo"<td>name</td>"; 

echo"<td>birthday</td>"; 

echo"</tr>"; 

for($i=0;$i<pg_num_rows($result);$i++) 

{ 

$row=@pg_fetch_row($result) or die("can't fetch row from table."); 

$serial_no= $row[0]; 

$name= $row[1]; 

$birthday= $row[2]; 

echo"<tr>"; 

echo"<td>$serial_no</td>"; 

echo"<td>$name</td>"; 

echo"<td>$birthday</td>"; 

echo"</tr>"; 

} 

echo"</table>"; 

//实例二[pg_fetch_array] 

//echo "<table border=1>"; 

//echo "<tr>"; 

//echo "<td>serial_no</td>"; 

//echo"<td>name</td>"; 

//echo"<td>birthday</td>"; 

//echo"</tr>"; 

// 

//for($i=0;$i<pg_num_rows($result);$i++) 

//{ 

// 

//$row=@pg_fetch_array($result) or die("can't fetch row from table."); 

//$serial_no= $row['serial_no']; 

//$name= $row['name']; 

//$birthday= $row['birthday']; 

//echo"<tr>"; 

//echo"<td>$serial_no</td>"; 

//echo"<td>$name</td>"; 

//echo"<td>$birthday</td>"; 

//echo"</tr>"; 

// 

//} 

//echo"</table>"; 

//增加,删除,修改实例 

//$newrow=array("serial_no"=>"1006","name"=>"peter","birthday"=>"1990-07-03","salary"=>"90","bonus"=>"80"); 

//$reusult=@pg_insert($pg,"employes",$newrow) or die("can't insert data to table.");

//if($reusult) 

//{ 

//echo "rechords inserted sucessfully!"; 

//} 

// 

pg_close($pg);

希望本文所述对大家的PHP程序设计有所帮助。