cvs: phpdoc /en/reference/pdo/functions PDO-query.xml

dbs Thu Feb 10 20:31:13 2005 EDT Modified files: /phpdoc/en/reference/pdo/functions PDO-query.xml Log: Add an example to PDO::query. http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDO-query.xml?r1=1.1&r2=1.2&ty=u Index: phpdoc/en/reference/pdo/functions/PDO-query.xml diff -u phpdoc/en/reference/pdo/functions/PDO-query.xml:1.1 phpdoc/en/reference/pdo/functions/PDO-query.xml:1.2 --- phpdoc/en/reference/pdo/functions/PDO-query.xml:1.1 Mon Jan 17 22:16:39 2005 +++ phpdoc/en/reference/pdo/functions/PDO-query.xml Thu Feb 10 20:31:12 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.1 $ --> +<!-- $Revision: 1.2 $ --> <!-- Generated by xml_proto.php v2.2. Found in /scripts directory of phpdoc. --> <refentry id="function.PDO-query"> <refnamediv> @@ -51,22 +51,26 @@ </para> </refsect1> - <!-- Use when examples exist <refsect1 role="examples"> &reftitle.examples; <para> <example> - <title><function>A PDO-query example</title> + <title>Demonstrate PDO::query</title> <para> - Any text that describes the purpose of the example, or - what goes on in the example should go here (inside the - <example> tag, not out + A nice feature of <function>PDO::query</function> is that it + enables you to iterate over the rowset returned by a + successfully executed SELECT statement. </para> <programlisting role="php"> <![CDATA[ <?php -if ($anexample === true) { - echo 'Use the PEAR Coding Standards'; +function getFruit($conn) { + $sql = 'SELECT name, colour, calories FROM fruit ORDER BY name'; + foreach ($conn->query($sql) as $row) { + print $row['NAME'] . "\t"; + print $row['COLOUR'] . "\t"; + print $row['CALORIES'] . "\n"; + } } ?> ]]> @@ -74,13 +78,18 @@ &example.outputs; <screen> <![CDATA[ -Use the PEAR Coding Standards +apple red 150 +banana yellow 250 +kiwi brown 75 +lemon yellow 25 +orange orange 300 +pear green 150 +watermelon pink 90 ]]> </screen> </example> </para> </refsect1> - --> <refsect1 role="seealso">