cvs: peardoc /en/package/database/db/db-common affectedrows.xml autoexecute.xml autoprepare.xml createsequence.xml disconnect.xml dropsequence.xml
execute.xml executemultiple.xml freeprepared.xml getall.xml getassoc.xml getcol.xml getlistof.xml getone.xml getrow.xml limitquery.xml nextid.xml
prepare.xml provides.xml setfetchmode.xml
| From: | Daniel Convissor | Date: | Tue, 13 Apr 2004 22:12:59 +0000 |
| Subject: | cvs: peardoc /en/package/database/db/db-common affectedrows.xml autoexecute.xml autoprepare.xml createsequence.xml disconnect.xml dropsequence.xml execute.xml executemultiple.xml freeprepared.xml getall.xml getassoc.xml getcol.xml getlistof.xml getone.xml getrow.xml limitquery.xml nextid.xml prepare.xml provides.xml setfetchmode.xml |
||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-3386@lists.php.net to get a copy of this message | ||
danielc Tue Apr 13 18:12:59 2004 EDT
Modified files:
/peardoc/en/package/database/db/db-common affectedrows.xml
autoexecute.xml
autoprepare.xml
createsequence.xml
disconnect.xml
dropsequence.xml
execute.xml
executemultiple.xml
freeprepared.xml
getall.xml getassoc.xml
getcol.xml getlistof.xml
getone.xml getrow.xml
limitquery.xml nextid.xml
prepare.xml provides.xml
setfetchmode.xml
Log:
Add example.
http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/affectedrows.xml?r1=1.15&r2=1.16&ty=u Index: peardoc/en/package/database/db/db-common/affectedrows.xml diff -u peardoc/en/package/database/db/db-common/affectedrows.xml:1.15 peardoc/en/package/database/db/db-common/affectedrows.xml:1.16 --- peardoc/en/package/database/db/db-common/affectedrows.xml:1.15 Tue Apr 13 16:13:47 2004 +++ peardoc/en/package/database/db/db-common/affectedrows.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.15 $ --> +<!-- $Revision: 1.16 $ --> <refentry id="package.database.db.db-common.affectedrows"> <refnamediv> @@ -79,7 +79,12 @@ <![CDATA[ <?php // Once you have a valid DB object named $db... -$db->query('DELETE * FROM clients'); +$result =& $db->query('DELETE * FROM clients'); + +if (DB::isError($result)) { + die($result->getMessage()); +} + echo 'I have deleted ' . $db->affectedRows() . ' clients'; ?> ]]> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/autoexecute.xml?r1=1.19&r2=1.20&ty=u Index: peardoc/en/package/database/db/db-common/autoexecute.xml diff -u peardoc/en/package/database/db/db-common/autoexecute.xml:1.19 peardoc/en/package/database/db/db-common/autoexecute.xml:1.20 --- peardoc/en/package/database/db/db-common/autoexecute.xml:1.19 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/autoexecute.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.19 $ --> +<!-- $Revision: 1.20 $ --> <refentry id="package.database.db.db-common.autoexecute"> <refnamediv> @@ -171,6 +171,34 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.autoexecute.example"> + &title.example; + <example> + <title>Using <function>autoExecute</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$table_name = 'user'; + +$fields_values = array( + 'id' => 1, + 'name' => 'Fabien', + 'country' => 'France' +); + +$result = $db->autoExecute($table_name, $fields_values, + DB_AUTOQUERY_INSERT); + +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.autoexecute.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/autoprepare.xml?r1=1.18&r2=1.19&ty=u Index: peardoc/en/package/database/db/db-common/autoprepare.xml diff -u peardoc/en/package/database/db/db-common/autoprepare.xml:1.18 peardoc/en/package/database/db/db-common/autoprepare.xml:1.19 --- peardoc/en/package/database/db/db-common/autoprepare.xml:1.18 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/autoprepare.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.18 $ --> +<!-- $Revision: 1.19 $ --> <refentry id="package.database.db.db-common.autoprepare"> <refnamediv> @@ -164,6 +164,36 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.autoprepare.example"> + &title.example; + <example> + <title>Using <function>autoPrepare</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$table_name = 'user'; +$table_fields = array('name', 'country'); +$table_values = array('Bob', 'USA'); + +$sth = $db->autoPrepare($table_name, $table_fields, + DB_AUTOQUERY_UPDATE, 'id = 1'); + +if (DB::isError($sth)) { + die($sth->getMessage()); +} + +$result =& $db->execute($sth, $table_values); + +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.autoprepare.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/createsequence.xml?r1=1.11&r2=1.12&ty=u Index: peardoc/en/package/database/db/db-common/createsequence.xml diff -u peardoc/en/package/database/db/db-common/createsequence.xml:1.11 peardoc/en/package/database/db/db-common/createsequence.xml:1.12 --- peardoc/en/package/database/db/db-common/createsequence.xml:1.11 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/createsequence.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.11 $ --> +<!-- $Revision: 1.12 $ --> <refentry id="package.database.db.db-common.createsequence"> <refnamediv> @@ -88,6 +88,25 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.createsequence.example"> + &title.example; + <example> + <title>Using <function>createSequence</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$tmp = $db->createSequence('mySequence'); + +if (DB::isError($tmp)) { + die($tmp->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.createsequence.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/disconnect.xml?r1=1.12&r2=1.13&ty=u Index: peardoc/en/package/database/db/db-common/disconnect.xml diff -u peardoc/en/package/database/db/db-common/disconnect.xml:1.12 peardoc/en/package/database/db/db-common/disconnect.xml:1.13 --- peardoc/en/package/database/db/db-common/disconnect.xml:1.12 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/disconnect.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.12 $ --> +<!-- $Revision: 1.13 $ --> <refentry id="package.database.db.db-common.disconnect"> <refnamediv> @@ -33,6 +33,27 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.disconnect.example"> + &title.example; + <example> + <title>Using <function>disconnect</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +require_once 'DB.php'; + +$db =& DB::connect('pgsql://someuser:apasswd@localhost/thedb'); +if (DB::isError($db)) { + die($db->getMessage()); +} + +$db->disconnect(); +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.disconnect.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/dropsequence.xml?r1=1.11&r2=1.12&ty=u Index: peardoc/en/package/database/db/db-common/dropsequence.xml diff -u peardoc/en/package/database/db/db-common/dropsequence.xml:1.11 peardoc/en/package/database/db/db-common/dropsequence.xml:1.12 --- peardoc/en/package/database/db/db-common/dropsequence.xml:1.11 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/dropsequence.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.11 $ --> +<!-- $Revision: 1.12 $ --> <refentry id="package.database.db.db-common.dropsequence"> <refnamediv> @@ -94,6 +94,25 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.dropsequence.example"> + &title.example; + <example> + <title>Using <function>dropSequence</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$tmp = $db->dropSequence('mySequence'); + +if (DB::isError($tmp)) { + die($tmp->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.dropsequence.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/execute.xml?r1=1.17&r2=1.18&ty=u Index: peardoc/en/package/database/db/db-common/execute.xml diff -u peardoc/en/package/database/db/db-common/execute.xml:1.17 peardoc/en/package/database/db/db-common/execute.xml:1.18 --- peardoc/en/package/database/db/db-common/execute.xml:1.17 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/execute.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.17 $ --> +<!-- $Revision: 1.18 $ --> <refentry id="package.database.db.db-common.execute"> <refnamediv> @@ -159,6 +159,44 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.execute.example"> + &title.example; + <example> + <title>Passing a scalar to <function>execute</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers (number) VALUES (?)'); +if (DB::isError($sth)) { + die($sth->getMessage()); +} + +$result =& $db->execute($sth, 1); +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + + <example> + <title>Passing an array to <function>execute</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers VALUES (?, ?, ?)'); + +$data = array(1, 'one', 'en'); +$db->execute($sth, $row); +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.execute.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/executemultiple.xml?r1=1.16&r2=1.17&ty=u Index: peardoc/en/package/database/db/db-common/executemultiple.xml diff -u peardoc/en/package/database/db/db-common/executemultiple.xml:1.16 peardoc/en/package/database/db/db-common/executemultiple.xml:1.17 --- peardoc/en/package/database/db/db-common/executemultiple.xml:1.16 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/executemultiple.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.16 $ --> +<!-- $Revision: 1.17 $ --> <refentry id="package.database.db.db-common.executemultiple"> <refnamediv> @@ -167,6 +167,36 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.executemultiple.example"> + &title.example; + <example> + <title>Using <function>executeMultiple</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers VALUES (?, ?, ?)'); + +if (DB::isError($sth)) { + die($sth->getMessage()); +} + +$alldata = array(array(1, 'one', 'en'), + array(2, 'two', 'to'), + array(3, 'three', 'tre'), + array(4, 'four', 'fire')); + +$result =& $db->executeMultiple($sth, $alldata); + +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.executemultiple.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/freeprepared.xml?r1=1.4&r2=1.5&ty=u Index: peardoc/en/package/database/db/db-common/freeprepared.xml diff -u peardoc/en/package/database/db/db-common/freeprepared.xml:1.4 peardoc/en/package/database/db/db-common/freeprepared.xml:1.5 --- peardoc/en/package/database/db/db-common/freeprepared.xml:1.4 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/freeprepared.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.4 $ --> +<!-- $Revision: 1.5 $ --> <refentry id="package.database.db.db-common.freeprepared"> <refnamediv> @@ -62,6 +62,23 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.freeprepared.example"> + &title.example; + <example> + <title>Using <function>freePrepared</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers (number) VALUES (?)'); +$db->execute($sth, 1); +$db->freePrepared($sth); +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.freeprepared.see"> &title.see; <para> @@ -71,7 +88,6 @@ <function>free</function></link> </para> </refsect1> - </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getall.xml?r1=1.17&r2=1.18&ty=u Index: peardoc/en/package/database/db/db-common/getall.xml diff -u peardoc/en/package/database/db/db-common/getall.xml:1.17 peardoc/en/package/database/db/db-common/getall.xml:1.18 --- peardoc/en/package/database/db/db-common/getall.xml:1.17 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getall.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.17 $ --> +<!-- $Revision: 1.18 $ --> <refentry id="package.database.db.db-common.getall"> <refnamediv> @@ -180,6 +180,34 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.getall.example"> + &title.example; + <example> + <title>Using <function>getAll</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$data =& $db->getAll('SELECT id, text, date FROM mytable'); + +if (DB::isError($data)) { + die($data->getMessage()); +} + +/* + * Returns: + * array( + * 0 => array('4', 'four', '2004'), + * 1 => array('5', 'five', '2005'), + * 2 => array('6', 'six', '2006') + * ) + */ +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getall.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getassoc.xml?r1=1.19&r2=1.20&ty=u Index: peardoc/en/package/database/db/db-common/getassoc.xml diff -u peardoc/en/package/database/db/db-common/getassoc.xml:1.19 peardoc/en/package/database/db/db-common/getassoc.xml:1.20 --- peardoc/en/package/database/db/db-common/getassoc.xml:1.19 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getassoc.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.19 $ --> +<!-- $Revision: 1.20 $ --> <refentry id="package.database.db.db-common.getassoc"> <refnamediv> @@ -234,6 +234,34 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common..example"> + &title.example; + <example> + <title>Using <function></function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$data =& $db->getAssoc('SELECT name, surname, phone FROM mytable'); + +if (DB::isError($data)) { + die($data->getMessage()); +} + +/* + * Returns: + * array( + * 'Peter' => array('Smith', '944679408'), + * 'Tomas' => array('Cox', '944679408'), + * 'Richard' => array('Merz', '944679408') + * ) + */ +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getassoc.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getcol.xml?r1=1.18&r2=1.19&ty=u Index: peardoc/en/package/database/db/db-common/getcol.xml diff -u peardoc/en/package/database/db/db-common/getcol.xml:1.18 peardoc/en/package/database/db/db-common/getcol.xml:1.19 --- peardoc/en/package/database/db/db-common/getcol.xml:1.18 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getcol.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.18 $ --> +<!-- $Revision: 1.19 $ --> <refentry id="package.database.db.db-common.getcol"> <refnamediv> @@ -188,6 +188,34 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.getcol.example"> + &title.example; + <example> + <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'); + +if (DB::isError($data)) { + die($data->getMessage()); +} + +/* + * Returns: + * array( + * 0 => 'Stig', + * 1 => 'Jon', + * 2 => 'Colin' + * ) + */ +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getcol.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getlistof.xml?r1=1.12&r2=1.13&ty=u Index: peardoc/en/package/database/db/db-common/getlistof.xml diff -u peardoc/en/package/database/db/db-common/getlistof.xml:1.12 peardoc/en/package/database/db/db-common/getlistof.xml:1.13 --- peardoc/en/package/database/db/db-common/getlistof.xml:1.12 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getlistof.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.12 $ --> +<!-- $Revision: 1.13 $ --> <refentry id="package.database.db.db-common.getlistof"> <refnamediv> @@ -92,6 +92,27 @@ &title.note; ¬e.notstatic; </refsect1> + + <refsect1 id="package.database.db.db-common.getListOf.example"> + &title.example; + <example> + <title>Using <function>getListOf</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$data = $db->getListOf('tables'); + +if (DB::isError($data)) { + die($data->getMessage()); +} + +echo implode("\n", $data); +?> + ]]> + </programlisting> + </example> + </refsect1> </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getone.xml?r1=1.18&r2=1.19&ty=u Index: peardoc/en/package/database/db/db-common/getone.xml diff -u peardoc/en/package/database/db/db-common/getone.xml:1.18 peardoc/en/package/database/db/db-common/getone.xml:1.19 --- peardoc/en/package/database/db/db-common/getone.xml:1.18 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getone.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.18 $ --> +<!-- $Revision: 1.19 $ --> <refentry id="package.database.db.db-common.getone"> <refnamediv> @@ -158,6 +158,27 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.getOne.example"> + &title.example; + <example> + <title>Using <function>getOne</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$numrows = $db->getOne('select count(id) from clients'); + +if (DB::isError($numrows)) { + die($numrows->getMessage()); +} + +// Returns: 3 +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getone.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getrow.xml?r1=1.18&r2=1.19&ty=u Index: peardoc/en/package/database/db/db-common/getrow.xml diff -u peardoc/en/package/database/db/db-common/getrow.xml:1.18 peardoc/en/package/database/db/db-common/getrow.xml:1.19 --- peardoc/en/package/database/db/db-common/getrow.xml:1.18 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getrow.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.18 $ --> +<!-- $Revision: 1.19 $ --> <refentry id="package.database.db.db-common.getrow"> <refnamediv> @@ -173,6 +173,27 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.getrow.example"> + &title.example; + <example> + <title>Using <function>getRow</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$row =& $db->getRow('select name, address from clients'); + +if (DB::isError($row)) { + die($row->getMessage()); +} + +echo $row['name'] . ', ' . $row['address'] . "\n"; +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getrow.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/limitquery.xml?r1=1.15&r2=1.16&ty=u Index: peardoc/en/package/database/db/db-common/limitquery.xml diff -u peardoc/en/package/database/db/db-common/limitquery.xml:1.15 peardoc/en/package/database/db/db-common/limitquery.xml:1.16 --- peardoc/en/package/database/db/db-common/limitquery.xml:1.15 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/limitquery.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.15 $ --> +<!-- $Revision: 1.16 $ --> <refentry id="package.database.db.db-common.limitquery"> <refnamediv> @@ -136,6 +136,25 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.limitquery.example"> + &title.example; + <example> + <title>Using <function>limitQuery</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$result =& $db->limitQuery('SELECT * FROM foo', 50, 10); + +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.limitquery.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/nextid.xml?r1=1.14&r2=1.15&ty=u Index: peardoc/en/package/database/db/db-common/nextid.xml diff -u peardoc/en/package/database/db/db-common/nextid.xml:1.14 peardoc/en/package/database/db/db-common/nextid.xml:1.15 --- peardoc/en/package/database/db/db-common/nextid.xml:1.14 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/nextid.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.14 $ --> +<!-- $Revision: 1.15 $ --> <refentry id="package.database.db.db-common.nextid"> <refnamediv> @@ -130,6 +130,27 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.nextid.example"> + &title.example; + <example> + <title>Using <function>nextId</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$id = $db->nextId('mySequence'); +if (DB::isError($id)) { + die($id->getMessage()); +} + +// Use the ID in your INSERT query +$res =& $db->query("INSERT INTO myTable (id, text) VALUES ($id, 'foo')"); +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.nextid.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/prepare.xml?r1=1.14&r2=1.15&ty=u Index: peardoc/en/package/database/db/db-common/prepare.xml diff -u peardoc/en/package/database/db/db-common/prepare.xml:1.14 peardoc/en/package/database/db/db-common/prepare.xml:1.15 --- peardoc/en/package/database/db/db-common/prepare.xml:1.14 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/prepare.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.14 $ --> +<!-- $Revision: 1.15 $ --> <refentry id="package.database.db.db-common.prepare"> <refnamediv> @@ -58,6 +58,29 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.prepare.example"> + &title.example; + <example> + <title>Using <function>prepare</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers (number) VALUES (?)'); +if (DB::isError($sth)) { + die($sth->getMessage()); +} + +$result =& $db->execute($sth, 1); +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.prepare.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/provides.xml?r1=1.13&r2=1.14&ty=u Index: peardoc/en/package/database/db/db-common/provides.xml diff -u peardoc/en/package/database/db/db-common/provides.xml:1.13 peardoc/en/package/database/db/db-common/provides.xml:1.14 --- peardoc/en/package/database/db/db-common/provides.xml:1.13 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/provides.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.13 $ --> +<!-- $Revision: 1.14 $ --> <refentry id="package.database.db.db-common.provides"> <refnamediv> @@ -97,6 +97,23 @@ </para> </warning> </refsect1> + + <refsect1 id="package.database.db.db-common.provides.example"> + &title.example; + <example> + <title>Using <function>provides</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +if ($db->provides('pconnect')) { + echo "Persistent connections are allowed.\n"; +} +?> + ]]> + </programlisting> + </example> + </refsect1> </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/setfetchmode.xml?r1=1.15&r2=1.16&ty=u Index: peardoc/en/package/database/db/db-common/setfetchmode.xml diff -u peardoc/en/package/database/db/db-common/setfetchmode.xml:1.15 peardoc/en/package/database/db/db-common/setfetchmode.xml:1.16 --- peardoc/en/package/database/db/db-common/setfetchmode.xml:1.15 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/setfetchmode.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.15 $ --> +<!-- $Revision: 1.16 $ --> <refentry id="package.database.db.db-common.setfetchmode"> <refnamediv> @@ -112,6 +112,21 @@ &title.note; ¬e.notstatic; </refsect1> + + <refsect1 id="package.database.db.db-common.setfetchmode.example"> + &title.example; + <example> + <title>Using <function>setFetchMode</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$db->setFetchMode(DB_FETCHMODE_ORDERED); +?> + ]]> + </programlisting> + </example> + </refsect1> </refentry> <!-- Keep this comment at the end of the file
http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/affectedrows.xml?r1=1.15&r2=1.16&ty=u Index: peardoc/en/package/database/db/db-common/affectedrows.xml diff -u peardoc/en/package/database/db/db-common/affectedrows.xml:1.15 peardoc/en/package/database/db/db-common/affectedrows.xml:1.16 --- peardoc/en/package/database/db/db-common/affectedrows.xml:1.15 Tue Apr 13 16:13:47 2004 +++ peardoc/en/package/database/db/db-common/affectedrows.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.15 $ --> +<!-- $Revision: 1.16 $ --> <refentry id="package.database.db.db-common.affectedrows"> <refnamediv> @@ -79,7 +79,12 @@ <![CDATA[ <?php // Once you have a valid DB object named $db... -$db->query('DELETE * FROM clients'); +$result =& $db->query('DELETE * FROM clients'); + +if (DB::isError($result)) { + die($result->getMessage()); +} + echo 'I have deleted ' . $db->affectedRows() . ' clients'; ?> ]]> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/autoexecute.xml?r1=1.19&r2=1.20&ty=u Index: peardoc/en/package/database/db/db-common/autoexecute.xml diff -u peardoc/en/package/database/db/db-common/autoexecute.xml:1.19 peardoc/en/package/database/db/db-common/autoexecute.xml:1.20 --- peardoc/en/package/database/db/db-common/autoexecute.xml:1.19 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/autoexecute.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.19 $ --> +<!-- $Revision: 1.20 $ --> <refentry id="package.database.db.db-common.autoexecute"> <refnamediv> @@ -171,6 +171,34 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.autoexecute.example"> + &title.example; + <example> + <title>Using <function>autoExecute</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$table_name = 'user'; + +$fields_values = array( + 'id' => 1, + 'name' => 'Fabien', + 'country' => 'France' +); + +$result = $db->autoExecute($table_name, $fields_values, + DB_AUTOQUERY_INSERT); + +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.autoexecute.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/autoprepare.xml?r1=1.18&r2=1.19&ty=u Index: peardoc/en/package/database/db/db-common/autoprepare.xml diff -u peardoc/en/package/database/db/db-common/autoprepare.xml:1.18 peardoc/en/package/database/db/db-common/autoprepare.xml:1.19 --- peardoc/en/package/database/db/db-common/autoprepare.xml:1.18 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/autoprepare.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.18 $ --> +<!-- $Revision: 1.19 $ --> <refentry id="package.database.db.db-common.autoprepare"> <refnamediv> @@ -164,6 +164,36 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.autoprepare.example"> + &title.example; + <example> + <title>Using <function>autoPrepare</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$table_name = 'user'; +$table_fields = array('name', 'country'); +$table_values = array('Bob', 'USA'); + +$sth = $db->autoPrepare($table_name, $table_fields, + DB_AUTOQUERY_UPDATE, 'id = 1'); + +if (DB::isError($sth)) { + die($sth->getMessage()); +} + +$result =& $db->execute($sth, $table_values); + +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.autoprepare.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/createsequence.xml?r1=1.11&r2=1.12&ty=u Index: peardoc/en/package/database/db/db-common/createsequence.xml diff -u peardoc/en/package/database/db/db-common/createsequence.xml:1.11 peardoc/en/package/database/db/db-common/createsequence.xml:1.12 --- peardoc/en/package/database/db/db-common/createsequence.xml:1.11 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/createsequence.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.11 $ --> +<!-- $Revision: 1.12 $ --> <refentry id="package.database.db.db-common.createsequence"> <refnamediv> @@ -88,6 +88,25 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.createsequence.example"> + &title.example; + <example> + <title>Using <function>createSequence</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$tmp = $db->createSequence('mySequence'); + +if (DB::isError($tmp)) { + die($tmp->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.createsequence.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/disconnect.xml?r1=1.12&r2=1.13&ty=u Index: peardoc/en/package/database/db/db-common/disconnect.xml diff -u peardoc/en/package/database/db/db-common/disconnect.xml:1.12 peardoc/en/package/database/db/db-common/disconnect.xml:1.13 --- peardoc/en/package/database/db/db-common/disconnect.xml:1.12 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/disconnect.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.12 $ --> +<!-- $Revision: 1.13 $ --> <refentry id="package.database.db.db-common.disconnect"> <refnamediv> @@ -33,6 +33,27 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.disconnect.example"> + &title.example; + <example> + <title>Using <function>disconnect</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +require_once 'DB.php'; + +$db =& DB::connect('pgsql://someuser:apasswd@localhost/thedb'); +if (DB::isError($db)) { + die($db->getMessage()); +} + +$db->disconnect(); +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.disconnect.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/dropsequence.xml?r1=1.11&r2=1.12&ty=u Index: peardoc/en/package/database/db/db-common/dropsequence.xml diff -u peardoc/en/package/database/db/db-common/dropsequence.xml:1.11 peardoc/en/package/database/db/db-common/dropsequence.xml:1.12 --- peardoc/en/package/database/db/db-common/dropsequence.xml:1.11 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/dropsequence.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.11 $ --> +<!-- $Revision: 1.12 $ --> <refentry id="package.database.db.db-common.dropsequence"> <refnamediv> @@ -94,6 +94,25 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.dropsequence.example"> + &title.example; + <example> + <title>Using <function>dropSequence</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$tmp = $db->dropSequence('mySequence'); + +if (DB::isError($tmp)) { + die($tmp->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.dropsequence.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/execute.xml?r1=1.17&r2=1.18&ty=u Index: peardoc/en/package/database/db/db-common/execute.xml diff -u peardoc/en/package/database/db/db-common/execute.xml:1.17 peardoc/en/package/database/db/db-common/execute.xml:1.18 --- peardoc/en/package/database/db/db-common/execute.xml:1.17 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/execute.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.17 $ --> +<!-- $Revision: 1.18 $ --> <refentry id="package.database.db.db-common.execute"> <refnamediv> @@ -159,6 +159,44 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.execute.example"> + &title.example; + <example> + <title>Passing a scalar to <function>execute</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers (number) VALUES (?)'); +if (DB::isError($sth)) { + die($sth->getMessage()); +} + +$result =& $db->execute($sth, 1); +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + + <example> + <title>Passing an array to <function>execute</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers VALUES (?, ?, ?)'); + +$data = array(1, 'one', 'en'); +$db->execute($sth, $row); +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.execute.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/executemultiple.xml?r1=1.16&r2=1.17&ty=u Index: peardoc/en/package/database/db/db-common/executemultiple.xml diff -u peardoc/en/package/database/db/db-common/executemultiple.xml:1.16 peardoc/en/package/database/db/db-common/executemultiple.xml:1.17 --- peardoc/en/package/database/db/db-common/executemultiple.xml:1.16 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/executemultiple.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.16 $ --> +<!-- $Revision: 1.17 $ --> <refentry id="package.database.db.db-common.executemultiple"> <refnamediv> @@ -167,6 +167,36 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.executemultiple.example"> + &title.example; + <example> + <title>Using <function>executeMultiple</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers VALUES (?, ?, ?)'); + +if (DB::isError($sth)) { + die($sth->getMessage()); +} + +$alldata = array(array(1, 'one', 'en'), + array(2, 'two', 'to'), + array(3, 'three', 'tre'), + array(4, 'four', 'fire')); + +$result =& $db->executeMultiple($sth, $alldata); + +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.executemultiple.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/freeprepared.xml?r1=1.4&r2=1.5&ty=u Index: peardoc/en/package/database/db/db-common/freeprepared.xml diff -u peardoc/en/package/database/db/db-common/freeprepared.xml:1.4 peardoc/en/package/database/db/db-common/freeprepared.xml:1.5 --- peardoc/en/package/database/db/db-common/freeprepared.xml:1.4 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/freeprepared.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.4 $ --> +<!-- $Revision: 1.5 $ --> <refentry id="package.database.db.db-common.freeprepared"> <refnamediv> @@ -62,6 +62,23 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.freeprepared.example"> + &title.example; + <example> + <title>Using <function>freePrepared</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers (number) VALUES (?)'); +$db->execute($sth, 1); +$db->freePrepared($sth); +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.freeprepared.see"> &title.see; <para> @@ -71,7 +88,6 @@ <function>free</function></link> </para> </refsect1> - </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getall.xml?r1=1.17&r2=1.18&ty=u Index: peardoc/en/package/database/db/db-common/getall.xml diff -u peardoc/en/package/database/db/db-common/getall.xml:1.17 peardoc/en/package/database/db/db-common/getall.xml:1.18 --- peardoc/en/package/database/db/db-common/getall.xml:1.17 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getall.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.17 $ --> +<!-- $Revision: 1.18 $ --> <refentry id="package.database.db.db-common.getall"> <refnamediv> @@ -180,6 +180,34 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.getall.example"> + &title.example; + <example> + <title>Using <function>getAll</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$data =& $db->getAll('SELECT id, text, date FROM mytable'); + +if (DB::isError($data)) { + die($data->getMessage()); +} + +/* + * Returns: + * array( + * 0 => array('4', 'four', '2004'), + * 1 => array('5', 'five', '2005'), + * 2 => array('6', 'six', '2006') + * ) + */ +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getall.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getassoc.xml?r1=1.19&r2=1.20&ty=u Index: peardoc/en/package/database/db/db-common/getassoc.xml diff -u peardoc/en/package/database/db/db-common/getassoc.xml:1.19 peardoc/en/package/database/db/db-common/getassoc.xml:1.20 --- peardoc/en/package/database/db/db-common/getassoc.xml:1.19 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getassoc.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.19 $ --> +<!-- $Revision: 1.20 $ --> <refentry id="package.database.db.db-common.getassoc"> <refnamediv> @@ -234,6 +234,34 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common..example"> + &title.example; + <example> + <title>Using <function></function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$data =& $db->getAssoc('SELECT name, surname, phone FROM mytable'); + +if (DB::isError($data)) { + die($data->getMessage()); +} + +/* + * Returns: + * array( + * 'Peter' => array('Smith', '944679408'), + * 'Tomas' => array('Cox', '944679408'), + * 'Richard' => array('Merz', '944679408') + * ) + */ +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getassoc.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getcol.xml?r1=1.18&r2=1.19&ty=u Index: peardoc/en/package/database/db/db-common/getcol.xml diff -u peardoc/en/package/database/db/db-common/getcol.xml:1.18 peardoc/en/package/database/db/db-common/getcol.xml:1.19 --- peardoc/en/package/database/db/db-common/getcol.xml:1.18 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getcol.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.18 $ --> +<!-- $Revision: 1.19 $ --> <refentry id="package.database.db.db-common.getcol"> <refnamediv> @@ -188,6 +188,34 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.getcol.example"> + &title.example; + <example> + <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'); + +if (DB::isError($data)) { + die($data->getMessage()); +} + +/* + * Returns: + * array( + * 0 => 'Stig', + * 1 => 'Jon', + * 2 => 'Colin' + * ) + */ +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getcol.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getlistof.xml?r1=1.12&r2=1.13&ty=u Index: peardoc/en/package/database/db/db-common/getlistof.xml diff -u peardoc/en/package/database/db/db-common/getlistof.xml:1.12 peardoc/en/package/database/db/db-common/getlistof.xml:1.13 --- peardoc/en/package/database/db/db-common/getlistof.xml:1.12 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getlistof.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.12 $ --> +<!-- $Revision: 1.13 $ --> <refentry id="package.database.db.db-common.getlistof"> <refnamediv> @@ -92,6 +92,27 @@ &title.note; ¬e.notstatic; </refsect1> + + <refsect1 id="package.database.db.db-common.getListOf.example"> + &title.example; + <example> + <title>Using <function>getListOf</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$data = $db->getListOf('tables'); + +if (DB::isError($data)) { + die($data->getMessage()); +} + +echo implode("\n", $data); +?> + ]]> + </programlisting> + </example> + </refsect1> </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getone.xml?r1=1.18&r2=1.19&ty=u Index: peardoc/en/package/database/db/db-common/getone.xml diff -u peardoc/en/package/database/db/db-common/getone.xml:1.18 peardoc/en/package/database/db/db-common/getone.xml:1.19 --- peardoc/en/package/database/db/db-common/getone.xml:1.18 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getone.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.18 $ --> +<!-- $Revision: 1.19 $ --> <refentry id="package.database.db.db-common.getone"> <refnamediv> @@ -158,6 +158,27 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.getOne.example"> + &title.example; + <example> + <title>Using <function>getOne</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$numrows = $db->getOne('select count(id) from clients'); + +if (DB::isError($numrows)) { + die($numrows->getMessage()); +} + +// Returns: 3 +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getone.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/getrow.xml?r1=1.18&r2=1.19&ty=u Index: peardoc/en/package/database/db/db-common/getrow.xml diff -u peardoc/en/package/database/db/db-common/getrow.xml:1.18 peardoc/en/package/database/db/db-common/getrow.xml:1.19 --- peardoc/en/package/database/db/db-common/getrow.xml:1.18 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/getrow.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.18 $ --> +<!-- $Revision: 1.19 $ --> <refentry id="package.database.db.db-common.getrow"> <refnamediv> @@ -173,6 +173,27 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.getrow.example"> + &title.example; + <example> + <title>Using <function>getRow</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$row =& $db->getRow('select name, address from clients'); + +if (DB::isError($row)) { + die($row->getMessage()); +} + +echo $row['name'] . ', ' . $row['address'] . "\n"; +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.getrow.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/limitquery.xml?r1=1.15&r2=1.16&ty=u Index: peardoc/en/package/database/db/db-common/limitquery.xml diff -u peardoc/en/package/database/db/db-common/limitquery.xml:1.15 peardoc/en/package/database/db/db-common/limitquery.xml:1.16 --- peardoc/en/package/database/db/db-common/limitquery.xml:1.15 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/limitquery.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.15 $ --> +<!-- $Revision: 1.16 $ --> <refentry id="package.database.db.db-common.limitquery"> <refnamediv> @@ -136,6 +136,25 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.limitquery.example"> + &title.example; + <example> + <title>Using <function>limitQuery</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$result =& $db->limitQuery('SELECT * FROM foo', 50, 10); + +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.limitquery.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/nextid.xml?r1=1.14&r2=1.15&ty=u Index: peardoc/en/package/database/db/db-common/nextid.xml diff -u peardoc/en/package/database/db/db-common/nextid.xml:1.14 peardoc/en/package/database/db/db-common/nextid.xml:1.15 --- peardoc/en/package/database/db/db-common/nextid.xml:1.14 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/nextid.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.14 $ --> +<!-- $Revision: 1.15 $ --> <refentry id="package.database.db.db-common.nextid"> <refnamediv> @@ -130,6 +130,27 @@ ¬e.notstatic; </refsect1> + <refsect1 id="package.database.db.db-common.nextid.example"> + &title.example; + <example> + <title>Using <function>nextId</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$id = $db->nextId('mySequence'); +if (DB::isError($id)) { + die($id->getMessage()); +} + +// Use the ID in your INSERT query +$res =& $db->query("INSERT INTO myTable (id, text) VALUES ($id, 'foo')"); +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.nextid.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/prepare.xml?r1=1.14&r2=1.15&ty=u Index: peardoc/en/package/database/db/db-common/prepare.xml diff -u peardoc/en/package/database/db/db-common/prepare.xml:1.14 peardoc/en/package/database/db/db-common/prepare.xml:1.15 --- peardoc/en/package/database/db/db-common/prepare.xml:1.14 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/prepare.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.14 $ --> +<!-- $Revision: 1.15 $ --> <refentry id="package.database.db.db-common.prepare"> <refnamediv> @@ -58,6 +58,29 @@ </para> </refsect1> + <refsect1 id="package.database.db.db-common.prepare.example"> + &title.example; + <example> + <title>Using <function>prepare</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$sth = $db->prepare('INSERT INTO numbers (number) VALUES (?)'); +if (DB::isError($sth)) { + die($sth->getMessage()); +} + +$result =& $db->execute($sth, 1); +if (DB::isError($result)) { + die($result->getMessage()); +} +?> + ]]> + </programlisting> + </example> + </refsect1> + <refsect1 id="package.database.db.db-common.prepare.see"> &title.see; <para> http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/provides.xml?r1=1.13&r2=1.14&ty=u Index: peardoc/en/package/database/db/db-common/provides.xml diff -u peardoc/en/package/database/db/db-common/provides.xml:1.13 peardoc/en/package/database/db/db-common/provides.xml:1.14 --- peardoc/en/package/database/db/db-common/provides.xml:1.13 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/provides.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.13 $ --> +<!-- $Revision: 1.14 $ --> <refentry id="package.database.db.db-common.provides"> <refnamediv> @@ -97,6 +97,23 @@ </para> </warning> </refsect1> + + <refsect1 id="package.database.db.db-common.provides.example"> + &title.example; + <example> + <title>Using <function>provides</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +if ($db->provides('pconnect')) { + echo "Persistent connections are allowed.\n"; +} +?> + ]]> + </programlisting> + </example> + </refsect1> </refentry> <!-- Keep this comment at the end of the file http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/setfetchmode.xml?r1=1.15&r2=1.16&ty=u Index: peardoc/en/package/database/db/db-common/setfetchmode.xml diff -u peardoc/en/package/database/db/db-common/setfetchmode.xml:1.15 peardoc/en/package/database/db/db-common/setfetchmode.xml:1.16 --- peardoc/en/package/database/db/db-common/setfetchmode.xml:1.15 Tue Apr 13 14:55:00 2004 +++ peardoc/en/package/database/db/db-common/setfetchmode.xml Tue Apr 13 18:12:59 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.15 $ --> +<!-- $Revision: 1.16 $ --> <refentry id="package.database.db.db-common.setfetchmode"> <refnamediv> @@ -112,6 +112,21 @@ &title.note; ¬e.notstatic; </refsect1> + + <refsect1 id="package.database.db.db-common.setfetchmode.example"> + &title.example; + <example> + <title>Using <function>setFetchMode</function></title> + <programlisting role="php"> + <![CDATA[ +<?php +// Once you have a valid DB object named $db... +$db->setFetchMode(DB_FETCHMODE_ORDERED); +?> + ]]> + </programlisting> + </example> + </refsect1> </refentry> <!-- Keep this comment at the end of the file