Re: PHP & PostgreSQL
От | Matthew Nuzum |
---|---|
Тема | Re: PHP & PostgreSQL |
Дата | |
Msg-id | 000201c2b00d$e241ed30$6700a8c0@mattspc обсуждение исходный текст |
Ответ на | PHP & PostgreSQL ("Boget, Chris" <chris@wild.net>) |
Список | pgsql-general |
The Adodb database abstraction library is free to use and works very well. I like it even in projects that will only use postgres. It makes programming databases easier, will do a lot of the mundane work for you, and if you have different projects that use different databases, it allows you to use the same adodb commands. You can find all kinds of information about adodb including a function reference, tutorials and download links at http://php.weblogs.com/adodb_manual Keep in mind that this library was originally modeled after Microsofts Ado library. Therefore, it does not bear a strong resemblance to the native php db functions. An interesting side effect though is that I recently had to write a simple Visual Basic application and found that I already knew most of the database stuff because of my php adodb experience. :-) Matthew Nuzum www.followers.net matt@followers.net -----Original Message----- From: Boget, Chris [mailto:chris@wild.net] Sent: Monday, December 30, 2002 5:14 AM To: 'php-general@lists.php.net' Cc: 'pgsql-general@postgresql.org' Subject: PHP & PostgreSQL I'm switching from a MySQL environment to PGSQL and I'm going through and trying to learn the differences between the two. I've come across some issues that I can't seem to find the answers to in the docs or on the web. I'm hoping someone can help me out. * MySQL has a function to reset the result set so that it can be iterated through again - mysql_data_seek(). I don't see that there is a similar function for PGSQL. Is that true? If so, in order to reset the result set you have to perform the query again? Isn't that a waste of resources? * For PGSQL, you can get the database name, the field name even the *host name* but you can't get the table name from a particular query? Any info would be greatly appreciated! Chris
В списке pgsql-general по дате отправления: