cvs: phpdoc /nl/reference/mysql/functions mysql-affected-rows.xml

manuzhai Mon Apr 29 05:24:21 2002 EDT Modified files: /phpdoc/nl/reference/mysql/functions mysql-affected-rows.xml Log: Updated to EN 1.4 Index: phpdoc/nl/reference/mysql/functions/mysql-affected-rows.xml diff -u phpdoc/nl/reference/mysql/functions/mysql-affected-rows.xml:1.2 phpdoc/nl/reference/mysql/functions/mysql-affected-rows.xml:1.3 --- phpdoc/nl/reference/mysql/functions/mysql-affected-rows.xml:1.2 Wed Apr 17 03:14:09 2002 +++ phpdoc/nl/reference/mysql/functions/mysql-affected-rows.xml Mon Apr 29 05:24:21 2002 @@ -1,8 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 --> -<!-- last change to 'mysql-affected-rows' in en/ tree in rev 1.2 --> -<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready --> -<!-- OLD-Revision: 1.95/EN.1.2 --> +<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready --> <refentry id="function.mysql-affected-rows"> <refnamediv> <refname>mysql_affected_rows</refname> @@ -53,9 +50,65 @@ </para> <para> Als de laatste query faalde, geeft deze functie -1 terug. - </para> + <example> + <title>Delete-Query</title> + <programlisting role="php"> + <![CDATA[ + <?php + /* Verbinding maken met de database */ + mysql_pconnect("localhost", "mysql_user", "mysql_password") or + die ("Kan geen verbinding maken"); + + /* Dit zou het correcte aantal gedelete records terug moeten geven */ + mysql_query("DELETE FROM mytable WHERE id < 10"); + printf ("Records deleted: %d\n", mysql_affected_rows()); + + /* Zonder een WHERE clause in de query geeft dit 0 terug */ + mysql_query("DELETE FROM mytable"); + printf ("Records deleted: %d\n", mysql_affected_rows()); + ?> + ]]> + </programlisting> + <para> + Het bovenstaande voorbeeld zou de volgende output produceren: + <screen> + <![CDATA[ + Records deleted: 10 + Records deleted: 0 + ]]> + </screen> + </para> + </example> + <example> + <title>Update-Query</title> + <programlisting role="php"> + <![CDATA[ + <?php + /* Verbinding maken met de database */ + mysql_pconnect("localhost", "mysql_user", "mysql_password") or + die ("Kan geen verbinding maken"); + + /* Update records */ + mysql_query("UPDATE mytable SET used=1 WHERE id < 10"); + printf ("Updated records: %d\n", mysql_affected_rpws()); + mysql_query("COMMIT"); + ?> + ]]> + </programlisting> + <para> + Het bovenstaande voorbeeld zou de volgende output produceren: + <screen> + <![CDATA[ + Updated Records: 10 + ]]> + </screen> + </para> + </example> + </para> <para> - Zie ook: <function>mysql_num_rows</function>. + <para> + See also: <function>mysql_num_rows</function>, + <function>mysql_info</function>. </para> </refsect1> </refentry>