[PHP-DOC] cvs: phpdoc /fr/functions fbsql.xml

[Damien Seguy]

dams            Fri Jul 13 03:53:59 2001 EDT

  Modified files:              
    /phpdoc/fr/functions        fbsql.xml 
  Log:
  Adding last updates, so as to build french manual.
  
Index: phpdoc/fr/functions/fbsql.xml
diff -u phpdoc/fr/functions/fbsql.xml:1.3 phpdoc/fr/functions/fbsql.xml:1.4
--- phpdoc/fr/functions/fbsql.xml:1.3   Sun Jul  8 09:01:23 2001
+++ phpdoc/fr/functions/fbsql.xml       Fri Jul 13 03:53:59 2001
@@ -182,8 +182,6 @@
     Utiliser <function>fbsql_close</function> n'est pas n&eacute;cessaire, car les
     liens non persistants seront automatiquement ferm&eacute; &agrave; la fin du 
script.
    </para>
-   <note>
-   </note>
    <example>
     <title>Exemple avec <function>fbsql_close</function></title>
     <programlisting role="php">
@@ -348,19 +346,19 @@
     fbsql_select_db("samp_db")
         or die ("Impossible de s&eacute;lectionner une base");
     $query = "SELECT last_name, first_name FROM friends;";
-    $result = fbsql_query ($query)
+    $result = fbsql_query($query)
         or die ("Query failed");
     # Lecture des lignes en ordre inverse
-    for ($i = fbsql_num_rows ($result) - 1; $i &gt;=0; $i--) {
-        if (!fbsql_data_seek ($result, $i)) {
+    for ($i = fbsql_num_rows($result) - 1; $i &gt;=0; $i--) {
+        if (!fbsql_data_seek($result, $i)) {
             printf ("Impossible d'acc&eacute;der &agrave; la ligne %d\n", $i);
             continue;
         }
-        if(!($row = fbsql_fetch_object ($result)))
+        if(!($row = fbsql_fetch_object($result)))
             continue;
         printf ("%s %s&lt;BR&gt;\n", $row-&gt;last_name, $row-&gt;first_name);
     }
-    fbsql_free_result ($result);
+    fbsql_free_result($result);
 ?&gt;
     </programlisting>
    </example>
@@ -468,12 +466,12 @@
     <informalexample>
      <programlisting role="php">
 &lt;?php
-fbsql_connect("marliesle");
-echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
-fbsql_select_db("nonexistentdb");
-echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
-$conn = fbsql_query("SELECT * FROM nonexistenttable;");
-echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
+  fbsql_connect("marliesle");
+  echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
+  fbsql_select_db("nonexistentdb");
+  echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
+  $conn = fbsql_query("SELECT * FROM nonexistenttable;");
+  echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
 ?&gt;
      </programlisting>
     </informalexample>
@@ -518,12 +516,12 @@
     <informalexample>
      <programlisting role="php">
 &lt;?php
-fbsql_connect("marliesle");
-echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
-fbsql_select_db("nonexistentdb");
-echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
-$conn = fbsql_query("SELECT * FROM nonexistenttable;");
-echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
+  fbsql_connect("marliesle");
+  echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
+  fbsql_select_db("nonexistentdb");
+  echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
+  $conn = fbsql_query("SELECT * FROM nonexistenttable;");
+  echo fbsql_errno().": ".fbsql_error()."&lt;br&gt;";
 ?&gt;
      </programlisting>
     </informalexample>
@@ -596,15 +594,15 @@
     <title>Exemple avec <function>fbsql_fetch_array</function></title>
     <programlisting role="php">
 &lt;?php
-fbsql_connect ($host, $user, $password);
-$result = fbsql_db_query ("database","select user_id, fullname from table");
-while ($row = fbsql_fetch_array ($result)) {
+  fbsql_connect($host, $user, $password);
+  $result = fbsql_db_query("database","select user_id, fullname from table");
+  while ($row = fbsql_fetch_array($result)) {
     echo "user_id: ".$row["user_id"]."&lt;br&gt;\n";
     echo "user_id: ".$row[0]."&lt;br&gt;\n";
     echo "fullname: ".$row["fullname"]."&lt;br&gt;\n";
     echo "fullname: ".$row[1]."&lt;br&gt;\n";
-}
-fbsql_free_result ($result);
+  }
+  fbsql_free_result($result);
 ?&gt;
     </programlisting>
    </example>
@@ -653,16 +651,16 @@
     <function>fbsql_fetch_row</function> et <function>fbsql_fetch_array</function>.
    </para>
    <example>
-    <title>Exemple d'un <function>fbsql_fetch_assoc</function></title>
+    <title>Exemple avec <function>fbsql_fetch_assoc</function></title>
     <programlisting role="php">
 &lt;?php
-fbsql_connect ($host, $user, $password);
-$result = fbsql_db_query ("database","select * from table;");
-while ($row = fbsql_fetch_assoc ($result)) {
+  fbsql_connect($host, $user, $password);
+  $result = fbsql_db_query("database","select * from table;");
+  while ($row = fbsql_fetch_assoc($result)) {
     echo $row["user_id"];
     echo $row["fullname"];
-}
-fbsql_free_result ($result);
+  }
+  fbsql_free_result($result);
 ?&gt;
     </programlisting>
    </example>
@@ -732,28 +730,28 @@
     <title>Exemple avec <function>fbsql_fetch_field</function></title>
     <programlisting role="php">
 &lt;?php
-fbsql_connect ($host, $user, $password)
+  fbsql_connect($host, $user, $password)
     or die ("Impossible de se connecter");
-$result = fbsql_db_query ("database", "select * from table;")
+  $result = fbsql_db_query("database", "select * from table;")
     or die ("Query failed");
 # get column metadata
-$i = 0;
-while ($i &lt; fbsql_num_fields ($result)) {
+  $i = 0;
+  while ($i &lt; fbsql_num_fields($result)) {
     echo "Information for column $i:&lt;br&gt;\n";
-    $meta = fbsql_fetch_field ($result);
+    $meta = fbsql_fetch_field($result);
     if (!$meta) {
-        echo "No information available&lt;br&gt;\n";
+        echo "Aucune information disponible&lt;br&gt;\n";
     }
-    echo "&lt;PRE>
-max_length:   $meta->max_length
-name:         $meta->name
-not_null:     $meta->not_null
-table:        $meta->table
-type:         $meta->type
-&lt;/PRE>";
+    echo "&lt;PRE&gt;
+max_length:   $meta-&gt;max_length
+name:         $meta-&gt;name
+not_null:     $meta-&gt;not_null
+table:        $meta-&gt;table
+type:         $meta-&gt;type
+&lt;/PRE&gt;";
     $i++;
 }
-fbsql_free_result ($result);
+  fbsql_free_result($result);
 ?&gt;
     </programlisting>
    </example>
@@ -844,13 +842,13 @@
      <title>Exemple avec <function>fbsql_fetch_object</function></title>
      <programlisting role="php">
 &lt;?php
-fbsql_connect ($host, $user, $password);
-$result = fbsql_db_query ("database", "select * from table;");
-while ($row = fbsql_fetch_object ($result)) {
+  fbsql_connect($host, $user, $password);
+  $result = fbsql_db_query("database", "select * from table;");
+  while ($row = fbsql_fetch_object($result)) {
     echo $row->user_id;
     echo $row->fullname;
-}
-fbsql_free_result($result);
+  }
+  fbsql_free_result($result);
 ?&gt;
      </programlisting>
     </example>
@@ -969,9 +967,9 @@
 //   user_id
 //   username
 //   password.
-$res = fbsql_db_query("users", "select * from users;", $link);
-echo fbsql_field_name($res, 0) . "\n";
-echo fbsql_field_name($res, 2);
+  $res = fbsql_db_query("users", "select * from users;", $link);
+  echo fbsql_field_name($res, 0) . "\n";
+  echo fbsql_field_name($res, 2);
 ?&gt;
      </programlisting>
     </example>
@@ -1088,24 +1086,24 @@
      <title>Exemple avec <function>fbsql_field_type</function></title>
      <programlisting role="php">
 &lt;?php
-fbsql_connect ("localhost:3306");
-fbsql_connect ("localhost", "_SYSTEM", "");
-$result = fbsql_query ("SELECT * FROM onek;");
-$fields = fbsql_num_fields ($result);
-$rows   = fbsql_num_rows ($result);
-$i = 0;
-$table = fbsql_field_table ($result, $i);
-echo "Your '".$table."' table has ".$fields." fields and ".$rows." records 
&lt;br&gt;";
-echo "The table has the following fields &lt;br&gt;";
-while ($i &lt; $fields) {
-    $type  = fbsql_field_type  ($result, $i);
-    $name  = fbsql_field_name  ($result, $i);
-    $len   = fbsql_field_len   ($result, $i);
-    $flags = fbsql_field_flags ($result, $i);
+  fbsql_connect("localhost:3306");
+  fbsql_connect("localhost", "_SYSTEM", "");
+  $result = fbsql_query("SELECT * FROM onek;");
+  $fields = fbsql_num_fields($result);
+  $rows   = fbsql_num_rows($result);
+  $i = 0;
+  $table = fbsql_field_table($result, $i);
+  echo "Votre table '".$table."' a ".$fields." colonnes et ".$rows." lignes 
+&lt;br&gt;";
+  echo "La table dispose des champs suivants &lt;br&gt;";
+  while ($i &lt; $fields) {
+    $type  = fbsql_field_type ($result, $i);
+    $name  = fbsql_field_name ($result, $i);
+    $len   = fbsql_field_len  ($result, $i);
+    $flags = fbsql_field_flags($result, $i);
     echo $type." ".$name." ".$len." ".$flags."&lt;br&gt;";
     $i++;
-}
-fbsql_close();
+  }
+  fbsql_close();
 ?&gt;
      </programlisting>
     </example>
@@ -1212,11 +1210,11 @@
      <title>Exemple avec <function>fbsql_list_dbs</function></title>
      <programlisting role="php">
 &lt;?php
-$link = fbsql_connect('localhost', 'myname', 'secret');
-$db_list = fbsql_list_dbs($link);
-while ($row = fbsql_fetch_object($db_list)) {
-  echo $row->Database . "\n";
-}
+  $link = fbsql_connect('localhost', 'myname', 'secret');
+  $db_list = fbsql_list_dbs($link);
+  while ($row = fbsql_fetch_object($db_list)) {
+    echo $row->Database . "\n";
+  }
 ?&gt;
      </programlisting>
     </example>
@@ -1283,12 +1281,12 @@
      <title>Exemple avec <function>fbsql_list_fields</function></title>
      <programlisting role="php">
 &lt;?php
-$link = fbsql_connect('localhost', 'myname', 'secret');
-$fields = fbsql_list_fields("database1", "table1", $link);
-$columns = fbsql_num_fields($fields);
-for ($i = 0; $i &lt; $columns; $i++) {
-  echo fbsql_field_name($fields, $i) . "\n";;
-}
+  $link = fbsql_connect('localhost', 'myname', 'secret');
+  $fields = fbsql_list_fields("database1", "table1", $link);
+  $columns = fbsql_num_fields($fields);
+  for ($i = 0; $i &lt; $columns; $i++) {
+    echo fbsql_field_name($fields, $i) . "\n";;
+  }
 ?&gt;
      </programlisting>
     </example>
@@ -1366,16 +1364,15 @@
     <title>Exemple avec <function>fbsql_next_result</function></title>
     <programlisting role="php">
 &lt;?php
-    $link = fbsql_connect ("localhost", "_SYSTEM", "secret");
-    fbsql_select_db("MyDB", $link);
-    $SQL = "Select * from table1; select * from table2;";
-    $rs = fbsql_query($SQL, $link);
-    do {
-        while ($row = fbsql_fetch_row($rs)) {
-        }
-    } while (fbsql_next_result($rs));
-    fbsql_free_result($rs);
-    fbsql_close ($link);
+  $link = fbsql_connect("localhost", "_SYSTEM", "secret");
+  fbsql_select_db("MyDB", $link);
+  $SQL = "Select * from table1; select * from table2;";
+  $rs = fbsql_query($SQL, $link);
+  do {
+      while ($row = fbsql_fetch_row($rs)) {}
+  } while (fbsql_next_result($rs));
+  fbsql_free_result($rs);
+  fbsql_close($link);
 ?&gt;
     </programlisting>
    </example>
@@ -1430,11 +1427,11 @@
      <title>Exemple <function>fbsql_num_rows</function></title>
      <programlisting role="php">
 &lt;?php
-$link = fbsql_connect("localhost", "username", "password");
-fbsql_select_db("database", $link);
-$result = fbsql_query("SELECT * FROM table1;", $link);
-$num_rows = fbsql_num_rows($result);
-echo "$num_rows Rows\n";
+  $link = fbsql_connect("localhost", "username", "password");
+  fbsql_select_db("database", $link);
+  $result = fbsql_query("SELECT * FROM table1;", $link);
+  $num_rows = fbsql_num_rows($result);
+  echo "$num_rows Rows\n";
 ?&gt;
      </programlisting>
     </example>
@@ -1555,7 +1552,7 @@
      <title>Exemple avec <function>fbsql_query</function>(1)</title>
      <programlisting role="php">
 &lt;?php
-$result = fbsql_query ("SELECT * WHERE 1=1;")
+  $result = fbsql_query("SELECT * WHERE 1=1;")
     or die("Requ&ecirc;te invalide");
 ?&gt;
      </programlisting>
@@ -1569,7 +1566,7 @@
      <title>Exemple avec <function>fbsql_query</function>(2)</title>
      <programlisting role="php">
 &lt;?php
-$result = fbsql_query ("SELECT my_col FROM my_tbl")
+  $result = fbsql_query("SELECT my_col FROM my_tbl")
     or die ("Invalid query");
 ?&gt;
      </programlisting>
@@ -1729,14 +1726,14 @@
      <title>Exemple avec <function>fbsql_tablename</function></title>
      <programlisting role="php">
 &lt;?php
-fbsql_connect ("localhost:3306");
-$result = fbsql_list_tables ("wisconsin");
-$i = 0;
-while ($i &lt; fbsql_num_rows ($result)) {
-    $tb_names[$i] = fbsql_tablename ($result, $i);
+  fbsql_connect("localhost:3306");
+  $result = fbsql_list_tables("wisconsin");
+  $i = 0;
+  while ($i &lt; fbsql_num_rows($result)) {
+    $tb_names[$i] = fbsql_tablename($result, $i);
     echo $tb_names[$i] . "&lt;br&gt;";
     $i++;
-}
+  }
 ?&gt;
      </programlisting>
     </example>