didou
Minimalist Manager wrote:
ERROR: You ([EMAIL PROTECTED]) are not subscribed to this list.
SOLUTION: Send a message to [EMAIL PROTECTED] 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>
<