cvs: peardoc /en/package/database/db intro-auto.xml intro-execute.xml
| From: | Daniel Convissor | Date: | Tue, 27 Jan 2004 00:48:16 +0000 |
| Subject: | cvs: peardoc /en/package/database/db intro-auto.xml intro-execute.xml | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-2187@lists.php.net to get a copy of this message | ||
danielc Mon Jan 26 19:48:16 2004 EDT
Modified files:
/peardoc/en/package/database/db intro-auto.xml intro-execute.xml
Log:
Line wrapping so output doesn't flow off right side of page.
http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-auto.xml?r1=1.8&r2=1.9&ty=u
Index: peardoc/en/package/database/db/intro-auto.xml
diff -u peardoc/en/package/database/db/intro-auto.xml:1.8
peardoc/en/package/database/db/intro-auto.xml:1.9
--- peardoc/en/package/database/db/intro-auto.xml:1.8 Sun Dec 21 12:12:00 2003
+++ peardoc/en/package/database/db/intro-auto.xml Mon Jan 26 19:48:15 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
<refentry id="package.database.db.intro-auto">
<refnamediv>
<refname>Introduction - autoPrepare and autoExecute</refname>
@@ -39,7 +39,7 @@
insert or update queries. For example :
<programlisting role="php">
<![CDATA[
-(...) // $dbh is an DB object
+// 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);
@@ -59,7 +59,7 @@
<function>executeMultiple</function></link> like :
<programlisting role="php">
<![CDATA[
-(...) // $dbh is an DB object
+// Once you have a valid DB object named $db...
$table_fields = array('id', 'name', 'country');
$table_values = array(1, 'Fabien', 'France');
$table_name = 'user';
@@ -72,11 +72,12 @@
the WHERE statement of the query. For instance :
<programlisting role="php">
<![CDATA[
-(...) // $dbh is an DB object
+// Once you have a valid DB object named $db...
$table_fields = array('name', 'country');
$table_values = array('Bob', 'USA');
$table_name = 'user';
-$sth = $dbh->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_UPDATE, 'id = 1');
+$sth = $dbh->autoPrepare($table_name, $table_fields,
+ DB_AUTOQUERY_UPDATE, 'id = 1');
$dbh->execute($sth, $table_values);
]]>
</programlisting>
@@ -109,7 +110,7 @@
corresponding values of these fields. For instance :
<programlisting role="php">
<![CDATA[
-(...) // $dbh is an DB object
+// Once you have a valid DB object named $db...
$fields_values = array(
'id' => 1,
'name' => 'Fabien',
@@ -128,19 +129,21 @@
And it's the same thing for update queries :
<programlisting role="php">
<![CDATA[
-(...) // $dbh is an DB object
+// Once you have a valid DB object named $db...
$fields_values = array(
'name' => 'Fabien',
'country' => 'France'
);
$table_name = 'user';
-$dbh->autoExecute($table_name, $fields_values, DB_AUTOQUERY_UPDATE, 'id = 1');
+$dbh->autoExecute($table_name, $fields_values,
+ DB_AUTOQUERY_UPDATE, 'id = 1');
]]>
</programlisting>
The following query is built and executed :
<programlisting>
<![CDATA[
-UPDATE user SET name='Fabien', country='France' WHERE id = 1
+UPDATE user SET name='Fabien', country='France'
+ WHERE id = 1
]]>
</programlisting>
</para>
http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-execute.xml?r1=1.6&r2=1.7&ty=u
Index: peardoc/en/package/database/db/intro-execute.xml
diff -u peardoc/en/package/database/db/intro-execute.xml:1.6
peardoc/en/package/database/db/intro-execute.xml:1.7
--- peardoc/en/package/database/db/intro-execute.xml:1.6 Mon Jan 26 17:08:32 2004
+++ peardoc/en/package/database/db/intro-execute.xml Mon Jan 26 19:48:16 2004
@@ -1,4 +1,4 @@
-<!-- $Revision: 1.6 $ -->
+<!-- $Revision: 1.7 $ -->
<refentry id="package.database.db.intro-execute">
<refnamediv>
<refname>Introduction - Execute</refname>
@@ -25,16 +25,19 @@
syntax:
<programlisting>
<![CDATA[
-db1 : INSERT INTO tbl_name ( col1, col2 ... ) VALUES ( expr1, expr2 ... )
-db2 : INSERT INTO tbl_name SET col1=expr1, col2=expr2 ...
+db1: INSERT INTO tbl_name (col1, col2) VALUES (expr1, expr2)
+db2: INSERT INTO tbl_name SET col1=expr1, col2=expr2
]]>
</programlisting>
Correspondending to create multi-lingual scripts you can create
a array with queries like this:
<programlisting role="php">
<![CDATA[
-$statement['db1']['INSERT_PERSON'] = "INSERT INTO person ( surname, name,
age ) VALUES ( ?, ?, ? )" ;
-$statement['db2']['INSERT_PERSON'] = "INSERT INTO person SET surname=?,
name=?, age=?" ;
+$statement['db1']['INSERT_PERSON'] = 'INSERT INTO person
+ (surname, name, age) VALUES (?, ?, ?)';
+
+$statement['db2']['INSERT_PERSON'] = 'INSERT INTO person
+ SET surname=?, name=?, age=?';
]]>
</programlisting>
</para>
@@ -57,15 +60,18 @@
as usual, i.e.
<programlisting>
<![CDATA[
-SELECT surname, name, age FROM person
- WHERE name = 'name_to_find' AND age < 'age_limit'
+SELECT surname, name, age
+ FROM person
+ WHERE name = 'name_to_find' AND age < 'age_limit'
]]>
</programlisting>
Now check which parameters should be replaced while script
runtime. Substitute this parameters with a placeholder.
<programlisting>
<![CDATA[
-SELECT surname, name, age FROM person WHERE name = ? AND age < ?
+SELECT surname, name, age
+ FROM person
+ WHERE name = ? AND age < ?
]]>
</programlisting>
So, thats all! Now you have a generic statement, required by
@@ -111,12 +117,12 @@
<title>Inserting data into a datebase</title>
<programlisting role="php">
<![CDATA[
-...
-$alldata = array( array(1, 'one', 'en'),
- array(2, 'two', 'to'),
- array(3, 'three', 'tre'),
- array(4, 'four', 'fire'));
-$sth = $dbh->prepare("INSERT INTO numbers VALUES(?,?,?)");
+// Once you have a valid DB object named $db...
+$alldata = array(array(1, 'one', 'en'),
+ array(2, 'two', 'to'),
+ array(3, 'three', 'tre'),
+ array(4, 'four', 'fire'));
+$sth = $dbh->prepare('INSERT INTO numbers VALUES(?, ?, ?)');
foreach ($alldata as $row) {
$dbh->execute($sth, $row);
}
@@ -126,10 +132,10 @@
In the example the query is done four times:
<programlisting>
<![CDATA[
-INSERT INTO numbers VALUES( '1', 'one', 'en')
-INSERT INTO numbers VALUES( '2', 'two', 'to')
-INSERT INTO numbers VALUES( '3', 'three', 'tre')
-INSERT INTO numbers VALUES( '4', 'four', 'fire')
+INSERT INTO numbers VALUES('1', 'one', 'en')
+INSERT INTO numbers VALUES('2', 'two', 'to')
+INSERT INTO numbers VALUES('3', 'three', 'tre')
+INSERT INTO numbers VALUES('4', 'four', 'fire')
]]>
</programlisting>
<link linkend="package.database.db.db-common.executemultiple">
@@ -143,12 +149,12 @@
</title>
<programlisting role="php">
<![CDATA[
-...
-$alldata = array( array(1, 'one', 'en'),
- array(2, 'two', 'to'),
- array(3, 'three', 'tre'),
- array(4, 'four', 'fire'));
-$sth = $dbh->prepare("INSERT INTO numbers VALUES(?,?,?)");
+// Once you have a valid DB object named $db...
+$alldata = array(array(1, 'one', 'en'),
+ array(2, 'two', 'to'),
+ array(3, 'three', 'tre'),
+ array(4, 'four', 'fire'));
+$sth = $dbh->prepare('INSERT INTO numbers VALUES(?, ?, ?)');
$dbh->executeMultiple($sth, $alldata);
}
]]>
@@ -185,4 +191,3 @@
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
-