cvs: 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

From: Date: Mon, 29 Apr 2002 10:30:37 +0000
Subject: cvs: 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
Groups: php.doc 
Request: Send a blank email to phpdoc+get-969345015@lists.php.net to get a copy of this message
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>
« previous php.doc (#969345015) next »