php如何连接和操作PostgreSQL数据库
程序员文章站
2022-04-13 17:10:57
...
这篇文章主要介绍了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);
【相关教程推荐】
1. php编程从入门到精通全套视频教程
2. php从入门到精通
3. bootstrap教程
上一篇: etl工作中的设计问题