cvs: phpdoc /fr/functions fbsql.xml

From: Date: Fri, 13 Jul 2001 07:53:59 +0000
Subject: cvs: phpdoc /fr/functions fbsql.xml
Groups: php.doc 
Request: Send a blank email to phpdoc+get-969336223@lists.php.net to get a copy of this message
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>
« previous php.doc (#969336223) next »