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)