cvs: peardoc /en/package/database/db intro-auto.xml
| From: | Daniel Convissor | Date: | Tue, 30 Mar 2004 00:39:27 +0000 |
| Subject: | cvs: peardoc /en/package/database/db intro-auto.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-3135@lists.php.net to get a copy of this message | ||
danielc Mon Mar 29 19:39:27 2004 EDT
Modified files:
/peardoc/en/package/database/db intro-auto.xml
Log:
Reorganize examples for clarity.
http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-auto.xml?r1=1.13&r2=1.14&ty=u
Index: peardoc/en/package/database/db/intro-auto.xml
diff -u peardoc/en/package/database/db/intro-auto.xml:1.13
peardoc/en/package/database/db/intro-auto.xml:1.14
--- peardoc/en/package/database/db/intro-auto.xml:1.13 Sun Mar 21 16:49:27 2004
+++ peardoc/en/package/database/db/intro-auto.xml Mon Mar 29 19:39:27 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.13 $ -->
+<!-- $Revision: 1.14 $ -->
<refentry id="package.database.db.intro-auto">
<refnamediv>
<refname>Introduction - autoPrepare & autoExecute</refname>
@@ -40,8 +40,8 @@
<programlisting role="php">
<![CDATA[
// Once you have a valid DB object named $db...
-$table_fields = array('id', 'name', 'country');
$table_name = 'user';
+$table_fields = array('id', 'name', 'country');
$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
]]>
</programlisting>
@@ -60,9 +60,9 @@
<programlisting role="php">
<![CDATA[
// Once you have a valid DB object named $db...
+$table_name = 'user';
$table_fields = array('id', 'name', 'country');
$table_values = array(1, 'Fabien', 'France');
-$table_name = 'user';
$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
$db->execute($sth, $table_values);
]]>
@@ -73,11 +73,11 @@
<programlisting role="php">
<![CDATA[
// Once you have a valid DB object named $db...
+$table_name = 'user';
$table_fields = array('name', 'country');
$table_values = array('Bob', 'USA');
-$table_name = 'user';
$sth = $db->autoPrepare($table_name, $table_fields,
- DB_AUTOQUERY_UPDATE, 'id = 1');
+ DB_AUTOQUERY_UPDATE, 'id = 1');
$db->execute($sth, $table_values);
]]>
</programlisting>
@@ -111,16 +111,17 @@
<programlisting role="php">
<![CDATA[
// Once you have a valid DB object named $db...
+$table_name = 'user';
$fields_values = array(
- 'id' => 1,
- 'name' => 'Fabien',
+ 'id' => 1,
+ 'name' => 'Fabien',
'country' => 'France'
);
-$table_name = 'user';
$db->autoExecute($table_name, $fields_values, DB_AUTOQUERY_INSERT);
]]>
</programlisting>
And that's all ! The following query is built and executed :
+
<programlisting role="sql">
<![CDATA[
INSERT INTO user (id, name, country)
@@ -131,11 +132,11 @@
<programlisting role="php">
<![CDATA[
// Once you have a valid DB object named $db...
+$table_name = 'user';
$fields_values = array(
- 'name' => 'Fabien',
+ 'name' => 'Fabien',
'country' => 'France'
);
-$table_name = 'user';
$db->autoExecute($table_name, $fields_values,
DB_AUTOQUERY_UPDATE, 'id = 1');
]]>