PHP and PostgreSQL - Surfing The Web (
Page 9 of 9 )
And that's about all for the moment.
In this article, you learned how to use PHP to communicate with that other
open-source RDBMS, PostgreSQL, applying PHP's built-in functions to extract and
insert data into a PostgreSQL table. In addition to learning a number of
different techniques to extract data, you also got a quick tour of how to use
transactions with PostgreSQL, and of the error-handling functions available to
help you debug your PHP/PostgreSQL scripts.
Needless to say, there's a
lot more you can do with PostgreSQL - this article merely covered the basics. If
you're interested in learning more about PostgreSQL features, and in the PHP
functions that can be used to avail of those features, take a look at the links
below.
The PHP manual page for PostgreSQL functions, at
http://www.php.net/manual/en/ref.pgsql.phpThe
PostgreSQL documentation, at
http://www.postgresql.org/idocs/O'Reilly's
article on PHP and PostgreSQL, at
http://www.onlamp.com/pub/a/onlamp/2002/01/24/postgresql.htmlAnd
until next time....stay healthy!
Note: All examples in this article have
been tested on Linux/i586 with PostgreSQL 7.1, Apache 1.3.20 and PHP 4.2.0RC2.
Examples are illustrative only, and are not meant for a production environment.
Melonfire provides no warranties or support for the source code described in
this article. YMMV!
