Re: [castor-dev] Re: [PHP-DOC] cvs: phpdoc /en/reference/mysqli/functions mysqli-affected-rows.xml

what's this ?? didou Minimalist Manager wrote:

ERROR:

    You (didou@keliglia.com) are not subscribed to this list.

SOLUTION:

    Send a message to minimalist@exolab.org with a subject
    of 'info' (no quotes) for information about subscribing.

=========================================================================== 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>