Re: [PHP] Postgresql & PHP

Hello Danny, Tuesday, March 22, 2005, 6:07:55 PM, you wrote: DB> Any recommendations on books for postgresql & PHP usage. Just get a good book on Postgres, the PHP side of it can be easily picked-up from the PHP manual itself. Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP

[PHP] Postgresql & PHP

Any recommendations on books for postgresql & PHP usage. Thanks, Dan. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PostgreSQL/PHP: transactions: how-to abstract out?

You could try leaving off the ";"... Try $sql = "BEGIN" Try $sql = "COMMIT" That should work... On Thu, 2003-01-09 at 22:23, Jean-Christian Imbeault wrote: > Jason Sheets wrote: > > > > Manual Excerpt: " If a second call is made to pg_connect() with the same > > connection_string, no new con

Re: [PHP] PostgreSQL/PHP: transactions: how-to abstract out?

Jean-Christian If you are only doing an insert then you do not need the transactions "BEGIN" and "COMMIT" because that is already done for you on a single insert. PGSQL is transaction based so if it does not go then it will not work. -Ray On Thu, 2003-01-09 at 22:23, Jean-Christian Imbeault wrot

Re: [PHP] PostgreSQL/PHP: transactions: how-to abstract out?

Jason Sheets wrote: Manual Excerpt: " If a second call is made to pg_connect() with the same connection_string, no new connection will be established, but instead, the connection resource of the already opened connection will be returned. You can have multiple connections to the same database if

Re: [PHP] PostgreSQL/PHP: transactions: how-to abstract out?

Not exactly sure why your transactions aren't working but if your script already has an open connection to the database and you issue another call to pg_connect with the same connect string PHP will return the existing connection and should not create another connection to the database, that is pro

[PHP] PostgreSQL/PHP: transactions: how-to abstract out?

Hi. I thought I had abstracted out the SQL querying part of my code out, just to find out today that it doesn't work when it comes to transactions. I had come up with this code: function sql_query($sql) { $conn = pg_connect("dbname=JC user=postgres"); $res = pg_exec($conn, $sql); if (!$re

Re: [PHP] PostgreSQL + PHP + SQL warning messages

El Jue 25 Ene 2001 16:36, Evelio Martinez escribió: > Hi! > > Is there any way to get the equivalent sqlca.sqlcode value of informix > in PostgreSQL from php ? > > I would like to use the sqlcode to print the messages in Spanish. The problem is that informix puts in an array (sort of) all the inf

[PHP] PostgreSQL + PHP + SQL warning messages

Hi! Is there any way to get the equivalent sqlca.sqlcode value of informix in PostgreSQL from php ? I would like to use the sqlcode to print the messages in Spanish. Thanks in advance -- Evelio Martínez Testanet. Dept. desarrollo software. Av. Reino de Valencia, 15 - 5 46005 Valencia (Spain)