cvs: phpdoc /en/reference/pdo/functions PDO-lastInsertId.xml PDO-query.xml PDOStatement-fetch.xml PDOStatement-fetchAll.xml

dbs Wed Oct 19 16:45:05 2005 EDT Modified files: /phpdoc/en/reference/pdo/functions PDO-lastInsertId.xml PDO-query.xml PDOStatement-fetch.xml PDOStatement-fetchAll.xml Log: Address user notes and add a few more details. http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml?r1=1.9&r2=1.10&ty=u Index: phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml diff -u phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml:1.9 phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml:1.10 --- phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml:1.9 Sun Sep 11 02:22:26 2005 +++ phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml Wed Oct 19 16:45:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.9 $ --> +<!-- $Revision: 1.10 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDO-lastInsertId"> <refnamediv> @@ -17,13 +17,15 @@ <para> Returns the ID of the last inserted row, or the last value from a - sequence object, depending on the underlying driver. + sequence object, depending on the underlying driver. For example, + <function>PDO_PGSQL</function> requires you to specify the name of + a sequence object for the <parameter>name</parameter> parameter. </para> <note> <para> - This method may not return a meaningful/consistent result across different PDO - drivers, because the underlying database may not even support the notion - of auto-increment fields or sequences. + This method may not return a meaningful or consistent result across + different PDO drivers, because the underlying database may not even + support the notion of auto-increment fields or sequences. </para> </note> </refsect1> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDO-query.xml?r1=1.5&r2=1.6&ty=u Index: phpdoc/en/reference/pdo/functions/PDO-query.xml diff -u phpdoc/en/reference/pdo/functions/PDO-query.xml:1.5 phpdoc/en/reference/pdo/functions/PDO-query.xml:1.6 --- phpdoc/en/reference/pdo/functions/PDO-query.xml:1.5 Sun Sep 11 02:22:26 2005 +++ phpdoc/en/reference/pdo/functions/PDO-query.xml Wed Oct 19 16:45:02 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.5 $ --> +<!-- $Revision: 1.6 $ --> <!-- Generated by xml_proto.php v2.2. Found in /scripts directory of phpdoc. --> <refentry id="function.PDO-query"> <refnamediv> @@ -26,6 +26,13 @@ <function>PDO::prepare</function> and issue the statement with multiple calls to <function>PDOStatement::execute</function>. </para> + <para> + If you do not fetch all of the data in a result set before issuing your + next call to <function>PDO::query</function>, your call may fail. Call + <function>PDOStatement::closeCursor</function> to release the database + resources associated with the PDOStatement object before issuing your + next call to <function>PDO::query</function>. + </para> </refsect1> <refsect1 role="parameters"> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml?r1=1.9&r2=1.10&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.9 phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.10 --- phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.9 Tue Sep 20 04:22:29 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml Wed Oct 19 16:45:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.9 $ --> +<!-- $Revision: 1.10 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-fetch"> <refnamediv> @@ -18,7 +18,9 @@ </methodsynopsis> <para> - Fetches a row from a result set associated with a PDOStatement object. + Fetches a row from a result set associated with a PDOStatement object. The + <parameter>fetch_style</parameter> parameter determines how PDO returns + the row. </para> </refsect1> @@ -40,7 +42,8 @@ </para></listitem> <listitem><para> <literal>PDO::FETCH_BOTH</literal> (default): returns an array indexed by - both column name and column number as returned in your result set + both column name and 0-indexed column number as returned in your + result set </para></listitem> <listitem><para> <literal>PDO::FETCH_BOUND</literal>: returns &true; and assigns the @@ -49,19 +52,29 @@ method </para></listitem> <listitem><para> + <literal>PDO::FETCH_CLASS</literal>: returns a new instance of the + requested class, mapping the columns of the result set to named + properties in the class + </para></listitem> + <listitem><para> + <literal>PDO::FETCH_INTO</literal>: updates an existing instance + of the requested class, mapping the columns of the result set to + named properties in the class + </para></listitem> + <listitem><para> <literal>PDO::FETCH_LAZY</literal>: combines <literal>PDO::FETCH_BOTH</literal> and <literal>PDO::FETCH_OBJ</literal>, creating the object variable names as they are accessed </para></listitem> <listitem><para> + <literal>PDO::FETCH_NUM</literal>: returns an array indexed by column + number as returned in your result set, starting at column 0 + </para></listitem> + <listitem><para> <literal>PDO::FETCH_OBJ</literal>: returns an anonymous object with property names that correspond to the column names returned in your result set </para></listitem> - <listitem><para> - <literal>PDO::FETCH_NUM</literal>: returns an array indexed by column - number as returned in your result set, starting at column 0 - </para></listitem> </itemizedlist> </para> </listitem> @@ -73,7 +86,11 @@ For a PDOStatement object representing a scrollable cursor, this value determines which row will be returned to the caller. This value must be one of the <literal>PDO::FETCH_ORI_*</literal> constants, - defaulting to <literal>PDO::FETCH_ORI_NEXT</literal>. + defaulting to <literal>PDO::FETCH_ORI_NEXT</literal>. To request a + scrollable cursor for your PDOStatement object, you must set the + <literal>PDO::ATTR_CURSOR</literal> attribute to + <literal>PDO::CURSOR_SCROLL</literal> when you prepare the SQL + statement with <function>PDO::prepare</function>. </para> </listitem> </varlistentry> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml?r1=1.9&r2=1.10&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.9 phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.10 --- phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.9 Tue Sep 20 04:22:29 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml Wed Oct 19 16:45:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.9 $ --> +<!-- $Revision: 1.10 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-fetchAll"> <refnamediv> @@ -32,7 +32,9 @@ </para> <para> To return an array consisting of all values of a single column from - the result set, specify <literal>PDO::FETCH_COLUMN</literal>. + the result set, specify <literal>PDO::FETCH_COLUMN</literal>. You + can specify which column you want with the + <parameter>column-index</parameter> parameter. </para> <para> To fetch only the unique values of a single column from the result set,