cvs: phpdoc /en/reference/pdo/functions PDOStatement-bindColumn.xml PDOStatement-fetch.xml PDOStatement-fetchAll.xml PDOStatement-fetchColumn.xml
PDOStatement-fetchSingle.xml PDOStatement-rowCount.xml
| From: | Dan Scott | Date: | Fri, 20 May 2005 18:51:08 +0000 |
| Subject: | cvs: phpdoc /en/reference/pdo/functions PDOStatement-bindColumn.xml PDOStatement-fetch.xml PDOStatement-fetchAll.xml PDOStatement-fetchColumn.xml PDOStatement-fetchSingle.xml PDOStatement-rowCount.xml |
||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969368309@lists.php.net to get a copy of this message | ||
dbs Fri May 20 14:51:08 2005 EDT
Added files:
/phpdoc/en/reference/pdo/functions PDOStatement-fetchColumn.xml
Removed files:
/phpdoc/en/reference/pdo/functions PDOStatement-fetchSingle.xml
Modified files:
/phpdoc/en/reference/pdo/functions PDOStatement-bindColumn.xml
PDOStatement-fetchAll.xml
PDOStatement-fetch.xml
PDOStatement-rowCount.xml
Log:
PDOStatement::fetchSingle becomes PDOStatement::fetchColumn.
Add new parameter to PDOStatement::fetchColumn.
http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml?r1=1.4&r2=1.5&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml:1.4 phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml:1.5 --- phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml:1.4 Wed Jan 26 09:41:31 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml Fri May 20 14:51:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.4 $ --> +<!-- $Revision: 1.5 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-bindColumn"> <refnamediv> @@ -143,7 +143,7 @@ <member><function>PDOStatement::execute</function></member> <member><function>PDOStatement::fetch</function></member> <member><function>PDOStatement::fetchAll</function></member> - <member><function>PDOStatement::fetchSingle</function></member> + <member><function>PDOStatement::fetchColumn</function></member> </simplelist> </para> </refsect1> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml?r1=1.5&r2=1.6&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.5 phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.6 --- phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.5 Sat Feb 5 13:52:58 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml Fri May 20 14:51: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.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-fetchAll"> <refnamediv> @@ -106,7 +106,7 @@ <simplelist> <member><function>PDO::query</function></member> <member><function>PDOStatement::fetch</function></member> - <member><function>PDOStatement::fetchSingle</function></member> + <member><function>PDOStatement::fetchColumn</function></member> <member><function>PDOStatement::prepare</function></member> <member><function>PDOStatement::setFetchMode</function></member> </simplelist> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml?r1=1.6&r2=1.7&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.6 phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.7 --- phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.6 Mon Feb 21 10:00:03 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml Fri May 20 14:51:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.6 $ --> +<!-- $Revision: 1.7 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-fetch"> <refnamediv> @@ -237,7 +237,7 @@ <simplelist> <member><function>PDO::query</function></member> <member><function>PDOStatement::fetchAll</function></member> - <member><function>PDOStatement::fetchSingle</function></member> + <member><function>PDOStatement::fetchColumn</function></member> <member><function>PDOStatement::prepare</function></member> <member><function>PDOStatement::setFetchMode</function></member> </simplelist> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml?r1=1.6&r2=1.7&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml:1.6 phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml:1.7 --- phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml:1.6 Tue Mar 8 10:38:57 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml Fri May 20 14:51:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.6 $ --> +<!-- $Revision: 1.7 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-rowCount"> <refnamediv> @@ -66,7 +66,7 @@ return the number of rows affected by a SELECT statement. Instead, use <function>PDO::query</function> to issue a SELECT COUNT(*) statement with the same predicates as your intended SELECT statement, then use - <function>PDOStatement::fetchSingle</function> to retrieve the number + <function>PDOStatement::fetchColumn</function> to retrieve the number of rows that will be returned. Your application can then perform the correct action. </para> @@ -77,7 +77,7 @@ if ($res = $conn->query($sql)) { // Check the number of rows that match the SELECT statement - if ($res->fetchSingle() > 0) { + if ($res->fetchColumn() > 0) { // Issue the real SELECT statement and work with the results $sql = "SELECT name FROM fruit WHERE calories > 100"; @@ -114,8 +114,8 @@ <para> <simplelist> <member><function>PDOStatement::columnCount</function></member> + <member><function>PDOStatement::fetchColumn</function></member> <member><function>PDOStatement::query</function></member> - <member><function>PDOStatement::fetchSingle</function></member> </simplelist> </para> http://cvs.php.net/co.php/phpdoc/en/reference/pdo/functions/PDOStatement-fetchColumn.xml?r=1.1&p=1 Index: phpdoc/en/reference/pdo/functions/PDOStatement-fetchColumn.xml +++ phpdoc/en/reference/pdo/functions/PDOStatement-fetchColumn.xml <?xml version='1.0' encoding='iso-8859-1'?> <!-- $Revision: 1.1 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-fetchColumn"> <refnamediv> <refname>PDOStatement::fetchColumn</refname> <refpurpose> Returns a single column from the next row of a result set </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>string</type><methodname>PDOStatement::fetchColumn</methodname> <methodparam choice="opt"><type>int</type><parameter>column_number</parameter></methodparam> </methodsynopsis> &warn.experimental.func; <para> Returns a single column from the next row of a result set. </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>column_number</parameter></term> <listitem> <para> Number of the column you wish to retrieve from the row. If no value is supplied, <function>PDOStatement::fetchColumn</function> fetches the first column. </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> <function>PDOStatement::fetchColumn</function> returns a single column in the next row of a result set. </para> <warning> <para> There is no way to return a second column from the same row if you use <function>PDOStatement::fetchColumn</function> to retrieve data. </para> </warning> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example><title>Return first column of the next row</title> <programlisting role="php"> <![CDATA[ <?php $sth = $dbh->prepare("SELECT name, colour FROM fruit"); $sth->execute(); /* Fetch the first column from the next row in the result set */ print("Fetch the first column from the next row in the result set:\n"); $result = $sth->fetchColumn(); print("$result\n"); $result = $sth->fetchColumn(); print("$result\n"); ?> ]]> </programlisting> &example.outputs; <screen> <![CDATA[ Fetch the first column from the next row in the result set: lemon orange ]]> </screen> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>PDO::query</function></member> <member><function>PDOStatement::fetch</function></member> <member><function>PDOStatement::fetchAll</function></member> <member><function>PDOStatement::prepare</function></member> <member><function>PDOStatement::setFetchMode</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 -->
http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml?r1=1.4&r2=1.5&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml:1.4 phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml:1.5 --- phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml:1.4 Wed Jan 26 09:41:31 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-bindColumn.xml Fri May 20 14:51:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.4 $ --> +<!-- $Revision: 1.5 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-bindColumn"> <refnamediv> @@ -143,7 +143,7 @@ <member><function>PDOStatement::execute</function></member> <member><function>PDOStatement::fetch</function></member> <member><function>PDOStatement::fetchAll</function></member> - <member><function>PDOStatement::fetchSingle</function></member> + <member><function>PDOStatement::fetchColumn</function></member> </simplelist> </para> </refsect1> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml?r1=1.5&r2=1.6&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.5 phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.6 --- phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml:1.5 Sat Feb 5 13:52:58 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-fetchAll.xml Fri May 20 14:51: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.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-fetchAll"> <refnamediv> @@ -106,7 +106,7 @@ <simplelist> <member><function>PDO::query</function></member> <member><function>PDOStatement::fetch</function></member> - <member><function>PDOStatement::fetchSingle</function></member> + <member><function>PDOStatement::fetchColumn</function></member> <member><function>PDOStatement::prepare</function></member> <member><function>PDOStatement::setFetchMode</function></member> </simplelist> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml?r1=1.6&r2=1.7&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.6 phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.7 --- phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml:1.6 Mon Feb 21 10:00:03 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-fetch.xml Fri May 20 14:51:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.6 $ --> +<!-- $Revision: 1.7 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-fetch"> <refnamediv> @@ -237,7 +237,7 @@ <simplelist> <member><function>PDO::query</function></member> <member><function>PDOStatement::fetchAll</function></member> - <member><function>PDOStatement::fetchSingle</function></member> + <member><function>PDOStatement::fetchColumn</function></member> <member><function>PDOStatement::prepare</function></member> <member><function>PDOStatement::setFetchMode</function></member> </simplelist> http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml?r1=1.6&r2=1.7&ty=u Index: phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml diff -u phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml:1.6 phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml:1.7 --- phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml:1.6 Tue Mar 8 10:38:57 2005 +++ phpdoc/en/reference/pdo/functions/PDOStatement-rowCount.xml Fri May 20 14:51:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.6 $ --> +<!-- $Revision: 1.7 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-rowCount"> <refnamediv> @@ -66,7 +66,7 @@ return the number of rows affected by a SELECT statement. Instead, use <function>PDO::query</function> to issue a SELECT COUNT(*) statement with the same predicates as your intended SELECT statement, then use - <function>PDOStatement::fetchSingle</function> to retrieve the number + <function>PDOStatement::fetchColumn</function> to retrieve the number of rows that will be returned. Your application can then perform the correct action. </para> @@ -77,7 +77,7 @@ if ($res = $conn->query($sql)) { // Check the number of rows that match the SELECT statement - if ($res->fetchSingle() > 0) { + if ($res->fetchColumn() > 0) { // Issue the real SELECT statement and work with the results $sql = "SELECT name FROM fruit WHERE calories > 100"; @@ -114,8 +114,8 @@ <para> <simplelist> <member><function>PDOStatement::columnCount</function></member> + <member><function>PDOStatement::fetchColumn</function></member> <member><function>PDOStatement::query</function></member> - <member><function>PDOStatement::fetchSingle</function></member> </simplelist> </para> http://cvs.php.net/co.php/phpdoc/en/reference/pdo/functions/PDOStatement-fetchColumn.xml?r=1.1&p=1 Index: phpdoc/en/reference/pdo/functions/PDOStatement-fetchColumn.xml +++ phpdoc/en/reference/pdo/functions/PDOStatement-fetchColumn.xml <?xml version='1.0' encoding='iso-8859-1'?> <!-- $Revision: 1.1 $ --> <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. --> <refentry id="function.PDOStatement-fetchColumn"> <refnamediv> <refname>PDOStatement::fetchColumn</refname> <refpurpose> Returns a single column from the next row of a result set </refpurpose> </refnamediv> <refsect1 role="description"> &reftitle.description; <methodsynopsis> <type>string</type><methodname>PDOStatement::fetchColumn</methodname> <methodparam choice="opt"><type>int</type><parameter>column_number</parameter></methodparam> </methodsynopsis> &warn.experimental.func; <para> Returns a single column from the next row of a result set. </para> </refsect1> <refsect1 role="parameters"> &reftitle.parameters; <para> <variablelist> <varlistentry> <term><parameter>column_number</parameter></term> <listitem> <para> Number of the column you wish to retrieve from the row. If no value is supplied, <function>PDOStatement::fetchColumn</function> fetches the first column. </para> </listitem> </varlistentry> </variablelist> </para> </refsect1> <refsect1 role="returnvalues"> &reftitle.returnvalues; <para> <function>PDOStatement::fetchColumn</function> returns a single column in the next row of a result set. </para> <warning> <para> There is no way to return a second column from the same row if you use <function>PDOStatement::fetchColumn</function> to retrieve data. </para> </warning> </refsect1> <refsect1 role="examples"> &reftitle.examples; <para> <example><title>Return first column of the next row</title> <programlisting role="php"> <![CDATA[ <?php $sth = $dbh->prepare("SELECT name, colour FROM fruit"); $sth->execute(); /* Fetch the first column from the next row in the result set */ print("Fetch the first column from the next row in the result set:\n"); $result = $sth->fetchColumn(); print("$result\n"); $result = $sth->fetchColumn(); print("$result\n"); ?> ]]> </programlisting> &example.outputs; <screen> <![CDATA[ Fetch the first column from the next row in the result set: lemon orange ]]> </screen> </example> </para> </refsect1> <refsect1 role="seealso"> &reftitle.seealso; <para> <simplelist> <member><function>PDO::query</function></member> <member><function>PDOStatement::fetch</function></member> <member><function>PDOStatement::fetchAll</function></member> <member><function>PDOStatement::prepare</function></member> <member><function>PDOStatement::setFetchMode</function></member> </simplelist> </para> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t indent-tabs-mode:nil sgml-parent-document:nil sgml-default-dtd-file:"../../../../manual.ced" sgml-exposed-tags:nil sgml-local-catalogs:nil sgml-local-ecat-files:nil End: vim600: syn=xml fen fdm=syntax fdl=2 si vim: et tw=78 syn=sgml vi: ts=1 sw=1 -->