com doc/fr: Apply commit ca5c477437fcb21680408bf7e0cc0424853e7907: reference/mysqli/mysqli_result/fetch-array.xml reference/ mysqli/mysqli_result/fetch-assoc.xml reference/mysqli/mys qli_result/fetch-object.xml reference/mysqli/mysqli_res ult/fetch-row.xml

[email protected] (George Peter Banyard) Wed, 24 Feb 2021 17:45:13 +0000
Newsgroups php.doc.fr
Message-ID <[email protected]>
Commit:    617a6dab03449c6bab35dd119aee17014667b5c0
Author:    George Peter Banyard <[email protected]>         Wed, 24 Feb 2021 16:07:04 +0000
Parents:   2b0b728b1a4c152244598de48d168be0caac92e1
Branches:  master

Link:       http://git.php.net/?p=doc/fr.git;a=commitdiff;h=617a6dab03449c6bab35dd119aee17014667b5c0

Log:
Apply commit ca5c477437fcb21680408bf7e0cc0424853e7907

Improve mysqli_fetch_* functions docs

Changed paths:
  M  reference/mysqli/mysqli_result/fetch-array.xml
  M  reference/mysqli/mysqli_result/fetch-assoc.xml
  M  reference/mysqli/mysqli_result/fetch-object.xml
  M  reference/mysqli/mysqli_result/fetch-row.xml
diff_617a6dab03449c6bab35dd119aee17014667b5c0.txt (text/plain, 18.5 KB)
diff --git a/reference/mysqli/mysqli_result/fetch-array.xml b/reference/mysqli/mysqli_result/fetch-array.xml
index fd1a4539f7..754e7b71b6 100644
--- a/reference/mysqli/mysqli_result/fetch-array.xml
+++ b/reference/mysqli/mysqli_result/fetch-array.xml
@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- $Revision$ -->
-<!-- EN-Revision: c1434c95fc666c20cdbd1e1d9a4183e0d11fb88c Maintainer: yannick Status: ready -->
-<!-- Reviewed: yes -->
+<!-- EN-Revision: ca5c477437fcb21680408bf7e0cc0424853e7907 Maintainer: yannick Status: ready -->
+<!-- Reviewed: no -->
 
 <refentry xml:id="mysqli-result.fetch-array" xmlns="http://docbook.org/ns/docbook">
  <refnamediv>
@@ -25,14 +25,12 @@
   </methodsynopsis>
   <para>
    Retourne un tableau qui correspond à la ligne récupérée ou &null; s'il n'y a
-   plus de ligne dans le jeu de résultats <parameter>result</parameter>.
+   plus de ligne dans le jeu de résultats.
   </para>
   <para>
-   <function>mysqli_fetch_array</function> est une version étendue de la fonction 
-   <function>mysqli_fetch_row</function>. En plus d'enregistrer les données
-   sous forme d'un tableau à indices numériques, elle peut aussi les
-   enregistrer dans un tableau associatif, en utilisant les noms des champs
-   comme clés.
+   En plus d'enregistrer les données sous forme d'un tableau à indices numériques,
+   elle peut aussi les enregistrer dans un tableau associatif,
+   en utilisant les noms des champs comme clés.
   </para>
   &database.field-case;
   &database.fetch-null;
@@ -75,7 +73,7 @@
  <refsect1 role="returnvalues">
   &reftitle.returnvalues;
   <para>
-   Retourne un tableau de chaînes qui correspond à la ligne récupérée ou &null; s'il
+   Retourne un tableau de valeurs qui correspond à la ligne récupérée ou &null; s'il
    n'y a plus de ligne disponible dans le jeu de résultats.
   </para>
  </refsect1>
@@ -83,79 +81,56 @@
  <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>&style.oop;</title>
+   <title><methodname>mysqli_result::fetch_array</methodname> example</title>
+   <para>&style.oop;</para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
 
-/* Vérification de la connexion */
-if ($mysqli->connect_errno) {
-    printf("Echec de la connexion : %s\n", $mysqli->connect_error);
-    exit();
-}
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
 
-$query = "SELECT Name, CountryCode FROM City ORDER by ID LIMIT 3";
+$query = "SELECT Name, CountryCode FROM City ORDER BY ID LIMIT 3";
 $result = $mysqli->query($query);
 
 /* Tableau numérique */
 $row = $result->fetch_array(MYSQLI_NUM);
-printf ("%s (%s)\n", $row[0], $row[1]);
+printf("%s (%s)\n", $row[0], $row[1]);
 
 /* Tableau associatif */
 $row = $result->fetch_array(MYSQLI_ASSOC);
-printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);
+printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);
 
 /* Tableau associatif et numérique */
 $row = $result->fetch_array(MYSQLI_BOTH);
-printf ("%s (%s)\n", $row[0], $row["CountryCode"]);
-
-/* Libération des résultats */
-$result->free();
-
-/* Fermeture de la connexion */
-$mysqli->close();
-?>
+printf("%s (%s)\n", $row[0], $row["CountryCode"]);
 ]]>
    </programlisting>
-  </example>
-  <example>
-   <title>&style.procedural;</title>
+   <para>&style.procedural;</para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$link = mysqli_connect("localhost", "my_user", "my_password", "world");
 
-/* Vérification de la connexion */
-if (mysqli_connect_errno()) {
-    printf("Échec de la connexion : %s\n", mysqli_connect_error());
-    exit();
-}
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = mysqli_connect("localhost", "my_user", "my_password", "world");
 
 $query = "SELECT Name, CountryCode FROM City ORDER by ID LIMIT 3";
-$result = mysqli_query($link, $query);
+$result = mysqli_query($mysqli, $query);
 
 /* Tableau numérique */
 $row = mysqli_fetch_array($result, MYSQLI_NUM);
-printf ("%s (%s)\n", $row[0], $row[1]);
+printf("%s (%s)\n", $row[0], $row[1]);
 
 /* Tableau associatif */
 $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
-printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);
+printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);
 
 /* Tableau associatif et numérique */
 $row = mysqli_fetch_array($result, MYSQLI_BOTH);
-printf ("%s (%s)\n", $row[0], $row["CountryCode"]);
-
-/* Libération des résultats */
-mysqli_free_result($result);
-
-/* Fermeture de la connexion */
-mysqli_close($link);
-?>
+printf("%s (%s)\n", $row[0], $row["CountryCode"]);
 ]]>
    </programlisting>
-   &examples.outputs;
+   &examples.outputs.similar;
    <screen>
 <![CDATA[
 Kabul (AFG)
diff --git a/reference/mysqli/mysqli_result/fetch-assoc.xml b/reference/mysqli/mysqli_result/fetch-assoc.xml
index ab7e339043..7177c2f705 100644
--- a/reference/mysqli/mysqli_result/fetch-assoc.xml
+++ b/reference/mysqli/mysqli_result/fetch-assoc.xml
@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- $Revision$ -->
-<!-- EN-Revision: c1434c95fc666c20cdbd1e1d9a4183e0d11fb88c Maintainer: yannick Status: ready -->
-<!-- Reviewed: yes -->
+<!-- EN-Revision: ca5c477437fcb21680408bf7e0cc0424853e7907 Maintainer: yannick Status: ready -->
+<!-- Reviewed: no -->
 
 <refentry xml:id="mysqli-result.fetch-assoc" xmlns="http://docbook.org/ns/docbook">
  <refnamediv>
@@ -42,7 +42,7 @@
  <refsect1 role="returnvalues">
   &reftitle.returnvalues;
   <para>
-   Retourne un tableau associatif de chaînes représentant la prochaine
+   Retourne un tableau associatif de valeur représentant la prochaine
    ligne dans le jeu de résultats représenté par le paramètre
    <parameter>result</parameter>, où chaque clé du
    tableau représente le nom d'une colonne du résultat ou
@@ -62,69 +62,44 @@
  <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>&style.oop;</title>
+   <title>Exemple <methodname>mysqli_result::fetch_assoc</methodname></title>
+   <para>&style.oop;</para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
-
-/* Vérification de la connexion */
-if (mysqli_connect_errno()) {
-    printf("Échec de la connexion : %s\n", $mysqli->connect_error);
-    exit();
-}
 
-$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
 
-if ($result = $mysqli->query($query)) {
+$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
 
-    /* Récupère un tableau associatif */
-    while ($row = $result->fetch_assoc()) {
-        printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);
-    }
+$result = $mysqli->query($query);
 
-    /* Libération des résultats */
-    $result->free();
+/* fetch associative array */
+while ($row = $result->fetch_assoc()) {
+    printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);
 }
-
-/* Fermeture de la connexion */
-$mysqli->close();
-?>
 ]]>
    </programlisting>
-  </example>
-  <example>
-   <title>&style.procedural;</title>
+   <para>&style.procedural;</para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$link = mysqli_connect("localhost", "my_user", "my_password", "world");
-
-/* Vérification de la connexion */
-if (mysqli_connect_errno()) {
-    printf("Échec de la connexion : %s\n", mysqli_connect_error());
-    exit();
-}
 
-$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = mysqli_connect("localhost", "my_user", "my_password", "world");
 
-if ($result = mysqli_query($link, $query)) {
+$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
 
-    /* Récupère un tableau associatif */
-    while ($row = mysqli_fetch_assoc($result)) {
-        printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);
-    }
+$result = mysqli_query($mysqli, $query);
 
-    /* Libération des résultats */
-    mysqli_free_result($result);
+/* fetch associative array */
+while ($row = mysqli_fetch_assoc($result)) {
+    printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);
 }
-
-/* Fermeture de la connexion */
-mysqli_close($link);
-?>
 ]]>
    </programlisting>
-   &examples.outputs;
+   &examples.outputs.similar;
    <screen>
 <![CDATA[
 Pueblo (USA)
@@ -136,42 +111,52 @@ Santa Clara (USA)
    </screen>
   </example>
   <example xml:id="mysqli-result.example.iterator">
-   <title>Exemple avec <classname>MySQLi_Result</classname> et l'utilisation d'un <classname>iterator</classname></title>
+   <title>Comparaison de l'usage de <classname>mysqli_result</classname> <classname>iterator</classname> et <methodname>mysqli_result::fetch_assoc</methodname></title>
+   <para>
+    <classname>mysqli_result</classname> peut être itéré en utilisant un &foreach;.
+    Le jeu de résultats sera toujours itéré à partir de la première ligne,
+    quel que soit la position actuelle.
+   </para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$c = mysqli_connect('127.0.0.1','user', 'pass');
 
-// Utilisation d'itérateurs (support ajouté en PHP 5.4)
-foreach ( $c->query('SELECT user,host FROM mysql.user') as $row ) {
-    printf("'%s'@'%s'\n", $row['user'], $row['host']);
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
+
+$query = 'SELECT Name, CountryCode FROM City ORDER BY ID DESC';
+
+// Utilise un itérateur
+$result = $mysqli->query($query);
+foreach ($result as $row) {
+    printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);
 }
 
 echo "\n==================\n";
 
-// Sans utiliser les itérateurs
-$result = $c->query('SELECT user,host FROM mysql.user');
+// N'utilise pas d'itérateur
+$result = $mysqli->query($query);
 while ($row = $result->fetch_assoc()) {
-    printf("'%s'@'%s'\n", $row['user'], $row['host']);
+    printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);
 }
-
-?>
 ]]>
    </programlisting>
    &example.outputs.similar;
    <screen>
 <![CDATA[
-'root'@'192.168.1.1'
-'root'@'127.0.0.1'
-'dude'@'localhost'
-'lebowski'@'localhost'
+Pueblo (USA)
+Arvada (USA)
+Cape Coral (USA)
+Green Bay (USA)
+Santa Clara (USA)
 
 ==================
+Pueblo (USA)
+Arvada (USA)
+Cape Coral (USA)
+Green Bay (USA)
+Santa Clara (USA)
 
-'root'@'192.168.1.1'
-'root'@'127.0.0.1'
-'dude'@'localhost'
-'lebowski'@'localhost'
 ]]>
    </screen>
   </example>
diff --git a/reference/mysqli/mysqli_result/fetch-object.xml b/reference/mysqli/mysqli_result/fetch-object.xml
index f729ceb739..3ebec32f70 100644
--- a/reference/mysqli/mysqli_result/fetch-object.xml
+++ b/reference/mysqli/mysqli_result/fetch-object.xml
@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- $Revision$ -->
-<!-- EN-Revision: c1434c95fc666c20cdbd1e1d9a4183e0d11fb88c Maintainer: yannick Status: ready -->
-<!-- Reviewed: yes -->
+<!-- EN-Revision: ca5c477437fcb21680408bf7e0cc0424853e7907 Maintainer: yannick Status: ready -->
+<!-- Reviewed: no -->
 
 <refentry xml:id="mysqli-result.fetch-object" xmlns="http://docbook.org/ns/docbook">
  <refnamediv>
@@ -26,15 +26,19 @@
    <methodparam choice="opt"><type>array</type><parameter>params</parameter></methodparam>
   </methodsynopsis>
   <para>
-   La fonction <function>mysqli_fetch_object</function> retourne la ligne
+   Retourne la ligne
    courante du jeu de résultat sous forme d'objet dont les attributs
-   représentent les noms des champs trouvés dans le jeu de
-   résultats.
+   représentent les noms des champs trouvés dans le jeu de résultats.
   </para>
-  <para>
-    Notez que <function>mysqli_fetch_object</function> affecte les attributs de l'objet
+
+  <note>
+   <simpara>
+    Cette fonction affecte les propriétés de l'objet
     avant d'en appeler le constructeur.
-  </para>
+   </simpara>
+  </note>
+  &database.field-case;
+  &database.fetch-null;
  </refsect1>
 
  <refsect1 role="parameters">
@@ -67,79 +71,52 @@
  <refsect1 role="returnvalues">
   &reftitle.returnvalues;
   <para>
-   Retourne un objet avec les propriétés qui correspondent à la ligne récupérée ou &null; s'il
+   Retourne un objet correspondent à la ligne récupérée ou &null; s'il
    n'y a plus de ligne dans le jeu de résultat.
   </para>
-  &database.field-case;
-  &database.fetch-null;
  </refsect1>
 
  <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>&style.oop;</title>
+   <title>Exemple <methodname>mysqli_result::fetch_object</methodname></title>
+   <para>&style.oop;</para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
 
-/* Vérification de la connexion */
-if (mysqli_connect_errno()) {
-    printf("Échec de la connexion : %s\n", mysqli_connect_error());
-    exit();
-}
- 
-$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
 
-if ($result = $mysqli->query($query)) {
+$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
 
-    /* Récupère un tableau d'objets */
-    while ($obj = $result->fetch_object()) {
-        printf ("%s (%s)\n", $obj->Name, $obj->CountryCode);
-    }
+$result = $mysqli->query($query);
 
-    /* free result set */
-    $result->close();
+/* Récupère un tableau d'objets */
+while ($obj = $result->fetch_object()) {
+    printf("%s (%s)\n", $obj->Name, $obj->CountryCode);
 }
-
-/* Fermeture de la connexion */
-$mysqli->close();
-?>
 ]]>
    </programlisting>
-  </example>
-  <example>
-   <title>&style.procedural;</title>
+   <para>&style.procedural;</para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$link = mysqli_connect("localhost", "my_user", "my_password", "world");
 
-/* Vérification de la connexion */
-if (mysqli_connect_errno()) {
-    printf("Échec de la connexion : %s\n", mysqli_connect_error());
-    exit();
-}
-
-$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$link = mysqli_connect("localhost", "my_user", "my_password", "world");
 
-if ($result = mysqli_query($link, $query)) {
+$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
 
-    /* Récupère un tableau d'objets */
-    while ($obj = mysqli_fetch_object($result)) {
-        printf ("%s (%s)\n", $obj->Name, $obj->CountryCode);
-    }
+$result = mysqli_query($link, $query);
 
-    /* free result set */
-    mysqli_free_result($result);
+/* Récupère un tableau associatif */
+while ($obj = mysqli_fetch_object($result)) {
+    printf("%s (%s)\n", $obj->Name, $obj->CountryCode);
 }
-
-/* Fermeture de la connexion */
-mysqli_close($link);
-?>
 ]]>
    </programlisting>
-   &examples.outputs;
+   &examples.outputs.similar;
    <screen>
 <![CDATA[
 Pueblo (USA)
diff --git a/reference/mysqli/mysqli_result/fetch-row.xml b/reference/mysqli/mysqli_result/fetch-row.xml
index d73d18c575..cae8931fda 100644
--- a/reference/mysqli/mysqli_result/fetch-row.xml
+++ b/reference/mysqli/mysqli_result/fetch-row.xml
@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- $Revision$ -->
-<!-- EN-Revision: c1434c95fc666c20cdbd1e1d9a4183e0d11fb88c Maintainer: yannick Status: ready -->
-<!-- Reviewed: yes -->
+<!-- EN-Revision: ca5c477437fcb21680408bf7e0cc0424853e7907 Maintainer: yannick Status: ready -->
+<!-- Reviewed: no -->
 
 <refentry xml:id="mysqli-result.fetch-row" xmlns="http://docbook.org/ns/docbook">
  <refnamediv>
@@ -30,6 +30,7 @@
    prochaine ligne dans le jeu de résultats, ou &null; s'il n'y a plus de
    lignes.
   </para>
+  &database.fetch-null;
  </refsect1>
 
  <refsect1 role="parameters">
@@ -44,78 +45,52 @@
  <refsect1 role="returnvalues">
   &reftitle.returnvalues;
   <para>
-   <function>mysqli_fetch_row</function> retourne un tableau de chaînes correspondant à la ligne
+   <function>mysqli_fetch_row</function> retourne un tableau de valeur correspondant à la ligne
    récupérée ou &null; s'il n'y a plus de ligne dans le jeu de résultats.
   </para>
-  &database.fetch-null;
  </refsect1>
 
  <refsect1 role="examples">
   &reftitle.examples;
   <example>
-   <title>&style.oop;</title>
+   <title>Exemple <methodname>mysqli_result::fetch_row</methodname></title>
+   <para>&style.oop;</para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
 
-/* Vérification de la connexion */
-if (mysqli_connect_errno()) {
-    printf("Échec de la connexion : %s\n", mysqli_connect_error());
-    exit();
-}
-
-$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
 
-if ($result = $mysqli->query($query)) {
+$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
 
-    /* Récupère un tableau associatif */
-    while ($row = $result->fetch_row()) {
-        printf ("%s (%s)\n", $row[0], $row[1]);
-    }
+$result = $mysqli->query($query);
 
-    /* Libère le jeu de résultats */
-    $result->close();
+/* Récupère un tableau d'objets */
+while ($row = $result->fetch_row()) {
+    printf("%s (%s)\n", $row[0], $row[1]);
 }
-
-/* Fermeture de la connexion */
-$mysqli->close();
-?>
 ]]>
    </programlisting>
-  </example>
-  <example>
-   <title>&style.procedural;</title>
+   <para>&style.procedural;</para>
    <programlisting role="php">
 <![CDATA[
 <?php
-$link = mysqli_connect("localhost", "my_user", "my_password", "world");
 
-/* Vérification de la connexion */
-if (mysqli_connect_errno()) {
-    printf("Échec de la connexion : %s\n", mysqli_connect_error());
-    exit();
-}
-
-$query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = mysqli_connect("localhost", "my_user", "my_password", "world");
 
-if ($result = mysqli_query($link, $query)) {
+$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
 
-    /* Récupère un tableau associatif */
-    while ($row = mysqli_fetch_row($result)) {
-        printf ("%s (%s)\n", $row[0], $row[1]);
-    }
+$result = mysqli_query($mysqli, $query);
 
-    /* Libère le jeu de résultats */
-    mysqli_free_result($result);
+/* Récupère un tableau associatif */
+while ($row = mysqli_fetch_row($result)) {
+    printf("%s (%s)\n", $row[0], $row[1]);
 }
-
-/* Fermeture de la connexion */
-mysqli_close($link);
-?>
 ]]>
    </programlisting>
-   &examples.outputs;
+   &examples.outputs.similar;
    <screen>
 <![CDATA[
 Pueblo (USA)