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

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

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