cvs: phpdoc-fr /reference/mssql/functions mssql-fetch-object.xml

dams Thu Jan 29 05:50:18 2009 UTC Modified files: /phpdoc-fr/reference/mssql/functions mssql-fetch-object.xml Log: synch with en http://cvs.php.net/viewvc.cgi/phpdoc-fr/reference/mssql/functions/mssql-fetch-object.xml?r1=1.14&r2=1.15&diff_format=u Index: phpdoc-fr/reference/mssql/functions/mssql-fetch-object.xml diff -u phpdoc-fr/reference/mssql/functions/mssql-fetch-object.xml:1.14 phpdoc-fr/reference/mssql/functions/mssql-fetch-object.xml:1.15 --- phpdoc-fr/reference/mssql/functions/mssql-fetch-object.xml:1.14 Mon Jul 23 19:06:59 2007 +++ phpdoc-fr/reference/mssql/functions/mssql-fetch-object.xml Thu Jan 29 05:50:17 2009 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.14 $ --> +<!-- $Revision: 1.15 $ --> <!-- EN-Revision: 1.10 Maintainer: yannick Status: ready --> <!-- Reviewed: yes --> @@ -57,6 +57,46 @@ </para> </refsect1> + <refsect1 role="examples"> + &reftitle.examples; + <para> + <example> + <title>Exemple avec <function>mssql_fetch_object</function></title> + <programlisting role="php"> +<![CDATA[ +<?php +// Envoie une requête de sélection à MSSQL +$query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]'); + +// Check if there were any records +if(!mssql_num_rows($query)) +{ + echo 'Aucune ligne trouvée'; +} +else +{ + // Affiche une liste d'utilisateur au format : + // * nom (login) + + echo '<ul>'; + + while($row = mssql_fetch_object($query)) + { + echo '<li>' . $row->name . ' (' . $row->username . ')</li>'; + } + + echo '</ul>'; +} + +// Libère le résultat +mssql_free_result($query); +?> +]]> + </programlisting> + </example> + </para> + </refsect1> + <refsect1 role="notes"> &reftitle.notes; &database.field-case;