group.php-42.htm
来自「php5的最新帮助文档」· HTM 代码 · 共 81 行
HTM
81 行
<html>
<head>
<meta content="text/html; charset=gb2312" http-equiv=Content-Type>
<title>PostgreSQL 数据库函数库</title>
<style type="text/css">
a {text-decoration: none;color:#6666ff;}
a:hover {color:#ff0000;}
</style>
</head>
<body bgcolor=ffffff leftmargin=0 topmargin=0 marginheight=0 marginwidth=0>
<p>
<div align=center><table border=0 width=70%><tr>
<td valign=middle width=20><hr size=1 width=100%></td>
<td valign=middle nowrap><font color=e06060 size=+2><b>PostgreSQL 数据库函数库</b></font></td>
<td valign=middle width=100%><hr size=1 width=100%></td>
</tr></table></div><p>
<div align=center><table border=0 width=70%><tr><td>
<div align=right>本函数库共有 32 个函数</div><p><table border=0 cellpadding=12 cellspacing=0><tr>
<td bgcolor=e0e0ff>Postgres 数据库是由柏克莱大学电脑科学系所开发的数据库系统，为类关联式数据库的先驱。它提供
SQL92/SQL3 语法。PostgreSQL 是公开使用的免费系统。更多细节可在 <a href="http://www.postgresql.org/" tppabs="http://www.postgresql.org/">http://www.PostgreSQL.org</a>
站上看到。
<p> 在 phpWizard.net 网站上也有用 Browser 管理 PostgreSQL 的套装程序 <a href="http://www.phpwizard.net/PostgresAdmin/" tppabs="http://www.phpwizard.net/PostgresAdmin/">PostgresAdmin</a>。可以用它来轻松管理
PostgreSQL 数据库。
<p>
在公元 1998 年的 PostgreSQL 6.3 版之后，可以使用 UNIX 上的 domain sockets。postmaster 加上参数 -i 就可以使用，PostgreSQL 系统会用到 /tmp/.s.PGSQL.5432 的文件。<p>
下面为使用 LOB (Large Object) 的例子<p>
<font color="#000000">
<font color="#0000BB"><?php<br>$database </font><font color="#007700">= </font><font color="#0000BB">pg_Connect </font><font color="#007700">(</font><font color="#DD0000">""</font><font color="#007700">, </font><font color="#DD0000">""</font><font color="#007700">, </font><font color="#DD0000">""</font><font color="#007700">, </font><font color="#DD0000">""</font><font color="#007700">, </font><font color="#DD0000">"jacarta"</font><font color="#007700">);<br></font><font color="#0000BB">pg_exec </font><font color="#007700">(</font><font color="#0000BB">$database</font><font color="#007700">, </font><font color="#DD0000">"begin"</font><font color="#007700">);<br> </font><font color="#0000BB">$oid </font><font color="#007700">= </font><font color="#0000BB">pg_locreate </font><font color="#007700">(</font><font color="#0000BB">$database</font><font color="#007700">);<br> echo (</font><font color="#DD0000">"$oid</font><font color="#007700">\n</font><font color="#DD0000">"</font><font color="#007700">);<br> </font><font color="#0000BB">$handle </font><font color="#007700">= </font><font color="#0000BB">pg_loopen </font><font color="#007700">(</font><font color="#0000BB">$database</font><font color="#007700">, </font><font color="#0000BB">$oid</font><font color="#007700">, </font><font color="#DD0000">"w"</font><font color="#007700">);<br> echo (</font><font color="#DD0000">"$handle</font><font color="#007700">\n</font><font color="#DD0000">"</font><font color="#007700">);<br> </font><font color="#0000BB">pg_lowrite </font><font color="#007700">(</font><font color="#0000BB">$handle</font><font color="#007700">, </font><font color="#DD0000">"gaga"</font><font color="#007700">);<br> </font><font color="#0000BB">pg_loclose </font><font color="#007700">(</font><font color="#0000BB">$handle</font><font color="#007700">);<br></font><font color="#0000BB">pg_exec </font><font color="#007700">(</font><font color="#0000BB">$database</font><font color="#007700">, </font><font color="#DD0000">"commit"</font><font color="#007700">)<br></font><font color="#0000BB">pg_exec </font><font color="#007700">(</font><font color="#0000BB">$database</font><font color="#007700">, </font><font color="#DD0000">"end"</font><font color="#007700">)<br></font><font color="#0000BB">?><br></font>
</font>
</td></tr></table><p>
<table border=0 width=100%><tr><td align=right valign=top><a href="function.php-pg_Close.htm" alt="function.php?pg_Close">pg_Close</a>:</td><td valign=top>关闭 PostgreSQL 服务器连接。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_cmdTuples.htm" alt="function.php?pg_cmdTuples">pg_cmdTuples</a>:</td><td valign=top>取得被 SQL 指令影响的资料笔数。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Connect.htm" alt="function.php?pg_Connect">pg_Connect</a>:</td><td valign=top>打开 PostgreSQL 服务器连接。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_DBname.htm" alt="function.php?pg_DBname">pg_DBname</a>:</td><td valign=top>取得目前的数据库名称。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_ErrorMessage.htm" alt="function.php?pg_ErrorMessage">pg_ErrorMessage</a>:</td><td valign=top>返回错误信息。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Exec.htm" alt="function.php?pg_Exec">pg_Exec</a>:</td><td valign=top>执行 query 指令。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Fetch_Array.htm" alt="function.php?pg_Fetch_Array">pg_Fetch_Array</a>:</td><td valign=top>返回数组资料。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Fetch_Object.htm" alt="function.php?pg_Fetch_Object">pg_Fetch_Object</a>:</td><td valign=top>返回类资料。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Fetch_Row.htm" alt="function.php?pg_Fetch_Row">pg_Fetch_Row</a>:</td><td valign=top>返回单列的各字段。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_FieldIsNull.htm" alt="function.php?pg_FieldIsNull">pg_FieldIsNull</a>:</td><td valign=top>检查字段是否有资料。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_FieldName.htm" alt="function.php?pg_FieldName">pg_FieldName</a>:</td><td valign=top>返回指定字段的名称。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_FieldNum.htm" alt="function.php?pg_FieldNum">pg_FieldNum</a>:</td><td valign=top>取得指定字段的行数。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_FieldPrtLen.htm" alt="function.php?pg_FieldPrtLen">pg_FieldPrtLen</a>:</td><td valign=top>计算可列示的长度。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_FieldSize.htm" alt="function.php?pg_FieldSize">pg_FieldSize</a>:</td><td valign=top>计算指定字段的长度。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_FieldType.htm" alt="function.php?pg_FieldType">pg_FieldType</a>:</td><td valign=top>获得目前字段的类型。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_FreeResult.htm" alt="function.php?pg_FreeResult">pg_FreeResult</a>:</td><td valign=top>释放返回占用内存。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_GetLastOid.htm" alt="function.php?pg_GetLastOid">pg_GetLastOid</a>:</td><td valign=top>取得最后的类代码。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Host.htm" alt="function.php?pg_Host">pg_Host</a>:</td><td valign=top>取得连接机器名称。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_loclose.htm" alt="function.php?pg_loclose">pg_loclose</a>:</td><td valign=top>关闭大型类。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_locreate.htm" alt="function.php?pg_locreate">pg_locreate</a>:</td><td valign=top>建立大型类。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_loopen.htm" alt="function.php?pg_loopen">pg_loopen</a>:</td><td valign=top>打开大型类。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_loread.htm" alt="function.php?pg_loread">pg_loread</a>:</td><td valign=top>读取大型类。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_loreadall.htm" alt="function.php?pg_loreadall">pg_loreadall</a>:</td><td valign=top>读取大型类并输出。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_lounlink.htm" alt="function.php?pg_lounlink">pg_lounlink</a>:</td><td valign=top>删除大型类。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_lowrite.htm" alt="function.php?pg_lowrite">pg_lowrite</a>:</td><td valign=top>读取大型类。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_NumFields.htm" alt="function.php?pg_NumFields">pg_NumFields</a>:</td><td valign=top>取得返回字段的数目。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_NumRows.htm" alt="function.php?pg_NumRows">pg_NumRows</a>:</td><td valign=top>取得返回列的数目。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Options.htm" alt="function.php?pg_Options">pg_Options</a>:</td><td valign=top>取得连接机器选项。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_pConnect.htm" alt="function.php?pg_pConnect">pg_pConnect</a>:</td><td valign=top>打开 PostgreSQL 服务器持续连接。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Port.htm" alt="function.php?pg_Port">pg_Port</a>:</td><td valign=top>取得连接机器埠号。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_Result.htm" alt="function.php?pg_Result">pg_Result</a>:</td><td valign=top>取得查询 (query) 的结果。</td></tr>
<tr><td align=right valign=top><a href="function.php-pg_tty.htm" alt="function.php?pg_tty">pg_tty</a>:</td><td valign=top>取得连接机器终端机。</td></tr>
</table><p><hr size=1><br>如果你对此手册有任何问题,请到下面网址提问: <a href="www.web745.com">WEB开发知识库</a> (<a href="http://www.web745.com">www.web745.com</a>)<p>
</td></tr></table></div>
<p>
<div align=center>
<table border=0>
<tr>
<td>[ <a href="group.php-41.htm" alt="group.php?41">上一页</a>
</td>
<td> <a href="group.php-43.htm" alt="group.php?43">下一页</a>
]</td>
</tr>
</table>
</div><p><br><br>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?