cvs: peardoc /en/package/database/db intro-fetch.xml

danielc Sat Mar 6 00:00:54 2004 EDT Modified files: /peardoc/en/package/database/db intro-fetch.xml Log: Clean up examples. http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-fetch.xml?r1=1.15&r2=1.16&ty=u Index: peardoc/en/package/database/db/intro-fetch.xml diff -u peardoc/en/package/database/db/intro-fetch.xml:1.15 peardoc/en/package/database/db/intro-fetch.xml:1.16 --- peardoc/en/package/database/db/intro-fetch.xml:1.15 Fri Mar 5 23:37:53 2004 +++ peardoc/en/package/database/db/intro-fetch.xml Sat Mar 6 00:00:53 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.15 $ --> +<!-- $Revision: 1.16 $ --> <refentry id="package.database.db.intro-fetch"> <refnamediv> <refname>Introduction - Fetch &amp; Get</refname> @@ -31,18 +31,18 @@ <![CDATA[ <?php // Once you have a valid DB object named $db... -$res =& $db->query("SELECT * FROM mytable"); +$res =& $db->query('SELECT * FROM mytable'); // Get each row of data on each iteration until // there are no more rows while ($row =& $res->fetchRow()) { - $id = $row[0]; + echo $row[0] . "\n"; } // Or: // an example using fetchInto() while ($res->fetchInto($row)) { - $id = $row[0]; + echo $row[0] . "\n"; } ?> ]]> @@ -67,24 +67,26 @@ <![CDATA[ <?php // Once you have a valid DB object named $db... -$res =& $db->query('SELECT id, name, email FROM users'); -$row =& $res->fetchRow(DB_FETCHMODE_ORDERED); +$db->setFetchMode(DB_FETCHMODE_ORDERED); +$res =& $db->query('INSERT INTO phptest ' + . "(a, b) VALUES (28, 'hi')"); +$res =& $db->query('SELECT * FROM phptest WHERE a = 28'); +$row =& $res->fetchRow(); + +print_r($row); +echo 'Column a is ' . $row[0]; /* - * $row will contain: - * array ( - * 0 => <column "id" data>, - * 1 => <column "name" data>, - * 2 => <column "email" data> + * Output... + * Array + * ( + * [0] => 28 + * [1] => hi * ) + * Column a is 28 */ - -// Access the data with: -$id = $row[0]; -$name = $row[1]; -$email = $row[2]; ?> -]]> + ]]> </programlisting> </example> </para> @@ -102,24 +104,26 @@ <![CDATA[ <?php // Once you have a valid DB object named $db... -$res =& $db->query('SELECT id, name, email FROM users'); -$row =& $res->fetchRow(DB_FETCHMODE_ASSOC); +$db->setFetchMode(DB_FETCHMODE_ASSOC); +$res =& $db->query('INSERT INTO phptest ' + . "(a, b) VALUES (28, 'hi')"); +$res =& $db->query('SELECT * FROM phptest WHERE a = 28'); +$row =& $res->fetchRow(); + +print_r($row); +echo 'Column a is ' . $row['a']; /* - * $row will contain: - * array ( - * 'id' => <column "id" data>, - * 'name' => <column "name" data>, - * 'email' => <column "email" data> + * Output... + * Array + * ( + * [a] => 28 + * [b] => hi * ) + * Column a is 28 */ - -// Access the data with: -$id = $row['id']; -$name = $row['name']; -$email = $row['email']; ?> -]]> + ]]> </programlisting> </example> </para> @@ -141,12 +145,9 @@ <![CDATA[ <?php // Once you have a valid DB object named $db... - +$db->setFetchMode(DB_FETCHMODE_OBJECT); $res =& $db->query('INSERT INTO phptest ' . "(a, b) VALUES (28, 'hi')"); - -$db->setFetchMode(DB_FETCHMODE_OBJECT); - $res =& $db->query('SELECT * FROM phptest WHERE a = 28'); $row =& $res->fetchRow(); @@ -177,12 +178,9 @@ <![CDATA[ <?php // Once you have a valid DB object named $db... - +$db->setFetchMode(DB_FETCHMODE_OBJECT, 'DB_row'); $res =& $db->query('INSERT INTO phptest ' . "(a, b) VALUES (28, 'hi')"); - -$db->setFetchMode(DB_FETCHMODE_OBJECT, 'DB_row'); - $res =& $db->query('SELECT * FROM phptest WHERE a = 28'); $row =& $res->fetchRow(); @@ -222,7 +220,7 @@ $res =& $db->query('SELECT * FROM users'); while ($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)) { - $id = $row['id']; + echo $row['id'] . "\n"; } ?> ]]> @@ -239,7 +237,7 @@ $res =& $db->query('SELECT * FROM users'); while ($row =& $res->fetchRow()) { - $id = $row['id']; + echo $row['id'] . "\n"; } ?> ]]> @@ -276,7 +274,7 @@ if (!$row =& $res->fetchRow($fetchmode, $rowNum)) { break; } - $id = $row[0]; + echo $row[0] . "\n"; .... } ?> @@ -430,11 +428,12 @@ <para> <link linkend="package.database.db.db-result.numrows"> <function>numRows</function></link>: Returns the total number of - rows returned from a "SELECT" query. + rows returned from a &quot;SELECT&quot; query. <programlisting role="php"> <![CDATA[ <?php -// Number of rows +// Once you have a valid DB object named $db... +$res =& $db->query('SELECT * FROM phptest'); echo $res->numRows(); ?> ]]> @@ -449,7 +448,8 @@ <programlisting role="php"> <![CDATA[ <?php -// Number of cols +// Once you have a valid DB object named $db... +$res =& $db->query('SELECT * FROM phptest'); echo $res->numCols(); ?> ]]> @@ -482,8 +482,9 @@ <programlisting role="php"> <![CDATA[ <?php -// Table Info -print_r($res->tableInfo()); +// Once you have a valid DB object named $db... +$res =& $db->query('SELECT * FROM phptest'); +print_r($db->tableInfo($res)); ?> ]]> </programlisting> @@ -518,4 +519,3 @@ vim: et tw=78 syn=sgml vi: ts=1 sw=1 --> -