cvs: peardoc /en/package/database/db/db-common getall.xml

From: 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 + * ) * ) */ ?>

« previous php.pear.doc (#3394) next »