Join the Team
INAN Database FunctionalityThis is a brief outline of the current state of the database functionality implemented in INAN in the file database.inc. Only features that have actually been coded are listed. I have adopted the convention gDB$foo for assigning names to database functions, where $foo is derived from PHP function names for a given action.
I have ported, for the moment, the operations common to MS SQL, MySQL, and PostgreSQL. I am aware that there are far more MySQL operations supported by PHP than appear in this list, and there are some odd PostgreSQL bits dealing with large object support that are not here, either. Note also that there are a few MS SQL functions in PHP that I have not coded b/c their analogues do not appear in MySQL or PostgreSQL.
Key : MY = MySQL, MS = MS SQL Server, PG = PostgreSQL.
(1) The pg_Fetch_Row() function serves the same role for PostgreSQL databases that the _data_seek() functions perform for MS SQL and MySQL. gDBDataSeek will work correctly if you are using Postgres because it calls pg_Fetch_Row(). In short, gDBFetchRow() and gDBDataSeek() should return identical results when you are using Postgres.
(2) PostgreSQL does not have a statement equivalent to the _fetch_field() action supported by MS SQL and MySQL. If you forget and call gDBFetchField() with your database type set to pgsql, the function will return an error.
(3) The PHP function for MS SQL databases does not allow you to specify an object type for the return value from _fetch_object(). If you try and pass two arguments to gDBFetchObject() when your database type is mssql, the second argument will be ignored.
(4) PostgreSQL support in PHP 4.0.2 does not support a _select_db()-type function. If you forget this and call gDBSelectDB(), it will return a "nice" error message.
Questions? Comments? Flame to spit or venom to spew? Send e-mail to the author!