costra Wed Jun 5 17:20:45 2002 EDT
Modified files:
/phpdoc-cs/reference/mysql/functions mysql-affected-rows.xml
Log:
Updated
Modified Files:
cs/reference/mysql/functions/mysql-affected-rows.xml from en rev. 1.5
Index: phpdoc-cs/reference/mysql/functions/mysql-affected-rows.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-affected-rows.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-affected-rows.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-affected-rows.xml:1.1 Sun Apr 14
19:47:07 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-affected-rows.xml Wed Jun 5 17:20:45
+2002
@@ -48,9 +48,64 @@
</para>
<para>
Je-li posledn� dotaz chybn�, funkce vr�t� -1.
+ <example>
+ <title>Dotaz typu DELETE (maz�n�)</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ /* p�ipojen� k datab�zi */
+ mysql_pconnect("localhost", "mysql_uziv", "mysql_heslo") or
+ die ("Nelze se p�ipojit");
+
+ /* tohle vr�t� spr�vn� po�et smazan�ch z�znam� */
+ mysql_query("DELETE FROM moje_tabulka WHERE id < 10");
+ printf ("Smaz�no z�znam�: %d\n", mysql_affected_rows());
+
+ /* bez pou�it� klauzule where v dotazu typu DELETE, bude vr�cena 0 */
+ mysql_query("DELETE FROM moje_tabulka");
+ printf ("Smaz�no z�znam�: %d\n", mysql_affected_rows());
+?>
+]]>
+ </programlisting>
+ <para>
+ P�edchoz� p��klad by m�l n�sleduj�c� v�stup:
+ <screen>
+<![CDATA[
+Smaz�no z�znam�: 10
+Smaz�no z�znam�: 0
+]]>
+ </screen>
+ </para>
+ </example>
+ <example>
+ <title>Dotaz typu UPDATE (zm�na)</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ /* p�ipojen� k datab�zi */
+ mysql_pconnect("localhost", "mysql_uziv", "mysql_heslo") or
+ die ("Nelze se p�ipojit");
+
+ /* Zm�na z�znam� */
+ mysql_query("UPDATE moje_tabulka SET used=1 WHERE id < 10");
+ printf ("Zm�n�no z�znam�: %d\n", mysql_affected_rows());
+ mysql_query("COMMIT");
+?>
+]]>
+ </programlisting>
+ <para>
+ P�edchoz� p��klad by m�l n�sleduj�c� v�stup:
+ <screen>
+<![CDATA[
+Zm�n�no z�znam�: 10
+]]>
+ </screen>
+ </para>
+ </example>
</para>
<para>
- Viz. tak�: <function>mysql_num_rows</function>.
+ D�le tak�: <function>mysql_num_rows</function>,
+ <function>mysql_info</function>.
</para>
</refsect1>
</refentry>
