costra Wed Jun 5 16:42:03 2002 EDT
Modified files:
/phpdoc-cs/reference/mysql functions.xml reference.xml
/phpdoc-cs/reference/mysql/functions mysql-unbuffered-query.xml
Log:
Updated files
Modified Files:
cs/reference/mysql/reference.xml from en rev. 1.5
cs/reference/mysql/functions/mysql-unbuffered-query.xml from en rev. 1.3
Added Files:
cs/reference/mysql/functions.xml from en rev. 1.1
Index: phpdoc-cs/reference/mysql/functions.xml
diff -u /dev/null phpdoc-cs/reference/mysql/functions.xml:1.3
--- /dev/null Wed Jun 5 16:42:03 2002
+++ phpdoc-cs/reference/mysql/functions.xml Wed Jun 5 16:42:03 2002
@@ -0,0 +1,48 @@
+&reference.mysql.functions.mysql-affected-rows;
+&reference.mysql.functions.mysql-change-user;
+&reference.mysql.functions.mysql-character-set-name;
+&reference.mysql.functions.mysql-close;
+&reference.mysql.functions.mysql-connect;
+&reference.mysql.functions.mysql-create-db;
+&reference.mysql.functions.mysql-data-seek;
+&reference.mysql.functions.mysql-db-name;
+&reference.mysql.functions.mysql-db-query;
+&reference.mysql.functions.mysql-drop-db;
+&reference.mysql.functions.mysql-errno;
+&reference.mysql.functions.mysql-error;
+&reference.mysql.functions.mysql-escape-string;
+&reference.mysql.functions.mysql-fetch-array;
+&reference.mysql.functions.mysql-fetch-assoc;
+&reference.mysql.functions.mysql-fetch-field;
+&reference.mysql.functions.mysql-fetch-lengths;
+&reference.mysql.functions.mysql-fetch-object;
+&reference.mysql.functions.mysql-fetch-row;
+&reference.mysql.functions.mysql-field-flags;
+&reference.mysql.functions.mysql-field-len;
+&reference.mysql.functions.mysql-field-name;
+&reference.mysql.functions.mysql-field-seek;
+&reference.mysql.functions.mysql-field-table;
+&reference.mysql.functions.mysql-field-type;
+&reference.mysql.functions.mysql-free-result;
+&reference.mysql.functions.mysql-get-client-info;
+&reference.mysql.functions.mysql-get-host-info;
+&reference.mysql.functions.mysql-get-proto-info;
+&reference.mysql.functions.mysql-get-server-info;
+&reference.mysql.functions.mysql-info;
+&reference.mysql.functions.mysql-insert-id;
+&reference.mysql.functions.mysql-list-dbs;
+&reference.mysql.functions.mysql-list-fields;
+&reference.mysql.functions.mysql-list-processes;
+&reference.mysql.functions.mysql-list-tables;
+&reference.mysql.functions.mysql-num-fields;
+&reference.mysql.functions.mysql-num-rows;
+&reference.mysql.functions.mysql-pconnect;
+&reference.mysql.functions.mysql-ping;
+&reference.mysql.functions.mysql-query;
+&reference.mysql.functions.mysql-real-escape-string;
+&reference.mysql.functions.mysql-result;
+&reference.mysql.functions.mysql-select-db;
+&reference.mysql.functions.mysql-stat;
+&reference.mysql.functions.mysql-tablename;
+&reference.mysql.functions.mysql-thread-id;
+&reference.mysql.functions.mysql-unbuffered-query;
Index: phpdoc-cs/reference/mysql/reference.xml
diff -u phpdoc-cs/reference/mysql/reference.xml:1.2
phpdoc-cs/reference/mysql/reference.xml:1.3
--- phpdoc-cs/reference/mysql/reference.xml:1.2 Mon Apr 15 18:06:05 2002
+++ phpdoc-cs/reference/mysql/reference.xml Wed Jun 5 16:42:03 2002
@@ -4,7 +4,27 @@
<title>MySQL Funkce</title>
<titleabbrev>MySQL</titleabbrev>
<partintro>
- <simpara>
+ <para id="mysql.intro">
+ Tyto funkce zprost�edkov�vaj� p��stup na MySQL datab�zov� server.
+ V�ce informac� o MySQL lze nal�zt na <ulink
+ url="&url.mysql;">&url.mysql;</ulink>.
+ </para>
+ <para>
+ Dokumentace k MySQL je dostupn� na <ulink
+ url="&url.mysql.docs;">&url.mysql.docs;</ulink>.
+ </para>
+
+ <section id="mysql.requirements">
+ <title>Po�adavky</title>
+ <para>
+ Aby byly tyto funkce dostupn�, mus� b�t PHP zkompilov�no s podporou
+MySQL.
+ </para>
+ </section>
+
+ <section id="mysql.installation">
+ <title>Instalace</title>
+ <para>
Tyto funkce zprost�edkov�vaj� p��stup na MySQL datab�zov� server.
Maj�-li b�t tyto funkce dostupn�, mus� b�t PHP zkompilov�no s
podporou MySQL parametrem <option role="configure">--with-mysql</option>.
@@ -17,71 +37,301 @@
<option role="configure">--with-mysql=/cesta/k/mysql</option>.
PHP tak pou�ije klientsk� knihovny instalovan� MySQL, ��m� se vyvarujete
mo�n�ch konflikt�m.
- </simpara>
- <simpara>
- V�ce informac� o MySQL naleznete na <ulink
- url="&url.mysql;">&url.mysql;</ulink>.
- </simpara>
- <simpara>
- Dokumentace k MySQL je na <ulink
- url="&url.mysql.docs;">&url.mysql.docs;</ulink>.
- </simpara>
+ </para>
+ </section>
+
+ <section id="mysql.configuration">
+ <title>Runtime konfigurace</title>
<para>
Chov�n� funkc� MySQL je ovlivn�no nastaven�m v glob�ln�m
- <link linkend="configuration">konfihura�n�m</link> souboru.
- <table>
- <title><link linkend="ini.sect.mysql">Konfigurace MySQL</link>
- Volby</title>
- <tgroup cols="3">
- <thead>
- <row>
- <entry>Jm�no</entry>
- <entry>V�choz�</entry>
- <entry>Zm�niteln�</entry>
- </row>
- </thead>
- <tbody>
- <row>
- <entry>mysql.allow_persistent</entry>
- <entry>"On"</entry>
- <entry>PHP_INI_SYSTEM</entry>
- </row>
- <row>
- <entry>mysql.max_persistent</entry>
- <entry>"-1"</entry>
- <entry>PHP_INI_SYSTEM</entry>
- </row>
- <row>
- <entry>mysql.max_links</entry>
- <entry>"-1"</entry>
- <entry>PHP_INI_SYSTEM</entry>
- </row>
- <row>
- <entry>mysql.default_port</entry>
- <entry>NULL</entry>
- <entry>PHP_INI_ALL</entry>
- </row>
- <row>
- <entry>mysql.default_socket</entry>
- <entry>NULL</entry>
- <entry>PHP_INI_ALL</entry>
- </row>
- <row>
- <entry>mysql.default_host</entry>
- <entry>NULL</entry>
- <entry>PHP_INI_ALL</entry>
- </row>
- <row>
- <entry>mysql.default_user</entry>
- <entry>NULL</entry>
- <entry>PHP_INI_ALL</entry>
- </row>
- </tbody>
- </tgroup>
- </table>
+ <link linkend="configuration.file">konfigura�n�m souboru</link> &php.ini;.
+ <table>
+ <title>Mo�nosti nastaven� MySQL</title>
+ <tgroup cols="3">
+ <thead>
+ <row>
+ <entry>Jm�no</entry>
+ <entry>V�choz�</entry>
+ <entry>Zm�niteln�</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>mysql.allow_persistent</entry>
+ <entry>"On"</entry>
+ <entry>PHP_INI_SYSTEM</entry>
+ </row>
+ <row>
+ <entry>mysql.max_persistent</entry>
+ <entry>"-1"</entry>
+ <entry>PHP_INI_SYSTEM</entry>
+ </row>
+ <row>
+ <entry>mysql.max_links</entry>
+ <entry>"-1"</entry>
+ <entry>PHP_INI_SYSTEM</entry>
+ </row>
+ <row>
+ <entry>mysql.default_port</entry>
+ <entry>NULL</entry>
+ <entry>PHP_INI_ALL</entry>
+ </row>
+ <row>
+ <entry>mysql.default_socket</entry>
+ <entry>NULL</entry>
+ <entry>PHP_INI_ALL</entry>
+ </row>
+ <row>
+ <entry>mysql.default_host</entry>
+ <entry>NULL</entry>
+ <entry>PHP_INI_ALL</entry>
+ </row>
+ <row>
+ <entry>mysql.default_user</entry>
+ <entry>NULL</entry>
+ <entry>PHP_INI_ALL</entry>
+ </row>
+ <row>
+ <entry>mysql.default_password</entry>
+ <entry>NULL</entry>
+ <entry>PHP_INI_ALL</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </table>
Podrobn� popis a definice konstant PHP_INI_* naleznete v
<function>ini_set</function>.
</para>
+ <para>
+ Zde je kr�tk� vysv�tlen� konfigura�n�ch p��kaz�.
+ <variablelist>
+
+ <varlistentry id="ini.mysql.allow-persistent">
+ <term>
+ <parameter>mysql.allow_persistent</parameter>
+ <type>boolean</type>
+ </term>
+ <listitem>
+ <para>
+ M�-li b�t povoleno
+ <link linkend="features.persistent-connections">persistentn� (trval�)
+spojen�</link> s MySQL.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.max-persistent">
+ <term>
+ <parameter>mysql.max_persistent</parameter>
+ <type>integer</type>
+ </term>
+ <listitem>
+ <para>
+ Maxim�ln� po�et persistentn�ch spojen� na jeden proces.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.max-links">
+ <term>
+ <parameter>mysql.max_links</parameter>
+ <type>integer</type>
+ </term>
+ <listitem>
+ <para>
+ Maxim�ln� po�et spojen� s MySQL na jeden proces v�etn� persistentn�ch
+spojen�.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-port">
+ <term>
+ <parameter>mysql.default_port</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ ��slo v�choz�ho TCP portu pro spojen� s datab�zov�m serverem, pokud nen�
+port zad�n. Nen�-li v�choz� port zad�n, pou�ije se port uveden� v prom�nn�
+prost�ed� <literal>MYSQL_TCP_PORT</literal>., z�znam
+<literal>mysql-tcp</literal> v <filename>/etc/services</filename>
+nebo "compile-time" konstanta <literal>MYSQL_PORT</literal>, v tomto
+po�ad�. Win32 pou��v� pouze konstantu <literal>MYSQL_PORT</literal>.
+</para> </listitem>
+</varlistentry>
+
+ <varlistentry id="ini.mysql.default-socket">
+ <term>
+ <parameter>mysql.default_socket</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ V�choz� jm�no socketu pro p�ipojen� k lok�ln�mu datab�zov�mu serveru,
+nen�-li jin� socket specifikov�n. </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-host">
+ <term>
+ <parameter>mysql.default_host</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ V�choz� server pro spojen� s datab�zov�m serverem, nen�-li uveden jin�.
+ Nelze pou��t p�i <link linkend="ini.safe-mode">bezpe�n�m re�imu (safe
+mode)</link>. </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-user">
+ <term>
+ <parameter>mysql.default_user</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ V�choz� u�ivatel pro spojen� s datab�zov�m serverem, nen�-li uveden jin�
+u�ivatel. Nelze pou��t p�i <link linkend="ini.safe-mode">bezpe�n�m re�imu (safe
+mode)</link>.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-password">
+ <term>
+ <parameter>mysql.default_password</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ V�choz� heslo pro spojen� s datab�zov�m serverem, nen�-li uveeno jin�
+heslo. Nelze pou��t p�i <link linkend="ini.safe-mode">bezpe�n�m re�imu (safe
+mode)</link>.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ </variablelist>
+ </para>
+ </section>
+
+ <section id="mysql.resources">
+ <title>Typy zdroj�</title>
+ <para>
+ V modulu MySQL jsou pou�ity dva typy zdroj�. Prvn� zdroj je
+identifik�tor datab�zov�ho spojen� a druh�, kter� vykon�v� v�sledek dotazu..</para>
+ </section>
+
+ <section id="mysql.constants">
+ <title>P�eddefinovan� konstanty</title>
+ <para>
+ Funkce <function>mysql_fetch_array</function> pou��v� konstanty pro
+r�zn� typy v�sledkov�ch pol�. Jsou definov�ny n�sleduj�c� konstanty:
+ <table>
+ <title>MySQL fetch konstanty</title>
+ <tgroup cols="2">
+ <thead>
+ <row>
+ <entry>konstanta</entry>
+ <entry>popis</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>MYSQL_ASSOC</entry>
+ <entry>
+ Sloupce jsou vraceny do pole jeho� kl��emi jsou n�zvy sloupc�.
+ </entry>
+ </row>
+ <row>
+ <entry>MYSQL_BOTH</entry>
+ <entry>
+ Sloupce jsou vr�ceny do pole maj�c�ho ��slen� i textov�
+kl��e, ur�uj�c� po�ad� sloupce v tabulce, respektive jeho jm�no.</entry>
+ </row>
+ <row>
+ <entry>MYSQL_NUM</entry>
+ <entry>
+ Vrac� sloupec do pole s ��seln�mi kl��i reprezentuj�c�mi po�ad� sloupce
+v tabulce. Prvn� sloupec tabulky za��n� kl��em 0.</entry>
+ </row>
+ <row>
+ <entry>MYSQL_STORE_RESULT</entry>
+ <entry>
+ Ur�uje, zda by m�l b�t v�sledek MySQL bufferov�n.
+ </entry>
+ </row>
+ <row>
+ <entry>MYSQL_USE_RESULT</entry>
+ <entry>
+ Ur�uje, zda by v�sledek MySQL nem�l b�t bufferov�n.
+ </entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </table>
+ </para>
+ </section>
+
+ <section id="mysql.examples">
+ <para>
+ Zde je jednoduch� uk�zkov� p��klad jak se p�ipojit, prov�st dotaz,
+ zobrazit v�sledn� ��dky a odpojit se z MySQL datab�ze.
+ <example>
+ <title>Uk�zkov� p��klad pou�it� MySQL</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+// P�ipojen�, v�b�r datab�ze
+$link = mysql_connect("mysql_host", "mysql_login", "mysql_heslo")
+ or die("Nelze se p�ipojit");
+print "P�ipojeno �sp�n�!";
+mysql_select_db("moje_databaze")
+ or die("Nelze vybrat datab�zi");
+
+// P��prava SQL dotazu
+$query = "SELECT * FROM moje_tabulka";
+$result = mysql_query($query)
+ or die("Dotaz nelze prov�st");
+
+// Zobrazen� v�sledku v HTML
+print "<table>\n";
+while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
+ print "\t<tr>\n";
+ foreach ($line as $col_value) {
+ print "\t\t<td>$col_value</td>\n";
+ }
+ print "\t</tr>\n";
+}
+print "</table>\n";
+
+// Odpojen� z MySQL datab�ze
+mysql_close($link);
+?>
+]]>
+ </programlisting>
+ </example>
+ </para>
+ </section>
+ </partintro>
+
+&reference.mysql.functions;
+
+ </reference>
+
+
+
+
+
+
+
+
+
+
+
<para>
Toto je jednoduch� uk�zkov� p��klad jak se p�ipojit, prov�st dotaz,
zobrazit v�sledn� ��dky a odpojit se z MySQL datab�ze.
Index: phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml:1.2 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml Wed Jun 5
+16:42:03 2002
@@ -19,7 +19,7 @@
<para>
<function>mysql_unbuffered_query</function> po�le SQL dotaz
<parameter>dotaz</parameter> do MySQL bez na�ten� a bufferov�n� v�sledn�ch
-z�znam� automaticky, jako to d�l� funce
+z�znam� automaticky, jako to d�l� funkce
<function>mysql_query</function>. Na jednu stranu toto chov�n� u�et�� zna�n�
mno�stv� pou�it� pam�ti u SQL dotaz�, kter� vytv��ej� rozs�hl� v�sledky. Na
druhou stranu m��ete za��t pracovat na v�sledku okam�it� po prvn�m z�znamu,
