cvs: peardoc /en/package/database/db intro-auto.xml intro-execute.xml

From: 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 --> -

« previous php.pear.doc (#2187) next »