cvs: peardoc /en/package/database/db intro-auto.xml intro-execute.xml /en/package/database/db/db-common escapesimple.xml quotesmart.xml
| From: | Daniel Convissor | Date: | Tue, 27 Jan 2004 00:50:23 +0000 |
| Subject: | cvs: peardoc /en/package/database/db intro-auto.xml intro-execute.xml /en/package/database/db/db-common escapesimple.xml quotesmart.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-2188@lists.php.net to get a copy of this message | ||
danielc Mon Jan 26 19:50:23 2004 EDT
Modified files:
/peardoc/en/package/database/db intro-auto.xml intro-execute.xml
/peardoc/en/package/database/db/db-common escapesimple.xml
quotesmart.xml
Log:
Standardize on $db as object name in examples.
http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-auto.xml?r1=1.9&r2=1.10&ty=u
Index: peardoc/en/package/database/db/intro-auto.xml
diff -u peardoc/en/package/database/db/intro-auto.xml:1.9
peardoc/en/package/database/db/intro-auto.xml:1.10
--- peardoc/en/package/database/db/intro-auto.xml:1.9 Mon Jan 26 19:48:15 2004
+++ peardoc/en/package/database/db/intro-auto.xml Mon Jan 26 19:50:22 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.9 $ -->
+<!-- $Revision: 1.10 $ -->
<refentry id="package.database.db.intro-auto">
<refnamediv>
<refname>Introduction - autoPrepare and autoExecute</refname>
@@ -42,7 +42,7 @@
// Once you have a valid DB object named $db...
$table_fields = array('id', 'name', 'country');
$table_name = 'user';
-$sth = $dbh->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
+$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
]]>
</programlisting>
In this example, <link linkend="package.database.db.db-common.autoprepare">
@@ -63,8 +63,8 @@
$table_fields = array('id', 'name', 'country');
$table_values = array(1, 'Fabien', 'France');
$table_name = 'user';
-$sth = $dbh->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
-$dbh->execute($sth, $table_values);
+$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_INSERT);
+$db->execute($sth, $table_values);
]]>
</programlisting>
So, you don't have to write any sql insert queries ! But it works with
@@ -76,9 +76,9 @@
$table_fields = array('name', 'country');
$table_values = array('Bob', 'USA');
$table_name = 'user';
-$sth = $dbh->autoPrepare($table_name, $table_fields,
+$sth = $db->autoPrepare($table_name, $table_fields,
DB_AUTOQUERY_UPDATE, 'id = 1');
-$dbh->execute($sth, $table_values);
+$db->execute($sth, $table_values);
]]>
</programlisting>
<link linkend="package.database.db.db-common.autoprepare">
@@ -117,7 +117,7 @@
'country' => 'France'
);
$table_name = 'user';
-$dbh->autoExecute($table_name, $fields_values, DB_AUTOQUERY_INSERT);
+$db->autoExecute($table_name, $fields_values, DB_AUTOQUERY_INSERT);
]]>
</programlisting>
And that's all ! The following query is built and executed :
@@ -135,7 +135,7 @@
'country' => 'France'
);
$table_name = 'user';
-$dbh->autoExecute($table_name, $fields_values,
+$db->autoExecute($table_name, $fields_values,
DB_AUTOQUERY_UPDATE, 'id = 1');
]]>
</programlisting>
http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-execute.xml?r1=1.7&r2=1.8&ty=u
Index: peardoc/en/package/database/db/intro-execute.xml
diff -u peardoc/en/package/database/db/intro-execute.xml:1.7
peardoc/en/package/database/db/intro-execute.xml:1.8
--- peardoc/en/package/database/db/intro-execute.xml:1.7 Mon Jan 26 19:48:16 2004
+++ peardoc/en/package/database/db/intro-execute.xml Mon Jan 26 19:50:22 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.7 $ -->
+<!-- $Revision: 1.8 $ -->
<refentry id="package.database.db.intro-execute">
<refnamediv>
<refname>Introduction - Execute</refname>
@@ -122,9 +122,9 @@
array(2, 'two', 'to'),
array(3, 'three', 'tre'),
array(4, 'four', 'fire'));
-$sth = $dbh->prepare('INSERT INTO numbers VALUES(?, ?, ?)');
+$sth = $db->prepare('INSERT INTO numbers VALUES(?, ?, ?)');
foreach ($alldata as $row) {
- $dbh->execute($sth, $row);
+ $db->execute($sth, $row);
}
]]>
</programlisting>
@@ -154,8 +154,8 @@
array(2, 'two', 'to'),
array(3, 'three', 'tre'),
array(4, 'four', 'fire'));
-$sth = $dbh->prepare('INSERT INTO numbers VALUES(?, ?, ?)');
-$dbh->executeMultiple($sth, $alldata);
+$sth = $db->prepare('INSERT INTO numbers VALUES(?, ?, ?)');
+$db->executeMultiple($sth, $alldata);
}
]]>
</programlisting>
http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/escapesimple.xml?r1=1.2&r2=1.3&ty=u
Index: peardoc/en/package/database/db/db-common/escapesimple.xml
diff -u peardoc/en/package/database/db/db-common/escapesimple.xml:1.2
peardoc/en/package/database/db/db-common/escapesimple.xml:1.3
--- peardoc/en/package/database/db/db-common/escapesimple.xml:1.2 Mon Jan 26 17:23:06 2004
+++ peardoc/en/package/database/db/db-common/escapesimple.xml Mon Jan 26 19:50:23 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.2 $ -->
+<!-- $Revision: 1.3 $ -->
<refentry id="package.database.db.db-common.escapesimple">
<refnamediv>
<refname>DB_Common::escapeSimple()</refname>
@@ -56,7 +56,7 @@
<programlisting role="php">
<![CDATA[
<?php
-// Once you have a valid DB object...
+// Once you have a valid DB object named $db...
$name = "all's well";
$sql = "SELECT * FROM clients WHERE name = '"
. $db->escapeSimple($name) . "'";
http://cvs.php.net/diff.php/peardoc/en/package/database/db/db-common/quotesmart.xml?r1=1.5&r2=1.6&ty=u
Index: peardoc/en/package/database/db/db-common/quotesmart.xml
diff -u peardoc/en/package/database/db/db-common/quotesmart.xml:1.5
peardoc/en/package/database/db/db-common/quotesmart.xml:1.6
--- peardoc/en/package/database/db/db-common/quotesmart.xml:1.5 Mon Jan 26 17:23:41 2004
+++ peardoc/en/package/database/db/db-common/quotesmart.xml Mon Jan 26 19:50:23 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.5 $ -->
+<!-- $Revision: 1.6 $ -->
<refentry id="package.database.db.db-common.quotesmart">
<refnamediv>
<refname>DB_Common::quoteSmart()</refname>
@@ -57,7 +57,7 @@
<programlisting role="php">
<![CDATA[
<?php
-// Once you have a valid DB object...
+// Once you have a valid DB object named $db...
$name = "all's well";
$active = true;
$sql = 'SELECT * FROM clients WHERE name = '