Re: cvs: phpdoc /en/reference/mysqli/functions mysqli-affected-rows.xml

Hi Georg, Can you add the missing "role" attribute in your <programlisting>'s ? didou Georg Richter wrote:

georg Fri Aug 22 08:08:49 2003 EDT

  Modified files:                  /phpdoc/en/reference/mysqli/functions	mysqli-affected-rows.xml   Log:

minor fixed. Added and corrected samples Index: phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml diff -u phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.7 phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.8 --- phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml:1.7 Wed Jun 11 09:00:48 2003 +++ phpdoc/en/reference/mysqli/functions/mysqli-affected-rows.xml Fri Aug 22 08:08:49 2003 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.7 $ --> +<!-- $Revision: 1.8 $ --> <refentry id="function.mysqli-affected-rows">

    <refnamediv>
     <refname>mysqli_affected_rows</refname>

@@ -9,7 +9,7 @@

     <title>Description</title>
      <methodsynopsis>
       <type>mixed</type><methodname>mysqli_affected_rows</methodname>
-      <methodparam><type>resource</type><parameter>link</parameter></methodparam>
+      <methodparam><type>object</type><parameter>link</parameter></methodparam>
      </methodsynopsis>
     <para>
      <function>mysqli_affected_rows</function> returns the number of rows affected by the last

@@ -30,52 +30,96 @@

     <para>
      <example>
       <title>Delete-Query</title>
+      <para>Procedural style:</para>
       <programlisting role="php">

<![CDATA[ <?php

     /* connect to database */
-    mysqli_connect("localhost", "mysql_user", "mysql_password") or
-        die("Could not connect: " . mysqli_error());
-    mysqli_select_db("mydb");
+    $link = mysqli_connect("localhost", "mysql_user", "mysql_password", "mydb") or
+        die("Could not connect: " . mysqli_connect_error());
          /* this should return the correct numbers of deleted records */
-    mysqli_query("DELETE FROM mytable WHERE id < 10");
-    printf ("Records deleted: %d\n", mysqli_affected_rows());
+    mysqli_query($link, "DELETE FROM mytable WHERE id < 10");
+    printf ("Records deleted: %2d\n", mysqli_affected_rows($link));
      /* without a where clause in a delete statement, it should return 0 */
-    mysqli_query("DELETE FROM mytable");
-    printf ("Records deleted: %d\n", mysqli_affected_rows());
+    mysqli_query($link, "DELETE FROM mytable");
+    printf ("Records deleted: %2d\n", mysqli_affected_rows($link));

+

+    /* close connection */
+    mysqli_close($link);

+?> +]]>

+      </programlisting>
+      <para>Object oriented style:</para>
+      <programlisting>

+<![CDATA[ +<?php

+    /* connect to database */
+    $mysql = mysqli_connect("localhost", "mysql_user", "mysql_password", "mydb") or
+        die("Could not connect: " . mysqli_connect_error());
+    +    /* this should return the correct numbers of deleted records */
+    $mysql->query("DELETE FROM mytable WHERE id < 10");
+    printf ("Records deleted: %2d\n", $mysql->affected_rows());

+

+    /* without a where clause in a delete statement, it should return 0 */
+    $mysql->query("DELETE FROM mytable");
+    printf ("Records deleted: %2d\n", $mysql->affected_rows());

+

+    /* close connection */
+    $mysql->close();

?> ]]>

       </programlisting>
       <para>
-       The above example would produce the following output:
+       The above examples would produce the following output:
        <screen>

<![CDATA[ Records deleted: 10 -Records deleted: 0 +Records deleted: 0 ]]>

        </screen>
       </para>
      </example>
      <example>
       <title>Update-Query</title>
+      <para>Procedural style:</para>
       <programlisting role="php">

<![CDATA[ <?php

     /* connect to database */
-    mysqli_connect("localhost", "mysql_user", "mysql_password") or
-        die("Could not connect: " . mysqli_error());
-    mysqli_select_db("mydb");
+    $link = mysqli_connect("localhost", "mysql_user", "mysql_password", "mydb") or
+        die("Could not connect: " . mysqli_connect_error());
              /* Update records */
-    mysqli_query("UPDATE mytable SET used=1 WHERE id < 10");
-    printf ("Updated records: %d\n", mysqli_affected_rows());
+    mysqli_query($link, "UPDATE mytable SET used=1 WHERE id < 10");
+    printf ("Updated records: %d\n", mysqli_affected_rows($link));

+

+    /* close connection */
+    mysqli_close($link);

+?> +]]>

+      </programlisting>
+      <para>Object oriented style:</para>
+      <programlisting role="php">

+<![CDATA[ +<?php

+    /* connect to database */
+    $mysql = mysqli_connect("localhost", "mysql_user", "mysql_password", "mydb") or
+        die("Could not connect: " . mysqli_connect_error());
+        +    /* Update records */
+    $mysql->query("UPDATE mytable SET used=1 WHERE id < 10");
+    printf ("Updated records: %d\n", $mysql->affected_rows($link));

+

+    /* close connection */
+    mysql->close($link);

?> ]]>

       </programlisting>
       <para>
-       The above example would produce the following output:
+       The above examples would produce the following output:
        <screen>

<![CDATA[ Updated Records: 10 @@ -83,6 +127,10 @@

        </screen>
       </para>
      </example> +    </para>
+    <para>
+     See also: <function>mysqli_num_rows</function>,
+     <function>mysqli_info</function>.
     </para>
    </refsect1>

</refentry>