sander Sat Jun 15 05:11:40 2002 EDT
Modified files:
/phpdoc-nl/reference/mysql reference.xml
/phpdoc-nl/reference/mysql/functions mysql-character-set-name.xml
mysql-db-query.xml
mysql-escape-string.xml
mysql-fetch-field.xml
mysql-field-type.xml
mysql-list-tables.xml
mysql-num-fields.xml
mysql-query.xml
mysql-tablename.xml
mysql-thread-id.xml
Log:
Sync with EN
Index: phpdoc-nl/reference/mysql/reference.xml
diff -u phpdoc-nl/reference/mysql/reference.xml:1.5
phpdoc-nl/reference/mysql/reference.xml:1.6
--- phpdoc-nl/reference/mysql/reference.xml:1.5 Mon Apr 29 07:03:32 2002
+++ phpdoc-nl/reference/mysql/reference.xml Sat Jun 15 05:11:39 2002
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.5 $ -->
-<!-- EN-Revision: 1.5 Maintainer: manuzhai Status: ready -->
+<!-- $Revision: 1.6 $ -->
+<!-- EN-Revision: 1.6 Maintainer: manuzhai Status: ready -->
<reference id="ref.mysql">
<title>MySQL Functies</title>
<titleabbrev>MySQL</titleabbrev>
@@ -39,6 +39,12 @@
role="configure">--with-mysql=/path/to/mysql</option>. Dit zorgt ervoor
dat PHP de client libraries die door MySQL geinstalleerd zijn gebruikt,
zodat een conflict voorkomen wordt.
+ </para>
+ <para>
+ Crashes en problemen met het opstarten van <literal>PHP</literal> kunnen
+ voorkomen als deze extensie samen met de recode extensie wordt geladen.
+ Zie de <link linkend="ref.recode">recode</link> extensie voor meer
+ informatie.
</para>
</section>
Index: phpdoc-nl/reference/mysql/functions/mysql-character-set-name.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-character-set-name.xml:1.2
phpdoc-nl/reference/mysql/functions/mysql-character-set-name.xml:1.3
--- phpdoc-nl/reference/mysql/functions/mysql-character-set-name.xml:1.2 Mon
Apr 29 05:30:53 2002
+++ phpdoc-nl/reference/mysql/functions/mysql-character-set-name.xml Sat Jun 15
+05:11:39 2002
@@ -1,7 +1,7 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.2 $ -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
- <refentry id="function.mysql-character_set_name">
+<!-- $Revision: 1.3 $ -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
+ <refentry id="function.mysql-character-set-name">
<refnamediv>
<refname>mysql_character_set_name</refname>
<refpurpose>Geeft de naam van de character set terug</refpurpose>
Index: phpdoc-nl/reference/mysql/functions/mysql-db-query.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-db-query.xml:1.3
phpdoc-nl/reference/mysql/functions/mysql-db-query.xml:1.4
--- phpdoc-nl/reference/mysql/functions/mysql-db-query.xml:1.3 Mon Apr 29 06:36:54
2002
+++ phpdoc-nl/reference/mysql/functions/mysql-db-query.xml Sat Jun 15 05:11:39
+2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-db-query">
<refnamediv>
<refname>mysql_db_query</refname>
Index: phpdoc-nl/reference/mysql/functions/mysql-escape-string.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-escape-string.xml:1.3
phpdoc-nl/reference/mysql/functions/mysql-escape-string.xml:1.4
--- phpdoc-nl/reference/mysql/functions/mysql-escape-string.xml:1.3 Mon Apr 29
06:30:36 2002
+++ phpdoc-nl/reference/mysql/functions/mysql-escape-string.xml Sat Jun 15 05:11:39
+2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
+<!-- EN-Revision: 1.6 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-escape-string">
<refnamediv>
<refname>mysql_escape_string</refname>
@@ -24,7 +24,35 @@
<function>mysql_escape_string</function> escapet
<literal>%</literal> en <literal>_</literal> niet.
</simpara>
+ <simpara>
+ Deze functie is identiek aan
+ <function>mysql_real_escape_string</function> behalve dat
+ mysql_real_escape_string() een connectie handler als argument neemt en
+ de string escaped volgens de huidige tekenset.
+ <function>mysql_escape_string</function> neemt geen connectie handler
+ argument en negeert de tekenset instelling.
+ </simpara>
</note>
+ <example>
+ <title><function>mysql_escape_string</function> voorbeeld</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ $item = "Zak's Laptop";
+ $escaped_item = mysql_escape_string($item);
+ printf ("Escaped string: %s\n", $escaped_item);
+?>
+]]>
+ </programlisting>
+ <para>
+ Het voorbeeld hierboven zou het volgende weergeven:
+ <screen>
+<![CDATA[
+Escaped string: Zak\'s Laptop
+]]>
+ </screen>
+ </para>
+ </example>
<para>
Zie ook: <function>mysql_real_escape_string</function>,
<function>addslashes</function>, en de
Index: phpdoc-nl/reference/mysql/functions/mysql-fetch-field.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-fetch-field.xml:1.3
phpdoc-nl/reference/mysql/functions/mysql-fetch-field.xml:1.4
--- phpdoc-nl/reference/mysql/functions/mysql-fetch-field.xml:1.3 Mon Apr 29
06:30:36 2002
+++ phpdoc-nl/reference/mysql/functions/mysql-fetch-field.xml Sat Jun 15 05:11:39
+2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-fetch-field">
<refnamediv>
<refname>mysql_fetch_field</refname>
@@ -100,15 +100,15 @@
mysql_select_db("database");
$result = mysql_query("select * from table")
or die("Query heeft gefaald");
-# get column metadata
+/* get column metadata */
$i = 0;
while ($i < mysql_num_fields($result)) {
- echo "Informatie voor kolom $i:<BR>\n";
+ echo "Informatie voor kolom $i:<br />\n";
$meta = mysql_fetch_field($result);
if (!$meta) {
- echo "Geen informatie beschikbaar<BR>\n";
+ echo "Geen informatie beschikbaar<br />\n";
}
- echo "<PRE>
+ echo "<pre>
blob: $meta->blob
max_length: $meta->max_length
multiple_key: $meta->multiple_key
@@ -121,7 +121,7 @@
unique_key: $meta->unique_key
unsigned: $meta->unsigned
zerofill: $meta->zerofill
-</PRE>";
+</pre>";
$i++;
}
mysql_free_result($result);
Index: phpdoc-nl/reference/mysql/functions/mysql-field-type.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-field-type.xml:1.3
phpdoc-nl/reference/mysql/functions/mysql-field-type.xml:1.4
--- phpdoc-nl/reference/mysql/functions/mysql-field-type.xml:1.3 Mon Apr 29
06:30:36 2002
+++ phpdoc-nl/reference/mysql/functions/mysql-field-type.xml Sat Jun 15 05:11:39
+2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
+<!-- EN-Revision: 1.5 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-field-type">
<refnamediv>
<refname>mysql_field_type</refname>
@@ -11,7 +11,7 @@
<title>Beschrijving</title>
<methodsynopsis>
<type>string</type><methodname>mysql_field_type</methodname>
- <methodparam><type>iresource</type><parameter>result</parameter>
+ <methodparam><type>resource</type><parameter>result</parameter>
</methodparam><methodparam><type>int</type>
<parameter>field_offset</parameter></methodparam>
</methodsynopsis>
Index: phpdoc-nl/reference/mysql/functions/mysql-list-tables.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-list-tables.xml:1.3
phpdoc-nl/reference/mysql/functions/mysql-list-tables.xml:1.4
--- phpdoc-nl/reference/mysql/functions/mysql-list-tables.xml:1.3 Mon Apr 29
06:30:36 2002
+++ phpdoc-nl/reference/mysql/functions/mysql-list-tables.xml Sat Jun 15 05:11:39
+2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
+<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-list-tables">
<refnamediv>
<refname>mysql_list_tables</refname>
@@ -19,25 +19,40 @@
een result pointer terug, zoals de <function>mysql_query</function> functie.
Je kunt de <function>mysql_tablename</function> functie gebruiken om de
eigenlijke tabelnamen uit de result pointer te halen, of een andere
- result tabel functie. to extract the
+ result tabel functie zoals <function>mysql_fetch_assoc</function>.
</para>
<para>
- Voor compatibiliteit kan <function>mysql_listtables</function>
- ook gebruikt worden. Dit wordt echter afgekeurd.
+ De <parameter>database</parameter> parameter is de naam van de database
+ waarvan de lijst van tabellen moet worden opgehaald. Als er iets fout
+ gaat, geeft <function>mysql_list_tables</function> &false; terug.
+ </para>
+ <para>
+ Voor compatibiliteit kan de alias <function>mysql_listtables</function>
+ worden gebruikt. Dit wordt echter afgeraden.
</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");
+ $dbname = 'mysql_dbname';
- $result = mysql_list_tables();
+ if (!mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
+ print 'Kan geen verbinding met mysql maken';
+ exit;
+ }
- while (($row = mysql_fetch_row($result))
- printf ("Table: %s\n", $row[0]);
+ $result = mysql_list_tables($dbname);
+
+ if (!$result) {
+ print "DB Error, kan de tabellen niet opvragen\n";
+ print 'MySQL Error: ' . mysql_error();
+ exit;
+ }
+
+ while ($row = mysql_fetch_row($result)) {
+ print "Tabel: $row[0]\n";
+ }
mysql_free_result($result);
?>
@@ -46,7 +61,7 @@
</example>
<para>
Zie ook: <function>mysql_list_dbs</function>,
- <function>mysql_tablename</function>.
+ en <function>mysql_tablename</function>.
</para>
</refsect1>
Index: phpdoc-nl/reference/mysql/functions/mysql-num-fields.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-num-fields.xml:1.3
phpdoc-nl/reference/mysql/functions/mysql-num-fields.xml:1.4
--- phpdoc-nl/reference/mysql/functions/mysql-num-fields.xml:1.3 Mon Apr 29
06:30:36 2002
+++ phpdoc-nl/reference/mysql/functions/mysql-num-fields.xml Sat Jun 15 05:11:39
+2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-num-fields">
<refnamediv>
<refname>mysql_num_fields</refname>
@@ -17,7 +17,7 @@
</para>
<para>
Zie ook:
- <function>mysql_db_query</function>,
+ <function>mysql_select_db</function>,
<function>mysql_query</function>,
<function>mysql_fetch_field</function>,
<function>mysql_num_rows</function>.</para>
Index: phpdoc-nl/reference/mysql/functions/mysql-query.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-query.xml:1.4
phpdoc-nl/reference/mysql/functions/mysql-query.xml:1.5
--- phpdoc-nl/reference/mysql/functions/mysql-query.xml:1.4 Fri May 24 13:18:44
2002
+++ phpdoc-nl/reference/mysql/functions/mysql-query.xml Sat Jun 15 05:11:39 2002
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.4 $ -->
-<!-- EN-Revision: 1.2 Maintainer: manuzhai Status: ready -->
+<!-- $Revision: 1.5 $ -->
+<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-query">
<refnamediv>
<refname>mysql_query</refname>
Index: phpdoc-nl/reference/mysql/functions/mysql-tablename.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-tablename.xml:1.4
phpdoc-nl/reference/mysql/functions/mysql-tablename.xml:1.5
--- phpdoc-nl/reference/mysql/functions/mysql-tablename.xml:1.4 Fri May 24 13:18:44
2002
+++ phpdoc-nl/reference/mysql/functions/mysql-tablename.xml Sat Jun 15 05:11:39
+2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
+<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-tablename">
<refnamediv>
<refname>mysql_tablename</refname>
@@ -25,11 +25,8 @@
<?php
mysql_connect("localhost", "mysql_user", "mysql_password");
$result = mysql_list_tables("mydb");
-
- for ($i = 0; $i < mysql_num_rows($result); $i++) {
+ for ($i = 0; $i < mysql_num_rows($result); $i++)
printf ("Table: %s\n", mysql_tablename($result, $i));
- }
-
mysql_free_result($result);
?>
]]>
Index: phpdoc-nl/reference/mysql/functions/mysql-thread-id.xml
diff -u phpdoc-nl/reference/mysql/functions/mysql-thread-id.xml:1.1
phpdoc-nl/reference/mysql/functions/mysql-thread-id.xml:1.2
--- phpdoc-nl/reference/mysql/functions/mysql-thread-id.xml:1.1 Mon Apr 29 07:06:25
2002
+++ phpdoc-nl/reference/mysql/functions/mysql-thread-id.xml Sat Jun 15 05:11:39
+2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- EN-Revision: 1.3 Maintainer: manuzhai Status: ready -->
+<!-- EN-Revision: 1.4 Maintainer: manuzhai Status: ready -->
<refentry id="function.mysql-thread-id">
<refnamediv>
<refname>mysql_thread_id</refname>
@@ -20,7 +20,7 @@
bewaren voor later. Je moet het ophalen wanneer je het nodig hebt.
</para>
<example>
- <title><function>mysql_list_processes</function> voorbeeld</title>
+ <title><function>mysql_thread_id</function> voorbeeld</title>
<programlisting role="php">
<