Re: cvs: phpdoc /en/reference/pdo reference.xml /en/reference/pdo/functions PDO-lastInsertId.xml PDOStatement-closeCursor.xml

From:	Wez Furlong	Date:	Sat, 09 Jul 2005 05:23:34 +0000
Subject:	Re: cvs: phpdoc /en/reference/pdo reference.xml /en/reference/pdo/functions PDO-lastInsertId.xml PDOStatement-closeCursor.xml
References:	1	Groups:	php.doc
Request:	Send a blank email to phpdoc+get-969369010@lists.php.net to get a copy of this message

It's worth noting that calling closeCursor() is usually only required if you don't explicitly fetch all the rows from a given statement object before switching to a different statement object. In other words: $stmt->execute(); $stmt->fetch(); $stmt->execute(); will work happily, but $stmt->execute(); $stmt->fetch(); $otherStmt->execute(); might break with an out-of-sequence error for some drivers. Adding a $stmt->closeCursor() before $otherStmt->fetch() is one way to handle this situation. On 7/9/05, Dan Scott <dbs@php.net> wrote: > dbs Sat Jul 9 01:19:02 2005 EDT > > Added files: > /phpdoc/en/reference/pdo/functions PDOStatement-closeCursor.xml > > Modified files: > /phpdoc/en/reference/pdo reference.xml > /phpdoc/en/reference/pdo/functions PDO-lastInsertId.xml > Log: > PDO-lastInsertID() returns last value of sequence object. > Document PDOStatement-closeCursor(). > > > > http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/reference.xml?r1=1.23&r2=1.24&ty=u > Index: phpdoc/en/reference/pdo/reference.xml > diff -u phpdoc/en/reference/pdo/reference.xml:1.23 phpdoc/en/reference/pdo/reference.xml:1.24 > --- phpdoc/en/reference/pdo/reference.xml:1.23 Fri Jun 3 08:54:13 2005 > +++ phpdoc/en/reference/pdo/reference.xml Sat Jul 9 01:19:00 2005 > @@ -1,5 +1,5 @@ > <?xml version='1.0' encoding='iso-8859-1'?> > - > + >  > <reference id="ref.pdo"> > <title>PDO Functions</title> > @@ -326,6 +326,12 @@ > </listitem> > <listitem> > <para> > + <link > linkend='function.PDOStatement-closeCursor'>closeCursor</link> > + - closes the cursor, allowing the statement to be executed again > + </para> > + </listitem> > + <listitem> > + <para> > <link > linkend='function.PDOStatement-columnCount'>columnCount</link> > - returns the number of columns in the result set > </para> > > http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml?r1=1.6&r2=1.7&ty=u > Index: phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml > diff -u phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml:1.6 > phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml:1.7 > --- phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml:1.6 Wed Mar 9 19:02:49 2005 > +++ phpdoc/en/reference/pdo/functions/PDO-lastInsertId.xml Sat Jul 9 01:19:01 2005 > @@ -1,11 +1,11 @@ > <?xml version='1.0' encoding='iso-8859-1'?> > - > + >  > <refentry id="function.PDO-lastInsertId"> > <refnamediv> > <refname>PDO::lastInsertId</refname> > <refpurpose> > - Returns the ID of the last inserted row > + Returns the ID of the last inserted row or sequence value > </refpurpose> > </refnamediv> > <refsect1 role="description"> > @@ -18,7 +18,7 @@ > &warn.experimental.func; > > <para> > - Returns the ID of the last inserted row, or the next value from a > + Returns the ID of the last inserted row, or the last value from a > sequence object. > </para> > <note> > @@ -56,7 +56,7 @@ > <para> > If a sequence name was specified for the <parameter>name</parameter> > parameter, <function>PDOStatement::lastInsertId</function> returns a > - string representing the next value retrieved from the specified sequence > + string representing the last value retrieved from the specified sequence > object. > </para> > <para> > > > http://cvs.php.net/co.php/phpdoc/en/reference/pdo/functions/PDOStatement-closeCursor.xml?r=1.1&p=1 > Index: phpdoc/en/reference/pdo/functions/PDOStatement-closeCursor.xml > +++ phpdoc/en/reference/pdo/functions/PDOStatement-closeCursor.xml > <?xml version="1.0" encoding="iso-8859-1"?> >  >  > <refentry id="function.PDOStatement-closeCursor"> > <refnamediv> > <refname>PDOStatement::closeCursor</refname> > <refpurpose> > Closes the cursor, enabling the statement to be executed again. > </refpurpose> > </refnamediv> > <refsect1 role="description"> > &reftitle.description; > <methodsynopsis> > <type>bool</type><methodname>PDOStatement::closeCursor</methodname> > <void/> > </methodsynopsis> > > &warn.experimental.func; > > <para> > <function>PDOStatement::closeCursor</function> frees up the connection > to the server so that other queries may be issued, but leaves the > statement in a state that enables it to be executed again. > </para> > <para> > This is implemented either as an optional driver specific method (allowing > for maximum efficiency), or as the generic PDO fallback if no driver > specific function is installed. > </para> > <para> > The PDO generic fallback is semantically the same as writing the following > code in your PHP script: > <programlisting role="php"> > <![CDATA[ > <?php > do { > while ($stmt->fetch()) > ; > if (!$stmt->nextRowset()) > break; > } while (true); > ]]> > </programlisting> > </para> > > </refsect1> > >  > > >  > > >  > > > <refsect1 role="seealso"> > &reftitle.seealso; > <para> > <simplelist> > <member><function>PDOStatement::execute</function></member> > </simplelist> > </para> > </refsect1> > > </refentry> > >  >