cvs: peardoc /en/package/database/db/db-common getall.xml
| From: | Daniel Convissor | Date: | Wed, 14 Apr 2004 05:08:55 +0000 |
| Subject: | cvs: peardoc /en/package/database/db/db-common getall.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-3394@lists.php.net to get a copy of this message | ||
danielc Wed Apr 14 01:08:55 2004 EDT
Modified files:
/peardoc/en/package/database/db/db-common getall.xml
Log:
Provide complete example set.
http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getall.xml?r1=1.18&r2=1.19&ty=u
Index: peardoc/en/package/database/db/db-common/getall.xml
diff -u peardoc/en/package/database/db/db-common/getall.xml:1.18
peardoc/en/package/database/db/db-common/getall.xml:1.19
--- peardoc/en/package/database/db/db-common/getall.xml:1.18 Tue Apr 13 18:12:59 2004
+++ peardoc/en/package/database/db/db-common/getall.xml Wed Apr 14 01:08:54 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.18 $ -->
+<!-- $Revision: 1.19 $ -->
<refentry id="package.database.db.db-common.getall">
<refnamediv>
@@ -183,23 +183,279 @@
<refsect1 id="package.database.db.db-common.getall.example">
&title.example;
<example>
- <title>Using <function>getAll</function></title>
+ <title>
+ Using <function>getAll</function> to return an
+ associative array
+ by setting the default fetch mode first
+ </title>
<programlisting role="php">
<![CDATA[
<?php
// Once you have a valid DB object named $db...
-$data =& $db->getAll('SELECT id, text, date FROM mytable');
+$db->setFetchMode(DB_FETCHMODE_ASSOC);
+$data =& $db->getAll('SELECT cf, nf, df FROM foo');
if (DB::isError($data)) {
die($data->getMessage());
}
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => Array
+ * (
+ * [cf] => Juan
+ * [nf] => 5
+ * [df] => 1991-01-11 21:31:41
+ * )
+ * [1] => Array
+ * (
+ * [cf] => Kyu
+ * [nf] => 10
+ * [df] => 1992-02-12 22:32:42
+ * )
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getAll</function> to return an
+ ordered array
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getAll('SELECT cf, nf, df FROM foo',
+ array(), DB_FETCHMODE_ORDERED);
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => Array
+ * (
+ * [0] => Juan
+ * [1] => 5
+ * [2] => 1991-01-11 21:31:41
+ * )
+ * [1] => Array
+ * (
+ * [0] => Kyu
+ * [1] => 10
+ * [2] => 1992-02-12 22:32:42
+ * )
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getAll</function> to return a
+ flipped ordered array
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getAll('SELECT cf, nf, df FROM foo',
+ array(), DB_FETCHMODE_ORDERED | DB_FETCHMODE_FLIPPED);
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => Array
+ * (
+ * [0] => Juan
+ * [1] => Kyu
+ * )
+ * [1] => Array
+ * (
+ * [0] => 5
+ * [1] => 10
+ * )
+ * [2] => Array
+ * (
+ * [0] => 1991-01-11 21:31:41
+ * [1] => 1992-02-12 22:32:42
+ * )
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getAll</function> to return an
+ associative array
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getAll('SELECT cf, nf, df FROM foo',
+ array(), DB_FETCHMODE_ASSOC);
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => Array
+ * (
+ * [cf] => Juan
+ * [nf] => 5
+ * [df] => 1991-01-11 21:31:41
+ * )
+ * [1] => Array
+ * (
+ * [cf] => Kyu
+ * [nf] => 10
+ * [df] => 1992-02-12 22:32:42
+ * )
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getAll</function> to return a
+ flipped associative array
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getAll('SELECT cf, nf, df FROM foo',
+ array(), DB_FETCHMODE_ASSOC | DB_FETCHMODE_FLIPPED);
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [cf] => Array
+ * (
+ * [0] => Juan
+ * [1] => Kyu
+ * )
+ * [nf] => Array
+ * (
+ * [0] => 5
+ * [1] => 10
+ * )
+ * [df] => Array
+ * (
+ * [0] => 1991-01-11 21:31:41
+ * [1] => 1992-02-12 22:32:42
+ * )
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getAll</function> to return an
+ array of objects
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getAll('SELECT cf, nf, df FROM foo',
+ array(), DB_FETCHMODE_OBJECT);
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
+/*
+ * Array
+ * (
+ * [0] => stdClass Object
+ * (
+ * [cf] => Juan
+ * [nf] => 5
+ * [df] => 1991-01-11 21:31:41
+ * )
+ * [1] => stdClass Object
+ * (
+ * [cf] => Kyu
+ * [nf] => 10
+ * [df] => 1992-02-12 22:32:42
+ * )
+ * )
+ */
+?>
+ ]]>
+ </programlisting>
+ </example>
+
+ <example>
+ <title>
+ Using <function>getAll</function> in prepare/execute mode
+ to return an associative array
+ </title>
+ <programlisting role="php">
+ <![CDATA[
+<?php
+// Once you have a valid DB object named $db...
+$data =& $db->getAll('SELECT cf, nf, df FROM foo WHERE nf = ?',
+ array(5), DB_FETCHMODE_ASSOC);
+
+if (DB::isError($data)) {
+ die($data->getMessage());
+}
+
+print_r($data);
+
/*
- * Returns:
- * array(
- * 0 => array('4', 'four', '2004'),
- * 1 => array('5', 'five', '2005'),
- * 2 => array('6', 'six', '2006')
+ * Array
+ * (
+ * [0] => Array
+ * (
+ * [cf] => Juan
+ * [nf] => 5
+ * [df] => 1991-01-11 21:31:41
+ * )
* )
*/
?>