New PHP/PostgreSQL functions

Hey guys,

Check this out:

http://www.php.net/manual/en/ref.pgsql.php

Note all v3 protocol functions are in for PHP 5.1, like

. pg_transaction_status() - in-transaction status of a database
connection.
. pg_query_params() - execution of parameterized queries.
. pg_prepare() - prepare named queries.
. pg_execute() - execution of named prepared queries.
. pg_send_query_params() - async equivalent of pg_query_params().
. pg_send_prepare() - async equivalent of pg_prepare().
. pg_send_execute() - async equivalent of pg_execute().
. pg_result_error_field() - highly detailed error information,
most importantly the SQLSTATE error code.
. pg_set_error_verbosity() - set verbosity of errors.

Cheers,

Chris

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo [at] postgresql.org
Christopher Kings-Lyn [ Sa, 26 März 2005 20:11 ] [ ID #715204 ]

Re: New PHP/PostgreSQL functions

That is great for us users of PostgreSQL... but when is 5.1 release date?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Postgres User [ Sa, 26 März 2005 21:12 ] [ ID #715205 ]

Re: New PHP/PostgreSQL functions

> That is great for us users of PostgreSQL... but when is 5.1 release date?

No idea whatsoever :)

Chris

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Christopher Kings-Lyn [ So, 27 März 2005 05:18 ] [ ID #716111 ]

Re: New PHP/PostgreSQL functions

El S=E1b 26 Mar 2005 15:11, Christopher Kings-Lynne escribi=F3:
> Hey guys,
>
> Check this out:
>
> http://www.php.net/manual/en/ref.pgsql.php
>
> Note all v3 protocol functions are in for PHP 5.1, like

What about PHP 4.x? Will there be any backporting?

--
09:08:52 up 9 days, 13:39, 1 user, load average: 0.72, 0.55, 0.82
------------------------------------------------------------ -----
Mart=EDn Marqu=E9s | select 'mmarques' || ' [at] ' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
------------------------------------------------------------ -----

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Martin Marques [ Mo, 28 März 2005 14:09 ] [ ID #717224 ]

Re: New PHP/PostgreSQL functions

>>Hey guys,
>>
>>Check this out:
>>
>>http://www.php.net/manual/en/ref.pgsql.php
>>
>>Note all v3 protocol functions are in for PHP 5.1, like
>
>
> What about PHP 4.x? Will there be any backporting?

No...

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo [at] postgresql.org)
Christopher Kings-Lyn [ Mo, 28 März 2005 16:03 ] [ ID #717225 ]

Re: New PHP/PostgreSQL functions

On Saturday 26 March 2005 13:11, Christopher Kings-Lynne wrote:
> Hey guys,
>
> Check this out:
>
> http://www.php.net/manual/en/ref.pgsql.php
>
> Note all v3 protocol functions are in for PHP 5.1, like
>
> . pg_transaction_status() - in-transaction status of a database
> connection.
> . pg_query_params() - execution of parameterized queries.
> . pg_prepare() - prepare named queries.
> . pg_execute() - execution of named prepared queries.
> . pg_send_query_params() - async equivalent of pg_query_params().
> . pg_send_prepare() - async equivalent of pg_prepare().
> . pg_send_execute() - async equivalent of pg_execute().
> . pg_result_error_field() - highly detailed error information,
> most importantly the SQLSTATE error code.
> . pg_set_error_verbosity() - set verbosity of errors.
>

Thanks much for your work on this Chris. One thing I was wondering is if you
changed any of the existing functions due to differences in the v3 protocol?

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq
Robert Treat [ Di, 29 März 2005 04:19 ] [ ID #718947 ]

Re: New PHP/PostgreSQL functions

> Thanks much for your work on this Chris. One thing I was wondering is if you
> changed any of the existing functions due to differences in the v3 protocol?

So far I've changed pg_copy_to and pg_copy_from to use the new v3
functions if they exist. I've still got lots more to do though. I'm
working on pdo_pgsql atm.

Chris

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Christopher Kings-Lyn [ Di, 29 März 2005 05:26 ] [ ID #718948 ]
Datenbanken » gmane.comp.db.postgresql.php » New PHP/PostgreSQL functions

Vorheriges Thema: question about postgres persistent connection in php
Nächstes Thema: PHP and Postgres setup