manuzhai Mon Apr 29 06:30:37 2002 EDT
Modified files:
/phpdoc/nl/reference/mysql/functions mysql-error.xml
mysql-escape-string.xml
mysql-fetch-array.xml
mysql-fetch-assoc.xml
mysql-fetch-field.xml
mysql-fetch-lengths.xml
mysql-fetch-object.xml
mysql-fetch-row.xml
mysql-field-flags.xml
mysql-field-len.xml
mysql-field-name.xml
mysql-field-seek.xml
mysql-field-table.xml
mysql-field-type.xml
mysql-free-result.xml
mysql-get-client-info.xml
mysql-get-host-info.xml
mysql-get-proto-info.xml
mysql-get-server-info.xml
mysql-insert-id.xml
mysql-list-dbs.xml
mysql-list-fields.xml
mysql-list-tables.xml
mysql-num-fields.xml
mysql-num-rows.xml
mysql-pconnect.xml
mysql-query.xml
mysql-result.xml
mysql-select-db.xml
mysql-stat.xml
mysql-tablename.xml
mysql-unbuffered-query.xml
Log:
Synced to EN.
Index: phpdoc/nl/reference/mysql/functions/mysql-error.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-error.xml:1.3
phpdoc/nl/reference/mysql/functions/mysql-error.xml:1.4
--- phpdoc/nl/reference/mysql/functions/mysql-error.xml:1.3 Mon Apr 29 05:48:33
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-error.xml Mon Apr 29 06:30:36 2002
@@ -21,12 +21,13 @@
</para>
<para>
Errors die terug komen van de MySQL database module geven geen
- warnings meer. In plaats daarvan kun je <function>mysql_errer</function>
- gebruiken om de fout tekst op te halen. Merk op dat deze functie alleen
- de fout tekst van de meest recent uitgevoerde MySQL functie
- (<function>mysql_error</function> en <function>mysql_errno</function>
- uitgezonderd) ophaalt, dus als je hem wil gebruiken, zorg dat je
- de waarde controleert voordat je een andere MySQL functie aanroept.
+ warnings meer. In plaats daarvan kun je <function>mysql_error
+ </function> gebruiken om de fout tekst op te halen. Merk op
+ dat deze functie alleen de fout tekst van de meest recent
+ uitgevoerde MySQL functie (<function>mysql_error</function>
+ en <function>mysql_errno</function> uitgezonderd) ophaalt, dus als
+ je hem wil gebruiken, zorg dan dat je de waarde controleert voordat je
+ een andere MySQL functie aanroept.
<example>
<title><function>mysql_error</function> voorbeeld</title>
<programlisting role="php">
Index: phpdoc/nl/reference/mysql/functions/mysql-escape-string.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-escape-string.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-escape-string.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-escape-string.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-escape-string.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-escape-string' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.62 -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-escape-string">
<refnamediv>
<refname>mysql_escape_string</refname>
@@ -14,11 +11,13 @@
<title>Beschrijving</title>
<methodsynopsis>
<type>string</type><methodname>mysql_escape_string</methodname>
-
<methodparam><type>string</type><parameter>unescaped_string</parameter></methodparam>
+ <methodparam><type>string</type><parameter>unescaped_string
+ </parameter></methodparam>
</methodsynopsis>
<para>
Deze functie zal de <parameter>unescaped_string</parameter> escapen,
- zodat het veilig is om hem in een <function>mysql_query</function> gebruiken.
+ zodat het veilig is om hem in een <function>mysql_query</function>
+ gebruiken.
</para>
<note>
<simpara>
@@ -26,6 +25,12 @@
<literal>%</literal> en <literal>_</literal> niet.
</simpara>
</note>
+ <para>
+ Zie ook: <function>mysql_real_escape_string</function>,
+ <function>addslashes</function>, en de
+ <link linkend="ini.magic-quotes-gpc">magic_quotes_gpc</link>
+ directive.
+ </para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-fetch-array.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-fetch-array.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-fetch-array.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-fetch-array.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-fetch-array.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-fetch-array' in en/ tree in rev 1.27 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.27 -->
+<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-fetch-array">
<refnamediv>
<refname>mysql_fetch_array</refname>
@@ -36,13 +33,14 @@
gebruiken of een alias maken voor de kolom. Voor gealiasde kolommen kun je
geen toegang krijgen tot de inhoud met de originele kolom naam
(door <literal>'field'</literal> te gebruiken in dit voorbeeld).
- <informalexample>
+ <example>
+ <title>Query met dubbele veldnamen</title>
<programlisting role="sql">
<![CDATA[
-select tone.field as foo ttwo.field as bar from tone, ttwo
+select table1.field as foo table2.field as bar from table1, table2
]]>
</programlisting>
- </informalexample>
+ </example>
</para>
<para>
Belangrijk is het door te hebben dat
@@ -65,30 +63,68 @@
en met MYSQL_NUM krijg je alleen numerieke indices (zoals
<function>mysql_fetch_row</function>).
</para>
- <para>
- Voor verdere details, zie ook
- <function>mysql_fetch_row</function> en
- <function>mysql_fetch_assoc</function>.
- </para>
<example>
- <title>MySQL fetch array voorbeeld</title>
+ <title>mysql_fetch_array met MYSQL_NUM</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("could not connect");
+ mysql_select_db("mydb");
+
+ $result = mysql_query("SELECT id, name FROM mytable");
+
+ while (($row = mysql_fetch_array($result, MYSQL_NUM))
+ printf ("ID: %s Name: %s", $row[0], $row[1]);
+
+ mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
+ <example>
+ <title>mysql_fetch_array met MYSQL_ASSOC</title>
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect($host, $user, $password);
-mysql_select_db("database");
-$result = mysql_query("select user_id, fullname from table");
-while ($row = mysql_fetch_array($result)) {
- echo "user_id: ".$row["user_id"]."<br>\n";
- echo "user_id: ".$row[0]."<br>\n";
- echo "fullname: ".$row["fullname"]."<br>\n";
- echo "fullname: ".$row[1]."<br>\n";
-}
-mysql_free_result($result);
+ mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("could not connect");
+ mysql_select_db("mydb");
+
+ $result = mysql_query("SELECT id, name FROM mytable");
+
+ while (($row = mysql_fetch_array($result, MYSQL_ASSOC))
+ printf ("ID: %s Name: %s", $row["id"], $row["name"]);
+
+ mysql_free_result($result);
?>
]]>
</programlisting>
</example>
+ <example>
+ <title>mysql_fetch_array met MYSQL_BOTH</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("could not connect");
+ mysql_select_db("mydb");
+
+ $result = mysql_query("SELECT id, name FROM mytable");
+
+ while (($row = mysql_fetch_array($result, MYSQL_BOTH))
+ printf ("ID: %s Name: %s", $row[0], $row["name"]);
+
+ mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ Voor verder details, zie ook
+ <function>mysql_fetch_row</function> en
+ <function>mysql_fetch_assoc</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-fetch-assoc.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-fetch-assoc.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-fetch-assoc.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-fetch-assoc.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-fetch-assoc.xml Mon Apr 29 06:30:36
+2002
@@ -1,9 +1,6 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-fetch-assoc' in en/ tree in rev 1.45 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.45 -->
- <refentry id="function.mysql-fetch-assoc">
+<<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
+< <refentry id="function.mysql-fetch-assoc">
<refnamediv>
<refname>mysql_fetch_assoc</refname>
<refpurpose>
@@ -42,29 +39,31 @@
<function>mysql_fetch_row</function>, terwijl het een
duidelijke toegevoegde waarde heeft.
</para>
- <para>
- Voor verdere details, zie ook
- <function>mysql_fetch_row</function> en
- <function>mysql_fetch_array</function>.
- </para>
+
<example>
- <title>MySQL fetch assoc voorbeeld</title>
+ <title><function>mysql_fetch_assoc</function> voorbeeld</title>
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect($host, $user, $password);
-mysql_select_db($database);
-$query = "select * from table";
-$result = mysql_query($query);
-while ($row = mysql_fetch_assoc($result)) {
- echo $row["user_id"];
- echo $row["fullname"];
-}
-mysql_free_result($result);
+ mysql_connect("localhost", "mysql_user", "mysql_password");
+ mysql_select_db("mydb");
+ $query = "select * from table";
+ $result = mysql_query($query);
+ while ($row = mysql_fetch_assoc($result)) {
+ echo $row["user_id"];
+ echo $row["fullname"];
+ }
+ mysql_free_result($result);
?>
]]>
</programlisting>
</example>
+ <para>
+ Voor verdere details, zie ook
+ <function>mysql_fetch_row</function>,
+ <function>mysql_fetch_array</function> en
+ <function>mysql_query</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-fetch-field.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-fetch-field.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-fetch-field.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-fetch-field.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-fetch-field.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-fetch-field' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-fetch-field">
<refnamediv>
<refname>mysql_fetch_field</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-fetch-lengths.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-fetch-lengths.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-fetch-lengths.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-fetch-lengths.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-fetch-lengths.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-fetch-lengths' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-fetch-lengths">
<refnamediv>
<refname>mysql_fetch_lengths</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-fetch-object.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-fetch-object.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-fetch-object.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-fetch-object.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-fetch-object.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-fetch-object' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-fetch-object">
<refnamediv>
<refname>mysql_fetch_object</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-fetch-row.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-fetch-row.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-fetch-row.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-fetch-row.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-fetch-row.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-fetch-row' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-fetch-row">
<refnamediv>
<refname>mysql_fetch_row</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-field-flags.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-field-flags.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-field-flags.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-field-flags.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-field-flags.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-field-flags' in en/ tree in rev 1.17 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.17 -->
<refentry id="function.mysql-field-flags">
<refnamediv>
<refname>mysql_field_flags</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-field-len.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-field-len.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-field-len.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-field-len.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-field-len.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-field-len' in en/ tree in rev 1.17 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.17 -->
<refentry id="function.mysql-field-len">
<refnamediv>
<refname>mysql_field_len</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-field-name.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-field-name.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-field-name.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-field-name.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-field-name.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-field-name' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-field-name">
<refnamediv>
<refname>mysql_field_name</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-field-seek.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-field-seek.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-field-seek.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-field-seek.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-field-seek.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-field-seek' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-field-seek">
<refnamediv>
<refname>mysql_field_seek</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-field-table.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-field-table.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-field-table.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-field-table.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-field-table.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-field-table' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-field-table">
<refnamediv>
<refname>mysql_field_table</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-field-type.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-field-type.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-field-type.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-field-type.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-field-type.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-field-type' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
+<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-field-type">
<refnamediv>
<refname>mysql_field_type</refname>
@@ -14,8 +11,9 @@
<title>Beschrijving</title>
<methodsynopsis>
<type>string</type><methodname>mysql_field_type</methodname>
- <methodparam><type>iresource</type><parameter>result</parameter></methodparam>
- <methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
+ <methodparam><type>iresource</type><parameter>result</parameter>
+ </methodparam><methodparam><type>int</type>
+ <parameter>field_offset</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_field_type</function> lijkt op de
@@ -25,34 +23,45 @@
zoals uitgebreid wordt beschreven in de <ulink url="&url.mysql.docs;">
MySQL documentatie</ulink>.
<example>
- <title>MySQL field type voorbeeld</title>
+ <title>MySQL field types</title>
<programlisting role="php">
<![CDATA[
<?php
-
-mysql_connect("localhost:3306");
-mysql_select_db("wisconsin");
-$result = mysql_query("SELECT * FROM onek");
-$fields = mysql_num_fields($result);
-$rows = mysql_num_rows($result);
-$i = 0;
-$table = mysql_field_table($result, $i);
-echo "Je '".$table."' tabel heeft ".$fields." velden en ".$rows." records <BR>";
-echo "De tabel heeft de volgende velden: <BR>";
-while ($i < $fields) {
- $type = mysql_field_type($result, $i);
- $name = mysql_field_name($result, $i);
- $len = mysql_field_len($result, $i);
- $flags = mysql_field_flags($result, $i);
- echo $type." ".$name." ".$len." ".$flags."<BR>";
- $i++;
-}
-mysql_close();
-
+ mysql_connect("localhost", "mysql_username", "mysql_password");
+ mysql_select_db("mysql");
+ $result = mysql_query("SELECT * FROM func");
+ $fields = mysql_num_fields($result);
+ $rows = mysql_num_rows($result);
+ $table = mysql_field_table($result, 0);
+ echo "Je '".$table."' table heeft ".$fields." velden en ".$rows." record(s)\n";
+ echo "De tabel heeft de volgende velden:\n";
+ for ($i=0; $i < $fields; $i++) {
+ $type = mysql_field_type($result, $i);
+ $name = mysql_field_name($result, $i);
+ $len = mysql_field_len($result, $i);
+ $flags = mysql_field_flags($result, $i);
+ echo $type." ".$name." ".$len." ".$flags."\n";
+ }
+ mysql_free_result($result);
+ mysql_close();
?>
]]>
</programlisting>
+ <para>
+ Het bovenstaande voorbeeld zou de volgende output genereren:
+ </para>
+ <screen>
+<![CDATA[
+Your 'func' table has 4 fields and 1 record(s)
+The table has the following fields:
+string name 64 not_null primary_key binary
+int ret 1 not_null
+string dl 128 not_null
+string type 9 not_null enum
+]]>
+ </screen>
</example>
+
</para>
<para>
Voor compatibiliteit kan <function>mysql_fieldtype</function>
Index: phpdoc/nl/reference/mysql/functions/mysql-free-result.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-free-result.xml:1.1
phpdoc/nl/reference/mysql/functions/mysql-free-result.xml:1.2
--- phpdoc/nl/reference/mysql/functions/mysql-free-result.xml:1.1 Sun Apr 14
21:37:26 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-free-result.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-free-result' in en/ tree in rev 1.102 -->
-<!-- EN-Revision: 0.0 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.102 -->
+<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-free-result">
<refnamediv>
<refname>mysql_free_result</refname>
@@ -12,16 +9,18 @@
<title>Beschrijving</title>
<methodsynopsis>
<type>bool</type><methodname>mysql_free_result</methodname>
- <methodparam><type>resource</type><parameter>result</parameter></methodparam>
+ <methodparam><type>resource</type><parameter>result</parameter>
+ </methodparam>
</methodsynopsis>
<para>
<function>mysql_free_result</function> zal al het geheugen vrij maken
- dat is geassocieerd met de result identifier <parameter>result</parameter>.
+ dat is geassocieerd met de result identifier
+ <parameter>result</parameter>.
</para>
<para>
<function>mysql_free_result</function> hoeft alleen te worden
- aangeroepen als je je zorgen maakt over hoeveel geheugen
- wordt gebruikt voor queries die grote resultaten teruggeven. Al
+ aangeroepen als je je zorgen maakt over de hoeveelheid geheugen
+ die wordt gebruikt voor queries die grote resultaten teruggeven. Al
het geassocieerde geheugen wordt automatisch vrijgemaakt aan
het eind van de executie van het script.
</para>
Index: phpdoc/nl/reference/mysql/functions/mysql-get-client-info.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-get-client-info.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-get-client-info.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-get-client-info.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-get-client-info.xml Mon Apr 29
+06:30:36 2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.4 -->
-<!-- last change to 'mysql-get-client-info' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.62 -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-get-client-info">
<refnamediv>
<refname>mysql_get_client_info</refname>
@@ -18,8 +15,28 @@
<function>mysql_get_client_info</function> geeft een string die
de library version van de client weergeeft.
</para>
+ <example>
+ <title>mysql_get_client_info voorbeeld</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ printf ("MySQL client info: %s\n", mysql_get_client_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ Het bovenstaande voorbeeld zou de volgende output genereren:
+ </para>
+ <screen>
+<![CDATA[
+MySQL client info: 3.23.39
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_client_info</function> werd toegevoegd PHP 4.0.5.
+ See also: <function>mysql_get_host_info</function>,
+ <function>mysql_get_proto_info</function> en
+ <function>mysql_get_server_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-get-host-info.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-get-host-info.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-get-host-info.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-get-host-info.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-get-host-info.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.4 -->
-<!-- last change to 'mysql-get-host-info' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.62 -->
+<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-get-host-info">
<refnamediv>
<refname>mysql_get_host_info</refname>
@@ -21,8 +18,30 @@
de server host naam. Als <parameter>link_identifier</parameter> niet
wordt gegeven, wordt de laatst geopende verbinding gebruikt.
</para>
+ <example>
+ <title>mysql_get_host_info voorbeeld</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("Kan geen verbinding maken");
+ printf ("MySQL host info: %s\n", mysql_get_host_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ Het bovenstaande voorbeeld zou de volgende output produceren:
+ </para>
+ <screen>
+<![CDATA[
+MySQL host info: Localhost via UNIX socket
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_host_info</function> werd toegevoegd in PHP 4.0.5.
+ See also: <function>mysql_get_client_info</function>,
+ <function>mysql_get_proto_info</function> en
+ <function>mysql_get_server_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-get-proto-info.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-get-proto-info.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-get-proto-info.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-get-proto-info.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-get-proto-info.xml Mon Apr 29
+06:30:36 2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.4 -->
-<!-- last change to 'mysql-get-proto-info' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.62 -->
+<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-get-proto-info">
<refnamediv>
<refname>mysql_get_proto_info</refname>
@@ -12,16 +9,39 @@
<title>Beschrijving</title>
<methodsynopsis>
<type>int</type><methodname>mysql_get_proto_info</methodname>
- <methodparam
choice="opt"><type>resource</type><parameter>link_identifier</parameter></methodparam>
+ <methodparam choice="opt"><type>resource</type>
+ <parameter>link_identifier</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_get_proto_info</function> geeft de protocol versie die
- gebruikt wordt door de verbinding <parameter>link_identifier</parameter>.
- Als <parameter>link_identifier</parameter> wordt weggelaten, wordt de
- laatst geopende verbinding gebruikt.
+ gebruikt wordt door de verbinding <parameter>link_identifier
+ </parameter>. Als <parameter>link_identifier</parameter> wordt
+ weggelaten, wordt de laatst geopende verbinding gebruikt.
</para>
+ <example>
+ <title>mysql_get_proto_info voorbeeld</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("Kan geen verbinding maken");
+ printf ("MySQL protocol version: %s\n", mysql_get_proto_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ Het bovenstaande voorbeeld zou de volgende output produceren:
+ </para>
+ <screen>
+<![CDATA[
+MySQL protocol version : 10
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_proto_info</function> werd toegevoegd in PHP 4.0.5.
+ Zie ook: <function>mysql_get_client_info</function>,
+ <function>mysql_get_host_info</function> en
+ <function>mysql_get_server_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-get-server-info.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-get-server-info.xml:1.1
phpdoc/nl/reference/mysql/functions/mysql-get-server-info.xml:1.2
--- phpdoc/nl/reference/mysql/functions/mysql-get-server-info.xml:1.1 Sun Apr 14
21:37:27 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-get-server-info.xml Mon Apr 29
+06:30:36 2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.4 -->
-<!-- last change to 'mysql-get-server-info' in en/ tree in rev 1.96 -->
-<!-- EN-Revision: 0.0 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.96 -->
+<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-get-server-info">
<refnamediv>
<refname>mysql_get_server_info</refname>
@@ -12,7 +9,8 @@
<title>Beschrijving</title>
<methodsynopsis>
<type>int</type><methodname>mysql_get_server_info</methodname>
- <methodparam
choice="opt"><type>resource</type><parameter>link_identifier</parameter></methodparam>
+ <methodparam choice="opt"><type>resource</type>
+ <parameter>link_identifier</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_get_server_info</function> geeft de server versie die
@@ -20,8 +18,30 @@
Als <parameter>link_identifier</parameter> wordt weggelaten, wordt de
laatst geopende verbinding gebruikt.
</para>
+ <example>
+ <title>mysql_get_server_info voorbeeld</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("Kan geen verbinding maken");
+ printf ("MySQL server version: %s\n", mysql_get_server_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ Het bovenstaande voorbeeld zou de volgende output produceren:
+ </para>
+ <screen>
+<![CDATA[
+MySQL server version: 4.0.1-alpha
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_proto_info</function> werd toegevoegd in PHP 4.0.5.
+ Zie ook: <function>mysql_get_client_info</function>,
+ <function>mysql_get_host_info</function> en
+ <function>mysql_get_proto_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-insert-id.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-insert-id.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-insert-id.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-insert-id.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-insert-id.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-insert-id' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-insert-id">
<refnamediv>
<refname>mysql_insert_id</refname>
@@ -49,6 +46,24 @@
<literal>LAST_INSERT_ID()</literal> in een SQL query.
</para>
</warning>
+ <example>
+ <title>mysql_insert_id voorbeeld</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("Kan geen verbinding maken");
+ mysql_select_db("mydb");
+
+ mysql_query("INSERT INTO mytable (product) values ('kossu');
+ printf ("Laatst toegevoegde record heeft id %d\n", mysql_insert_id());
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ Zie ook: <function>mysql_query</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-list-dbs.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-list-dbs.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-list-dbs.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-list-dbs.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-list-dbs.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-list-dbs' in en/ tree in rev 1.16 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.16 -->
<refentry id="function.mysql-list-dbs">
<refnamediv>
<refname>mysql_list_dbs</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-list-fields.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-list-fields.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-list-fields.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-list-fields.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-list-fields.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-list-fields' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-list-fields">
<refnamediv>
<refname>mysql_list_fields</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-list-tables.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-list-tables.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-list-tables.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-list-tables.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-list-tables.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-list-tables' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-list-tables">
<refnamediv>
<refname>mysql_list_tables</refname>
@@ -28,6 +25,30 @@
Voor compatibiliteit kan <function>mysql_listtables</function>
ook gebruikt worden. Dit wordt echter afgekeurd.
</para>
+ <example>
+ <title>mysql_list_tables voorbeeld</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_user", "mysql_password") or
+ die("Kan geen verbinding maken");
+ mysql_select_db("mydb");
+
+ $result = mysql_list_tables();
+
+ while (($row = mysql_fetch_row($result))
+ printf ("Table: %s\n", $row[0]);
+
+ mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ Zie ook: <function>mysql_list_dbs</function>,
+ <function>mysql_tablename</function>.
+ </para>
+
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-num-fields.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-num-fields.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-num-fields.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-num-fields.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-num-fields.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-num-fields' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-num-fields">
<refnamediv>
<refname>mysql_num_fields</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-num-rows.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-num-rows.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-num-rows.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-num-rows.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-num-rows.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-num-rows' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-num-rows">
<refnamediv>
<refname>mysql_num_rows</refname>
@@ -12,7 +9,8 @@
<title>Beschrijving</title>
<methodsynopsis>
<type>int</type><methodname>mysql_num_rows</methodname>
- <methodparam><type>resource</type><parameter>result</parameter></methodparam>
+ <methodparam><type>resource</type><parameter>result</parameter>
+ </methodparam>
</methodsynopsis>
<para>
<function>mysql_num_rows</function> geeft het aantal rijen
@@ -39,10 +37,18 @@
</programlisting>
</example>
</para>
+ <note>
+ <para>
+ Als je <function>mysql_unbuffered_query</function> gebruikt zal
+ <function>mysql_num_rows</function> niet de correcte waarde
+ teruggeven totdat alle rijen in de resultaat set zijn opgehaald.
+ </para>
+ </note>
<para>
Zie ook:
<function>mysql_affected_rows</function>,
<function>mysql_connect</function>,
+ <function>mysql_data_seek</function>,
<function>mysql_select_db</function>,
<function>mysql_query</function>.
</para>
Index: phpdoc/nl/reference/mysql/functions/mysql-pconnect.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-pconnect.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-pconnect.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-pconnect.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-pconnect.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-pconnect' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-pconnect">
<refnamediv>
<refname>mysql_pconnect</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-query.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-query.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-query.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-query.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-query.xml Mon Apr 29 06:30:36 2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.4 -->
-<!-- last change to 'mysql-query' in en/ tree in rev 1.62 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.62 -->
<refentry id="function.mysql-query">
<refnamediv>
<refname>mysql_query</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-result.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-result.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-result.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-result.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-result.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-result' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-result">
<refnamediv>
<refname>mysql_result</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-select-db.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-select-db.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-select-db.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-select-db.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-select-db.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-select-db' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
<refentry id="function.mysql-select-db">
<refnamediv>
<refname>mysql_select_db</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-stat.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-stat.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-stat.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-stat.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-stat.xml Mon Apr 29 06:30:36 2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.6 -->
-<!-- last change to 'mysql-stat' in en/ tree in rev 1.62 -->
<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.62 -->
<refentry id="function.mysql-stat">
<refnamediv>
<refname>mysql_stat</refname>
Index: phpdoc/nl/reference/mysql/functions/mysql-tablename.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-tablename.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-tablename.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-tablename.xml:1.2 Wed Apr 17 03:14:09
2002
+++ phpdoc/nl/reference/mysql/functions/mysql-tablename.xml Mon Apr 29 06:30:36
+2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-tablename' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-tablename">
<refnamediv>
<refname>mysql_tablename</refname>
@@ -22,20 +19,25 @@
<function>mysql_num_rows</function> functie kan worden gebruikt
om het aantal tabellen in de result pointer te vinden.
<example>
- <title>MySQL tablename voorbeeld</title>
+ <title><function>mysql_tablename</function> voorbeeld</title>
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("host");
-$result = mysql_list_tables("wisconsin");
-for ($i = 0; $i < mysql_num_rows($result); $i++) {
- $tb_names[$i] = mysql_tablename($result, $i);
- echo $tb_names[$i] . "<BR>";
+ mysql_connect("localhost", "mysql_user", "mysql_password");
+ $result = mysql_list_tables("mydb");
+
+ for ($i = 0; $i < mysql_num_rows($result); $i++) {
+ printf ("Table: %s\n", mysql_tablename($result, $i));
+
+ mysql_free_result($result);
}
?>
]]>
</programlisting>
</example>
+ </para>
+ <para>
+ Zie ook: <function>mysql_list_tables</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/nl/reference/mysql/functions/mysql-unbuffered-query.xml
diff -u phpdoc/nl/reference/mysql/functions/mysql-unbuffered-query.xml:1.2
phpdoc/nl/reference/mysql/functions/mysql-unbuffered-query.xml:1.3
--- phpdoc/nl/reference/mysql/functions/mysql-unbuffered-query.xml:1.2 Wed Apr 17
03:14:09 2002
+++ phpdoc/nl/reference/mysql/functions/mysql-unbuffered-query.xml Mon Apr 29
+06:30:36 2002
@@ -1,8 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- splitted from ./nl/functions/mysql.xml, last change in rev 1.1 -->
-<!-- last change to 'mysql-unbuffered-query' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
-<!-- OLD-Revision: 1.95/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-unbuffered-query">
<refnamediv>
<refname>mysql_unbuffered_query</refname>
@@ -14,8 +11,11 @@
<title>Beschrijving</title>
<methodsynopsis>
<type>resource</type><methodname>mysql_unbuffered_query</methodname>
- <methodparam><type>string</type><parameter>query</parameter></methodparam>
- <methodparam
choice="opt"><type>resource</type><parameter>link_identifier</parameter></methodparam>
+ <methodparam><type>string</type><parameter>query</parameter>
+ </methodparam><methodparam choice="opt"><type>resource</type>
+ <parameter>link_identifier</parameter></methodparam>
+ <methodparam choice="opt"><type>int</type>
+ <parameter>result_mode</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_unbuffered_query</function> stuurt een SQL
@@ -29,6 +29,13 @@
volledige SQL query is uitgevoerd. Wanneer je meerdere verbindingen
gebruikt, moet je de optionele parameter
<parameter>link_identifier</parameter> geven.
+ </para>
+ <para>
+ De optionele <parameter>result_mode</parameter> parameter
+ kan MYSQL_USE_RESULT of MYSQL_STORE_RESULT zijn. De default
+ is MYSQL_USE_RESULT, zodat het resultaat niet wordt gebufferd.
+ Zie ook <function>mysql_query</function> voor het tegengestelde
+ van dit gedrag.
</para>
<note>
<para>
