cvs: peardoc /en/package/database/db intro-auto.xml
| From: | Daniel Convissor | Date: | Tue, 30 Mar 2004 01:03:38 +0000 |
| Subject: | cvs: peardoc /en/package/database/db intro-auto.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-3138@lists.php.net to get a copy of this message | ||
danielc Mon Mar 29 20:03:38 2004 EDT
Modified files:
/peardoc/en/package/database/db intro-auto.xml
Log:
In examples, place results of autoExecute() in $results and then check that for errors. Also
check $sth for errors from autoPrepare().
http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-auto.xml?r1=1.16&r2=1.17&ty=u
Index: peardoc/en/package/database/db/intro-auto.xml
diff -u peardoc/en/package/database/db/intro-auto.xml:1.16
peardoc/en/package/database/db/intro-auto.xml:1.17
--- peardoc/en/package/database/db/intro-auto.xml:1.16 Mon Mar 29 19:45:25 2004
+++ peardoc/en/package/database/db/intro-auto.xml Mon Mar 29 20:03:38 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.16 $ -->
+<!-- $Revision: 1.17 $ -->
<refentry id="package.database.db.intro-auto">
<refnamediv>
<refname>Introduction - autoPrepare & autoExecute</refname>
@@ -48,6 +48,9 @@
$table_name = 'user';
$table_fields = array('id', 'name', 'country');
$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
+if (DB::isError($sth)) {
+ die($sth->getMessage());
+}
]]>
</programlisting>
@@ -72,8 +75,13 @@
$table_name = 'user';
$table_fields = array('id', 'name', 'country');
$table_values = array(1, 'Fabien', 'France');
-$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
-$db->execute($sth, $table_values);
+$sth = $db->autoPrepare($table_name, $table_fields,
+ DB_AUTOQUERY_INSERT);
+
+$result =& $db->execute($sth, $table_values);
+if (DB::isError($result)) {
+ die($result->getMessage());
+}
]]>
</programlisting>
@@ -89,7 +97,16 @@
$table_values = array('Bob', 'USA');
$sth = $db->autoPrepare($table_name, $table_fields,
DB_AUTOQUERY_UPDATE, 'id = 1');
-$db->execute($sth, $table_values);
+
+if (DB::isError($sth)) {
+ die($sth->getMessage());
+}
+
+$result =& $db->execute($sth, $table_values);
+
+if (DB::isError($result)) {
+ die($result->getMessage());
+}
]]>
</programlisting>
@@ -135,7 +152,12 @@
'name' => 'Fabien',
'country' => 'France'
);
-$db->autoExecute($table_name, $fields_values, DB_AUTOQUERY_INSERT);
+$result = $db->autoExecute($table_name, $fields_values,
+ DB_AUTOQUERY_INSERT);
+
+if (DB::isError($result)) {
+ die($result->getMessage());
+}
]]>
</programlisting>
@@ -158,8 +180,12 @@
'name' => 'Fabien',
'country' => 'France'
);
-$db->autoExecute($table_name, $fields_values,
- DB_AUTOQUERY_UPDATE, 'id = 1');
+$result = $db->autoExecute($table_name, $fields_values,
+ DB_AUTOQUERY_UPDATE, 'id = 1');
+
+if (DB::isError($result)) {
+ die($result->getMessage());
+}
]]>
</programlisting>