cvs: peardoc /en/package/database/db/db-common getcol.xml
| From: | Daniel Convissor | Date: | Wed, 14 Apr 2004 06:40:49 +0000 |
| Subject: | cvs: peardoc /en/package/database/db/db-common getcol.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-3404@lists.php.net to get a copy of this message | ||
danielc Wed Apr 14 02:40:49 2004 EDT
Modified files:
/peardoc/en/package/database/db/db-common getcol.xml
Log:
Provide complete example set.
http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getcol.xml?r1=1.20&r2=1.21&ty=u
Index: peardoc/en/package/database/db/db-common/getcol.xml
diff -u peardoc/en/package/database/db/db-common/getcol.xml:1.20
peardoc/en/package/database/db/db-common/getcol.xml:1.21
--- peardoc/en/package/database/db/db-common/getcol.xml:1.20 Wed Apr 14 02:06:25 2004
+++ peardoc/en/package/database/db/db-common/getcol.xml Wed Apr 14 02:40:49 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.20 $ -->
+<!-- $Revision: 1.21 $ -->
<refentry id="package.database.db.db-common.getcol">
<refnamediv>
@@ -193,23 +193,143 @@
<refsect1 id="package.database.db.db-common.getcol.example">
&title.example;
<example>
- <title>Using <function>getCol</function></title>
+ <title>
+ Using <function>getCol</function>
+ </title>
<programlisting role="php">
<![CDATA[
<?php
// Once you have a valid DB object named $db...
-$data =& $db->getCol('SELECT name FROM clients');
+$data =& $db->getCol('SELECT cf, df FROM foo');
if (DB::isError($data)) {
die($data->getMessage());
}
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => Juan
+ * [1] => Kyu
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getCol</function> to retrieve a
+ numerically specified column
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getCol('SELECT cf, df FROM foo', 1);
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => 1991-01-11 21:31:41
+ * [1] => 1992-02-12 22:32:42
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getCol</function> to retrieve a
+ named column
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getCol('SELECT cf, df FROM foo', 'df');
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => 1991-01-11 21:31:41
+ * [1] => 1992-02-12 22:32:42
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getCol</function> in prepare/execute mode
+ with one placeholder
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getCol('SELECT cf, df FROM foo WHERE nf = ?',
+ 'df', 5);
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => 1991-01-11 21:31:41
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getCol</function> in prepare/execute mode
+ with two placeholders
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getCol('SELECT cf, df FROM foo WHERE nf IN (?, ?)',
+ 'df', array(5, 10));
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
/*
- * Returns:
- * array(
- * 0 => 'Stig',
- * 1 => 'Jon',
- * 2 => 'Colin'
+ * Array
+ * (
+ * [0] => 1991-01-11 21:31:41
+ * [1] => 1992-02-12 22:32:42
* )
*/
?>