cvs: peardoc /en/package/database/db intro-auto.xml
| From: | Daniel Convissor | Date: | Tue, 30 Mar 2004 01:06:57 +0000 |
| Subject: | cvs: peardoc /en/package/database/db intro-auto.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-3139@lists.php.net to get a copy of this message | ||
danielc Mon Mar 29 20:06:57 2004 EDT
Modified files:
/peardoc/en/package/database/db intro-auto.xml
Log:
Adjust whitespace in examples.
http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-auto.xml?r1=1.17&r2=1.18&ty=u
Index: peardoc/en/package/database/db/intro-auto.xml
diff -u peardoc/en/package/database/db/intro-auto.xml:1.17
peardoc/en/package/database/db/intro-auto.xml:1.18
--- peardoc/en/package/database/db/intro-auto.xml:1.17 Mon Mar 29 20:03:38 2004
+++ peardoc/en/package/database/db/intro-auto.xml Mon Mar 29 20:06:57 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.17 $ -->
+<!-- $Revision: 1.18 $ -->
<refentry id="package.database.db.intro-auto">
<refnamediv>
<refname>Introduction - autoPrepare & autoExecute</refname>
@@ -47,7 +47,10 @@
// Once you have a valid DB object named $db...
$table_name = 'user';
$table_fields = array('id', 'name', 'country');
-$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
+
+$sth = $db->autoPrepare($table_name, $table_fields,
+ DB_AUTOQUERY_INSERT);
+
if (DB::isError($sth)) {
die($sth->getMessage());
}
@@ -75,10 +78,12 @@
$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);
$result =& $db->execute($sth, $table_values);
+
if (DB::isError($result)) {
die($result->getMessage());
}
@@ -95,6 +100,7 @@
$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');
@@ -146,12 +152,13 @@
<programlisting role="php">
<![CDATA[
// Once you have a valid DB object named $db...
-$table_name = 'user';
+$table_name = 'user';
$fields_values = array(
'id' => 1,
'name' => 'Fabien',
'country' => 'France'
);
+
$result = $db->autoExecute($table_name, $fields_values,
DB_AUTOQUERY_INSERT);
@@ -175,11 +182,12 @@
<programlisting role="php">
<![CDATA[
// Once you have a valid DB object named $db...
-$table_name = 'user';
+$table_name = 'user';
$fields_values = array(
'name' => 'Fabien',
'country' => 'France'
);
+
$result = $db->autoExecute($table_name, $fields_values,
DB_AUTOQUERY_UPDATE, 'id = 1');