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

didou Mon Feb 23 08:28:09 2004 EDT Modified files: /peardoc/en/package/database/db intro-auto.xml intro-execute.xml Log: adding role="sql" where needed http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-auto.xml?r1=1.11&r2=1.12&ty=u Index: peardoc/en/package/database/db/intro-auto.xml diff -u peardoc/en/package/database/db/intro-auto.xml:1.11 peardoc/en/package/database/db/intro-auto.xml:1.12 --- peardoc/en/package/database/db/intro-auto.xml:1.11 Sun Feb 1 22:35:56 2004 +++ peardoc/en/package/database/db/intro-auto.xml Mon Feb 23 08:28:08 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.11 $ --> +<!-- $Revision: 1.12 $ --> <refentry id="package.database.db.intro-auto"> <refnamediv> <refname>Introduction - autoPrepare and autoExecute</refname> @@ -20,7 +20,7 @@ <para> Imagine you have an 'user' table with 3 fields (id, name and country). You have to write sql queries like : - <programlisting> + <programlisting role="sql"> <![CDATA[ INSERT INTO table (id, name, country) VALUES (?, ?, ?) UPDATE table SET id=?, name=?, country=? WHERE ... @@ -47,7 +47,7 @@ </programlisting> In this example, <link linkend="package.database.db.db-common.autoprepare"> <function>autoPrepare</function></link> will build the following sql query : - <programlisting> + <programlisting role="sql"> <![CDATA[ INSERT INTO user (id, name, country) VALUES (?, ?, ?) ]]> @@ -83,7 +83,7 @@ </programlisting> <link linkend="package.database.db.db-common.autoprepare"> <function>autoPrepare</function></link> will build the following query : - <programlisting> + <programlisting role="sql"> <![CDATA[ UPDATE user SET name=?, country=? WHERE id=1 ]]> @@ -121,7 +121,7 @@ ]]> </programlisting> And that's all ! The following query is built and executed : - <programlisting> + <programlisting role="sql"> <![CDATA[ INSERT INTO user (id, name, country) VALUES (1, 'Fabien', 'France') @@ -141,7 +141,7 @@ ]]> </programlisting> The following query is built and executed : - <programlisting> + <programlisting role="sql"> <![CDATA[ UPDATE user SET name='Fabien', country='France' WHERE id = 1 http://cvs.php.net/diff.php/peardoc/en/package/database/db/intro-execute.xml?r1=1.14&r2=1.15&ty=u Index: peardoc/en/package/database/db/intro-execute.xml diff -u peardoc/en/package/database/db/intro-execute.xml:1.14 peardoc/en/package/database/db/intro-execute.xml:1.15 --- peardoc/en/package/database/db/intro-execute.xml:1.14 Sat Feb 21 22:37:01 2004 +++ peardoc/en/package/database/db/intro-execute.xml Mon Feb 23 08:28:08 2004 @@ -1,4 +1,4 @@ -<!-- $Revision: 1.14 $ --> +<!-- $Revision: 1.15 $ --> <refentry id="package.database.db.intro-execute"> <refnamediv> <refname>Introduction - Prepare &amp; Execute</refname> @@ -58,7 +58,7 @@ <para> To create a generic statment is simple. Write the SQL query as usual, i.e. - <programlisting> + <programlisting role="sql"> <![CDATA[ SELECT surname, name, age FROM person @@ -67,7 +67,7 @@ </programlisting> Now check which parameters should be replaced while script runtime. Substitute this parameters with a placeholder. - <programlisting> + <programlisting role="sql"> <![CDATA[ SELECT surname, name, age FROM person @@ -130,7 +130,7 @@ </programlisting> </example> In the example the query is done four times: - <programlisting> + <programlisting role="sql"> <![CDATA[ INSERT INTO numbers VALUES ('1', 'one', 'en') INSERT INTO numbers VALUES ('2', 'two', 'to')