[PHP-DOC] cvs: phpdoc /en/reference/pgsql/functions pg-query.xml
kouber Tue Oct 4 08:56:29 2005 EDT Modified files: /phpdoc/en/reference/pgsql/functionspg-query.xml Log: Multiple statements example transaction explanations added (Bug #34719). http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-query.xml?r1=1.11r2=1.12ty=u Index: phpdoc/en/reference/pgsql/functions/pg-query.xml diff -u phpdoc/en/reference/pgsql/functions/pg-query.xml:1.11 phpdoc/en/reference/pgsql/functions/pg-query.xml:1.12 --- phpdoc/en/reference/pgsql/functions/pg-query.xml:1.11 Mon Jul 4 03:42:00 2005 +++ phpdoc/en/reference/pgsql/functions/pg-query.xmlTue Oct 4 08:56:26 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.11 $ -- +!-- $Revision: 1.12 $ -- !-- splitted from ./en/functions/pgsql.xml, last change in rev 1.2 -- refentry id=function.pg-query refnamediv @@ -64,7 +64,9 @@ termparameterquery/parameter/term listitem para - The SQL statement or statements to be executed. + The SQL statement or statements to be executed. When multiple statements are passed to the function, + they are automatically executed as one transaction, unless there are explicit BEGIN/COMMIT commands + included in the query string. However, using multiple transactions in one function call is not recommended. /para /listitem /varlistentry @@ -110,6 +112,28 @@ /programlisting /example /para + para + example +titleUsing pg_query() with multiple statements/title +programlisting role=php +![CDATA[ +?php + +$conn = pg_pconnect(dbname=publisher); + +// these statements will be executed as one transaction + +$query = UPDATE authors SET author=UPPER(author) WHERE id=1;; +$query .= UPDATE authors SET author=LOWER(author) WHERE id=2;; +$query .= UPDATE authors SET author=NULL WHERE id=3;; + +pg_query($conn, $query); + +? +]] +/programlisting + /example + /para /refsect1 refsect1 role=seealso
[PHP-DOC] cvs: phpdoc /en/reference/pgsql/functions pg-query.xml
jsgoupilTue Oct 4 11:17:50 2005 EDT Modified files: /phpdoc/en/reference/pgsql/functionspg-query.xml Log: using function tag instead of () http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-query.xml?r1=1.12r2=1.13ty=u Index: phpdoc/en/reference/pgsql/functions/pg-query.xml diff -u phpdoc/en/reference/pgsql/functions/pg-query.xml:1.12 phpdoc/en/reference/pgsql/functions/pg-query.xml:1.13 --- phpdoc/en/reference/pgsql/functions/pg-query.xml:1.12 Tue Oct 4 08:56:26 2005 +++ phpdoc/en/reference/pgsql/functions/pg-query.xmlTue Oct 4 11:17:46 2005 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.12 $ -- +!-- $Revision: 1.13 $ -- !-- splitted from ./en/functions/pgsql.xml, last change in rev 1.2 -- refentry id=function.pg-query refnamediv @@ -114,7 +114,7 @@ /para para example -titleUsing pg_query() with multiple statements/title +titleUsing functionpg_query/function with multiple statements/title programlisting role=php ![CDATA[ ?php
[PHP-DOC] cvs: phpdoc /en/reference/pgsql/functions pg-query.xml
didou Mon Jul 14 15:46:57 2003 EDT Modified files: /phpdoc/en/reference/pgsql/functionspg-query.xml Log: closing #24649 Index: phpdoc/en/reference/pgsql/functions/pg-query.xml diff -u phpdoc/en/reference/pgsql/functions/pg-query.xml:1.4 phpdoc/en/reference/pgsql/functions/pg-query.xml:1.5 --- phpdoc/en/reference/pgsql/functions/pg-query.xml:1.4Sun Jun 15 06:18:04 2003 +++ phpdoc/en/reference/pgsql/functions/pg-query.xmlMon Jul 14 15:46:56 2003 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.4 $ -- +!-- $Revision: 1.5 $ -- !-- splitted from ./en/functions/pgsql.xml, last change in rev 1.2 -- refentry id=function.pg-query refnamediv @@ -19,7 +19,7 @@ connection is not a valid connection. Details about the error can be retrieved using the functionpg_last_error/function function if connection is valid. - functionpg_last_error/function sends an SQL statement to + functionpg_query/function sends an SQL statement to the PostgreSQL database specified by the parameterconnection/parameter resource. The parameterconnection/parameter must be a valid connection that -- PHP Documentation Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DOC] cvs: phpdoc /en/reference/pgsql/functions pg-query.xml
nicos Sun Jun 15 06:18:04 2003 EDT Modified files: /phpdoc/en/reference/pgsql/functionspg-query.xml Log: Typo. Thanks @Jome Index: phpdoc/en/reference/pgsql/functions/pg-query.xml diff -u phpdoc/en/reference/pgsql/functions/pg-query.xml:1.3 phpdoc/en/reference/pgsql/functions/pg-query.xml:1.4 --- phpdoc/en/reference/pgsql/functions/pg-query.xml:1.3Sat Apr 20 06:35:23 2002 +++ phpdoc/en/reference/pgsql/functions/pg-query.xmlSun Jun 15 06:18:04 2003 @@ -1,5 +1,5 @@ ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.3 $ -- +!-- $Revision: 1.4 $ -- !-- splitted from ./en/functions/pgsql.xml, last change in rev 1.2 -- refentry id=function.pg-query refnamediv @@ -30,7 +30,7 @@ functionpg_fetch_array/function. note simpara - parameterconnection/parameter is a optional parameter for + parameterconnection/parameter is an optional parameter for functionpg_query/function. If parameterconnection/parameter is not set, default connection is used. Default connection is the last connection -- PHP Documentation Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DOC] cvs: phpdoc /en/reference/pgsql/functions pg-query.xml
mfischerSat Apr 20 06:35:23 2002 EDT Modified files: /phpdoc/en/reference/pgsql/functionspg-query.xml Log: - Add comment that pg_exec() is not dead and still available too. Index: phpdoc/en/reference/pgsql/functions/pg-query.xml diff -u phpdoc/en/reference/pgsql/functions/pg-query.xml:1.2 phpdoc/en/reference/pgsql/functions/pg-query.xml:1.3 --- phpdoc/en/reference/pgsql/functions/pg-query.xml:1.2Wed Apr 17 02:43:22 2002 +++ phpdoc/en/reference/pgsql/functions/pg-query.xmlSat Apr 20 06:35:23 2002 -1,5 +1,5 ?xml version=1.0 encoding=iso-8859-1? -!-- $Revision: 1.2 $ -- +!-- $Revision: 1.3 $ -- !-- splitted from ./en/functions/pgsql.xml, last change in rev 1.2 -- refentry id=function.pg-query refnamediv -47,6 +47,8 note para This function used to be called literalpg_exec()/literal. + literalpg_exec()/literal is still available for compatibility + reasons but users are encouraged to use the newer name. /para /note para