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

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

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