costra Sat Jun 8 11:48:43 2002 EDT
Modified files:
/phpdoc-cs/reference/mysql/functions mysql-change-user.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-len.xml
mysql-field-name.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-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:
Some corrections, updates and fixes.
Now MySQL section is complete and total in Czech language.
Modified Files:
mysql-change-user.xml (en rev. 1.2)
mysql-fetch-array.xml (1.5)
mysql-fetch-assoc.xml (1.3)
mysql-fetch-field.xml (1.3)
mysql-fetch-lengths.xml (1.2)
mysql-fetch-object.xml (1.2)
mysql-fetch-row.xml (1.2)
mysql-field-len.xml (1.2)
mysql-field-name.xml (1.2)
mysql-field-table.xml (1.2)
mysql-field-type.xml (1.5)
mysql-free-result.xml (1.2)
mysql-get-client-info.xml (1.3)
mysql-get-host-info.xml (1.4)
mysql-get-proto-info.xml (1.4)
mysql-get-server-info.xml (1.4)
mysql-insert-id.xml (1.4)
mysql-list-fields.xml (1.2)
mysql-list-tables.xml (1.4)
mysql-num-fields.xml (1.3)
mysql-num-rows.xml (1.3)
mysql-pconnect.xml (1.2)
mysql-query.xml (1.3)
mysql-result.xml (1.2)
mysql-select-db.xml (1.2)
mysql-stat.xml (1.2)
mysql-tablename.xml (1.4)
mysql-unbuffered-query.xml (1.3)
Index: phpdoc-cs/reference/mysql/functions/mysql-change-user.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-change-user.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-change-user.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-change-user.xml:1.1 Sun Apr 14
19:47:07 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-change-user.xml Sat Jun 8 11:48:22
+2002
@@ -9,7 +9,7 @@
</refpurpose>
</refnamediv>
<refsect1>
- <title>Charakteristika</title>
+ <title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_change_user</methodname>
@@ -29,15 +29,12 @@
<parameter>databaze</parameter> nastav� se tato datab�ze jako v�choz�,
v opa�n�m p��pad� z�stane aktivn� sou�asn� datab�ze definovan� ve zm�n�n�m
spojen�.
+ &return.success;
</para>
-
- <!-- what is returned? bool -> succes/failure i suppose? -->
- <!-- in PHP 3 int and in PHP 4 bool -->
-
<note>
<para>
Tato funkce byla p�id�na v PHP 3.0.13 a vy�aduje pou�it� MySQL
- 3.23.3 nebo vy���.
+ 3.23.3 nebo vy���. Nen� dostupn� v PHP 4.
</para>
</note>
</refsect1>
Index: phpdoc-cs/reference/mysql/functions/mysql-fetch-array.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-fetch-array.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-fetch-array.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-fetch-array.xml:1.2 Mon Jun 3
17:39:17 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-fetch-array.xml Sat Jun 8 11:48:22
+2002
@@ -61,30 +61,71 @@
<function>mysql_fetch_assoc</function>) a pou�it�m MYSQL_NUM, pole obsahovat
pouze ��seln� kl��e (tak funguje <function>mysql_fetch_row</function>).
</para>
-<para>
- Pro dal�� detaily viz. tak�
- <function>mysql_fetch_row</function> a
- <function>mysql_fetch_assoc</function>.
- </para>
+ <example>
+ <title>mysql_fetch_array s MYSQL_NUM</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_uziv", "mysql_heslo") or
+ die("Nelze se spojit");
+ mysql_select_db("mojedb");
+
+ $result = mysql_query("SELECT id, jmeno FROM moje_table");
+
+ while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
+ printf ("ID: %s Jm�no: %s", $row[0], $row[1]);
+ }
+
+ mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
<example>
- <title><function>mysql_fetch_array</function> p��klad</title>
+ <title>mysql_fetch_array s MYSQL_ASSOC</title>
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect($host, $user, $password);
-mysql_select_db("databaze");
-$result = mysql_query("select uziv_id, celejmeno from tabulka");
-while ($row = mysql_fetch_array($result)) {
- echo "user_id: ".$row["uziv_id"]."<br>\n";
- echo "user_id: ".$row[0]."<br>\n";
- echo "fullname: ".$row["celejmeno"]."<br>\n";
- echo "fullname: ".$row[1]."<br>\n";
-}
-mysql_free_result($result);
+ mysql_connect("localhost", "mysql_uziv", "mysql_heslo") or
+ die("Nelze se spojit");
+ mysql_select_db("mojedb");
+
+ $result = mysql_query("SELECT id, jmeno FROM moje_table");
+
+ while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
+ printf ("ID: %s Jm�no: %s", $row["id"], $row["jmeno"]);
+ }
+
+ mysql_free_result($result);
?>
]]>
</programlisting>
</example>
+ <example>
+ <title>mysql_fetch_array s MYSQL_BOTH</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_uziv", "mysql_heslo") or
+ die("Nelze se spojit");
+ mysql_select_db("mojedb");
+
+ $result = mysql_query("SELECT id, jmeno FROM moje_table");
+
+ while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
+ printf ("ID: %s Jm�no: %s", $row[0], $row["jmeno"]);
+ }
+
+ mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
+<para>
+ Pro dal�� detaily viz. tak�
+ <function>mysql_fetch_row</function> a
+ <function>mysql_fetch_assoc</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml:1.2 Mon Jun 3
17:39:17 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-fetch-assoc.xml Sat Jun 8 11:48:22
+2002
@@ -40,11 +40,6 @@
<function>mysql_fetch_row</function>, pokud je jej� pou�it� p�idanou
hodnotou.
</para>
- <para>
- Pro dal�� detaily viz. tak�
- <function>mysql_fetch_row</function> a
- <function>mysql_fetch_array</function>.
- </para>
<example>
<title><function>mysql_fetch_assoc</function></title>
<programlisting role="php">
@@ -63,6 +58,12 @@
]]>
</programlisting>
</example>
+ <para>
+ Pro dal�� detaily viz. tak�
+ <function>mysql_fetch_row</function>,
+ <function>mysql_fetch_array</function> a
+ <function>mysql_query</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-fetch-field.xml Sat Jun 8 11:48:22
+2002
@@ -61,7 +61,7 @@
</listitem>
<listitem>
<simpara>
- multiple_key - 1 pokud je sloupec neunik�tn� kl��
+ multiple_key - 1 pokud je sloupec jin� ne� unik�tn� kl��
</simpara>
</listitem>
<listitem>
Index: phpdoc-cs/reference/mysql/functions/mysql-fetch-lengths.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-fetch-lengths.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-fetch-lengths.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-fetch-lengths.xml:1.1 Sun Apr 14
19:47:08 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-fetch-lengths.xml Sat Jun 8 11:48:22
+2002
@@ -16,11 +16,11 @@
<methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
</methodsynopsis>
<para>
- Vr�t� pole obsahuj�c� d�lku ka�d�ho sloupce v posledn� na�ten�m z�znamu
+ Vr�c� pole obsahuj�c� d�lku ka�d�ho sloupce v posledn� na�ten�m z�znamu
pomoc� <function>mysql_fetch_row</function>, nebo &false; dojde-li k chyb�.
</para>
<para>
- <function>mysql_fetch_lengths</function> obahuje d�lky hodnot v�ech
+ <function>mysql_fetch_lengths</function> obsahuje d�lky hodnot v�ech
vr�cen�ch sloupc� posledn�ho na�ten�ho z�znamu pomoc�
<function>mysql_fetch_row</function>,
<function>mysql_fetch_array</function>, a
Index: phpdoc-cs/reference/mysql/functions/mysql-fetch-object.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-fetch-object.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-fetch-object.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-fetch-object.xml:1.2 Mon Jun 3
17:39:17 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-fetch-object.xml Sat Jun 8 11:48:22
+2002
@@ -14,12 +14,12 @@
<type>object</type><methodname>mysql_fetch_object</methodname>
<methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
- <methodparam choice="opt"><type>int</type><parameter>
+<!-- <methodparam choice="opt"><type>int</type><parameter>
result_type
- </parameter></methodparam>
+ </parameter></methodparam> -->
</methodsynopsis>
<para>
- Vr�t� objekt, jeho� prom�nn� obsahuj� hodnoty na�ten�ho z�znamu nebo
+ Vr�c� objekt, jeho� prom�nn� obsahuj� hodnoty na�ten�ho z�znamu nebo
&false; nen�-li ��dn� dal�� z�znam.</para>
<para>
<function>mysql_fetch_object</function> je obdobou
@@ -27,13 +27,28 @@
pole, je vr�cen objekt. Co� znamen�, �e k hodnot�m v�sledku lze
p�istupovat pouze p�es n�zvy sloupc� a nikoli p�es jejich ��seln� kl��e
(n�zev vlastnosti nem��e b�t ��slo). </para>
-<para>
+ <para>
+ <programlisting role="php">
+<![CDATA[
+<?php
+
+/* tohle je spr�vn� z�pis */
+echo $row->field;
+/* a toto je chybn� z�pis */
+echo $row->0;
+
+?>
+]]>
+ </programlisting>
+ </para>
+<!-- <para>
Nepovinn� parametr <parameter>result_type</parameter> je konstanta,
kter� m��e nab�vat n�sleduj�ch hodnot: MYSQL_ASSOC, MYSQL_NUM, a MYSQL_BOTH.
V�sv�tlen� t�chto konstant naleznete v <function>mysql_fetch_array</function>.
</para>
-<para>
+ -->
+<para>
Rychlostn� je tato funkce identick� s
<function>mysql_fetch_array</function>, a t�m�r tak rychl� jako
<function>mysql_fetch_row</function> (rozd�l je nev�znamn�).
@@ -42,9 +57,9 @@
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("hostname", "user", "password");
+mysql_connect("localhost", "mysql_uziv", "mysql_heslo");
mysql_select_db($db);
-$result = mysql_query("select * from tabulka");
+$result = mysql_query("select uziv_id, celejmeno from tabulka");
while ($row = mysql_fetch_object($result)) {
echo $row->uziv_id;
echo $row->celejmeno;
Index: phpdoc-cs/reference/mysql/functions/mysql-fetch-row.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-fetch-row.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-fetch-row.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-fetch-row.xml:1.2 Mon Jun 3 17:39:17
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-fetch-row.xml Sat Jun 8 11:48:22
+2002
@@ -29,7 +29,7 @@
Viz. tak�: <function>mysql_fetch_array</function>,
<function>mysql_fetch_object</function>,
<function>mysql_data_seek</function>,
- <function>mysql_fetch_lengths</function>, a
+ <function>mysql_fetch_lengths</function> a
<function>mysql_result</function>.
</para>
</refsect1>
Index: phpdoc-cs/reference/mysql/functions/mysql-field-len.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-field-len.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-field-len.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-field-len.xml:1.3 Thu May 30 18:24:53
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-field-len.xml Sat Jun 8 11:48:22
+2002
@@ -5,7 +5,7 @@
<refnamediv>
<refname>mysql_field_len</refname>
<refpurpose>
- Vr�t� d�lku sloupce tabulky
+ Vrac� d�lku sloupce tabulky
</refpurpose>
</refnamediv>
<refsect1>
@@ -18,7 +18,7 @@
<methodparam><type>int</type><parameter>��slo_sloupce</parameter></methodparam>
</methodsynopsis> <para>
- <function>mysql_field_len</function> Vrac� d�lku uveden�ho sloupce
+ <function>mysql_field_len</function> vrac� d�lku uveden�ho sloupce
v tabulce.
</para>
<para>
Index: phpdoc-cs/reference/mysql/functions/mysql-field-name.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-field-name.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-field-name.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-field-name.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-field-name.xml Sat Jun 8 11:48:22
+2002
@@ -27,7 +27,7 @@
<parameter>��slo_sloupce</parameter> za��n� nulou.
</para>
<para>
- nap�. po�ad� t�et�ho sloupce tabulky bude ��slo 2, �tvrt� sloupec v tabulce
+ Nap�. po�ad� t�et�ho sloupce tabulky bude ��slo 2, �tvrt� sloupec v tabulce
m� ��slo 3, atd.
</para>
</note>
Index: phpdoc-cs/reference/mysql/functions/mysql-field-table.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-field-table.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-field-table.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-field-table.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-field-table.xml Sat Jun 8 11:48:22
+2002
@@ -18,7 +18,7 @@
<methodparam><type>int</type><parameter>��slo_sloupce</parameter></methodparam>
</methodsynopsis>
<para>
- Vr�t� jm�no tabulky, kter� obsahuje uveden� sloupec.
+ Vr�c� jm�no tabulky, kter� obsahuje uveden� sloupec.
</para>
<para>
Z d�vod� zp�tn� kompatibility m��ete tak� narazit na funkci
Index: phpdoc-cs/reference/mysql/functions/mysql-field-type.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-field-type.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-field-type.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-field-type.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-field-type.xml Sat Jun 8 11:48:22
+2002
@@ -28,30 +28,40 @@
<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 "Tv� tabulka '".$table."' m� ".$fields." sloupc� a ".$rows." z�znam�
- <BR>";
-echo "Tabulka m� n�sleduj�c� sloupce: <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_connect("localhost", "mysql_uziv", "mysql_heslo");
+ mysql_select_db("mysql");
+ $result = mysql_query("SELECT jmeno, cislo, poznamka, typ FROM func");
+ $fields = mysql_num_fields($result);
+ $rows = mysql_num_rows($result);
+ $table = mysql_field_table($result, 0);
+ echo "Tv� tabulka '".$table."' m� ".$fields." sloupc� a ".$rows." z�znam(�)\n";
+ echo "Tabulka m� n�sleduj�c� sloupce:\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>
+ P�edchoz� p��klad by mohl m�t n�sleduj�c� v�stup:
+ </para>
+ <screen>
+<![CDATA[
+Tv� tabulka 'func' m� 4 sloupc� a 1 z�znam(�)
+Tabulka m� n�sleduj�c� sloupce:
+string jmeno 64 not_null primary_key binary
+int cislo 1 not_null
+string poznamka 128 not_null
+string typ 9 not_null enum
+]]>
+ </screen>
</example>
</para>
<para>
Index: phpdoc-cs/reference/mysql/functions/mysql-free-result.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-free-result.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-free-result.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-free-result.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-free-result.xml Sat Jun 8 11:48:22
+2002
@@ -11,15 +11,15 @@
<methodsynopsis>
<type>bool</type><methodname>mysql_free_result</methodname>
- <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
+ <methodparam><type>resource</type><parameter>vysledek</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_free_result</function> uvoln� pam�t obsazenou v�sledkem
- definovan�m identifik�torem spojen� <parameter>v�sledek</parameter>.
+ definovan�m identifik�torem spojen� <parameter>vysledek</parameter>.
</para>
<para>
<function>mysql_free_result</function> je vhodn� pou��vat pouze v p��pad�,
-�e v�m z�le�� na tom, jak moc pam�ti je v pr�b�hu skriptu pou��to pro vykonan�
+kdy v�m z�le�� na tom, jak moc pam�ti je v pr�b�hu skriptu pou��to pro vykonan�
dotaz a kdy� v�sledek dotazu je p��li� velk�. V�echna pam� obsazen� v�sledky
spojen� bude jinak automaticky ulovn�na a� s koncem b�hu skriptu.
<!-- TODO and as of PHP4 before, see freeing resources --> </para> <para>
Index: phpdoc-cs/reference/mysql/functions/mysql-get-client-info.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-get-client-info.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-get-client-info.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-get-client-info.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-get-client-info.xml Sat Jun 8
+11:48:22 2002
@@ -16,9 +16,31 @@
<function>mysql_get_client_info</function> vrac� �et�zec obsahuj�c� verzi
pou��van� klientsk� knihovny MySQL.
</para>
+ <example>
+ <title>mysql_get_client_info P��klad</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ printf ("MySQL klient info: %s\n", mysql_get_client_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ TP�edchoz� p��klad by mohl m�t n�sleduj�c� v�stup:
+ </para>
+ <screen>
+<![CDATA[
+MySQL klient info: 3.23.39
+]]>
+ </screen>
+ </example>
+
<para>
- <function>mysql_get_client_info</function> byla p�id�na v PHP 4.0.5.
+ D�le tak�: <function>mysql_get_host_info</function>,
+ <function>mysql_get_proto_info</function> z
+ <function>mysql_get_server_info</function>.
</para>
+
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-get-host-info.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-get-host-info.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-get-host-info.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-get-host-info.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-get-host-info.xml Sat Jun 8 11:48:22
+2002
@@ -4,7 +4,7 @@
<refentry id="function.mysql-get-host-info">
<refnamediv>
<refname>mysql_get_host_info</refname>
- <refpurpose>Na�te informaci o hostu v MySQL</refpurpose>
+ <refpurpose>Na�te informaci o hostu</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
@@ -16,13 +16,34 @@
<para>
<function>mysql_get_host_info</function> vrac� �et�zec popisuj�c�
pou�it� typ spojen� v <parameter>spojeni</parameter>, obsahuj�c� server
-host name. Pokud <parameter>spojeni</parameter> je vynech�no, pou�ije posledn�
+host name. Pokud je <parameter>spojeni</parameter> vynech�no, pou�ije posledn�
otev�en� spojen�.
</para>
+ <example>
+ <title>mysql_get_host_info P��klad</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_uziv", "mysql_heslod") or
+ die("Nelze se spojit");
+ printf ("MySQL host info: %s\n", mysql_get_host_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ P�edchoz� p��klad by mohl m�t n�sleduj�c� v�stup:
+ </para>
+ <screen>
+<![CDATA[
+MySQL host info: Localhost via UNIX socket
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_host_info</function> byla p�id�na v PHP 4.0.5.
- </para>
- </refsect1>
+ D�le tak�: <function>mysql_get_client_info</function>,
+ <function>mysql_get_proto_info</function> and
+ <function>mysql_get_server_info</function>.
+ </para> </refsect1>
</refentry>
<!-- Keep this comment at the end of the file
Index: phpdoc-cs/reference/mysql/functions/mysql-get-proto-info.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-get-proto-info.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-get-proto-info.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-get-proto-info.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-get-proto-info.xml Sat Jun 8
+11:48:22 2002
@@ -20,8 +20,30 @@
spojen�.
</para>
+ <example>
+ <title>mysql_get_proto_info P��klad</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_uziv", "mysql_heslo") or
+ die("Nelze se spojit");
+ printf ("Verze protokolu MySQL: %s\n", mysql_get_proto_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ P�edchoz� p��klad by mohl m�t n�sleduj�c� v�stup:
+ </para>
+ <screen>
+<![CDATA[
+Verze protokolu MySQL : 10
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_proto_info</function> byla p�id�na v PHP 4.0.5.
+ D�le tak�: <function>mysql_get_client_info</function>,
+ <function>mysql_get_host_info</function> a
+ <function>mysql_get_server_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-get-server-info.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-get-server-info.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-get-server-info.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-get-server-info.xml:1.3 Thu May 30
18:24:53 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-get-server-info.xml Sat Jun 8
+11:48:22 2002
@@ -19,9 +19,32 @@
<parameter>spojeni</parameter> vynech�no, pou�ije se posledn� otev�en�
spojen�.
</para>
+ <example>
+ <title>mysql_get_server_info P��klad</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_uziv", "mysql_heslo") or
+ die("Nelze se spojit");
+ printf ("Verze MySQL serveru: %s\n", mysql_get_server_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ P�edchoz� p��klad by mohl m�t n�sleduj�c� v�stup:
+ </para>
+ <screen>
+<![CDATA[
+Verze MySQL serveru: 4.0.1-alpha
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_server_info</function> byla p�id�na PHP 4.0.5.
+ D�le tak�: <function>mysql_get_client_info</function>,
+ <function>mysql_get_host_info</function> a
+ <function>mysql_get_proto_info</function>.
</para>
+
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml:1.3 Wed May 29 18:14:32
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml Sat Jun 8 11:48:22
+2002
@@ -5,7 +5,7 @@
<refnamediv>
<refname>mysql_insert_id</refname>
<refpurpose>
- Vr�t� hodnotu id posledn�ho p��kazu INSERT
+ Vrac� generovanou hodnotu id posledn�ho p��kazu INSERT
</refpurpose>
</refnamediv>
<refsect1>
@@ -45,7 +45,27 @@
BIGINT, hodnota vr�cen� <function>mysql_insert_id</function>
bude nespr�vn� (pouze v p��pad�, �e i samotn� hodnota bude m�t velikost BIGINT).
M�sto toho pou�ijte vnit�n� MySQL SQL funkci <literal>LAST_INSERT_ID()</literal>
-p��mo v SQL dotazu. </para> </warning>
+p��mo v SQL dotazu. </para>
+ </warning>
+ <example>
+ <title>mysql_insert_id P��klad</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect("localhost", "mysql_uziv", "mysql_heslo") or
+ die("Nelze se spojit");
+ mysql_select_db("mojedb");
+
+ mysql_query("INSERT INTO mojetabulka (produkt) values ('kosa')");
+ printf ("Posledn� vlo�en� z�znam m� id: %d\n", mysql_insert_id());
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ D�le tak�: <function>mysql_query</function>.
+ </para>
+
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml:1.2 Wed May 29
18:14:32 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml Sat Jun 8 11:48:22
+2002
@@ -36,12 +36,13 @@
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
- echo mysql_field_name($fields, $i) . "\n";;
+ echo mysql_field_name($fields, $i) . "\n";
}
+?>
]]>
</programlisting>
<para>
- P�edchoz� p��klad by m�l n�sleduj�c� v�stup:
+ P�edchoz� p��klad by mohl m�t n�sleduj�c� v�stup:
<screen>
<![CDATA[
sloupec1
Index: phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml:1.2 Wed May 29
18:14:32 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml Sat Jun 8 11:48:22
+2002
@@ -19,14 +19,51 @@
<para>
<function>mysql_list_tables</function> Na z�klad� jm�na datab�ze vrac�
ukazatel v�sledku na tabulky p�esn� tak jako
- <function>mysql_db_query</function>. M��ete nap�. pou��t�m
- funkce <function>mysql_tablename</function> zjistit jm�na v�ech tabulek
+ <function>mysql_db_query</function>. Pou��t�m funkce
+<function>mysql_tablename</function> m��ete zjistit jm�na v�ech tabulek
z ukazatele v�sledku nebo pou��t jin� funkce k zji�t�n� dal��ch
- informc� o tabulk�ch.
+ informac� jako nap�. <function>mysql_fetch_assoc</function>.
+ <para>
+ Parametr <parameter>database</parameter> je n�zev datab�ze,
+ z kter� se maj� ��st jm�na tabulky. Dojde-li k chyb�,
+ <function>mysql_list_tables</function> vrac� &false;.
+ </para>
</para>
<para> Z d�vod� zp�tn� kompatibility m��ete tak� narazit na funkci
<function>mysql_listtables</function>. Tuto funkci v�ak nedoporu�ujeme
pou��vat, nebo� nemus� b�t ji� v dal��ch verz�ch PHP podporov�na.
+ </para>
+ <example>
+ <title>mysql_list_tables P��klad</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ $dbname = 'mysql_dbjmeno';
+
+ if (!mysql_connect('mysql_host', 'mysql_uziv', 'mysql_heslo')) {
+ print 'Nelze se spojit';
+ exit;
+ }
+
+ $result = mysql_list_tables($dbname);
+
+ if (!$result) {
+ print "Chyba DB, nelze ��st tabulky\n";
+ print 'MySQL chyba: ' . mysql_error();
+ exit;
+ }
+
+ while ($row = mysql_fetch_row($result)) {
+ print "Tabulka: $row[0]\n";
+ }
+
+ mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ D�le tak�: <function>mysql_list_dbs</function>,
+ a <function>mysql_tablename</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml:1.2 Wed May 29
18:14:32 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml Sat Jun 8 11:48:22
+2002
@@ -4,7 +4,7 @@
<refentry id="function.mysql-num-fields">
<refnamediv>
<refname>mysql_num_fields</refname>
- <refpurpose>Vr�t� po�et sloupc� ve v�sledku</refpurpose>
+ <refpurpose>Vrac� po�et sloupc� ve v�sledku</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
Index: phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml:1.2 Wed May 29 18:14:32
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml Sat Jun 8 11:48:22
+2002
@@ -4,7 +4,7 @@
<refentry id="function.mysql-num-rows">
<refnamediv>
<refname>mysql_num_rows</refname>
- <refpurpose>Vr�t� po�et z�znam� ve v�sledku</refpurpose>
+ <refpurpose>Vrac� po�et z�znam� ve v�sledku</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
@@ -24,27 +24,34 @@
<![CDATA[
<?php
-$link = mysql_connect("localhost", "mojejmeno", "heslo");
+$link = mysql_connect("localhost", "mysql_uziv", "mysql_heslo");
mysql_select_db("databaze", $link);
$result = mysql_query("SELECT * FROM tabulka1", $link);
$num_rows = mysql_num_rows($result);
-echo "$num_rows ��dk�\n";
+echo "��dk�: $num_rows\n";
?>
]]>
</programlisting>
</example>
</para>
+ <note>
+ <para>
+ Pou��v�te-li <function>mysql_unbuffered_query</function>,
+ <function>mysql_num_rows</function> nebude vracet spr�vnou hodnotu dokud
+nebudou p�ijaty v�echny z�znamy ve v�sledku.
+ </para>
+ </note>
<para>
- Viz. tak�:
+ D�le tak�:
<function>mysql_affected_rows</function>,
<function>mysql_connect</function>,
- <function>mysql_select_db</function>, a
+ <function>mysql_data_seek</function>,
+ <function>mysql_select_db</function> a
<function>mysql_query</function>.
- </para>
- <para>
+ </para>
+ <para>
Z d�vod� zp�tn� kompatibility m��ete tak� narazit na funkci
<function>mysql_numrows</function>. Tuto funkci v�ak nedoporu�ujeme pou��vat,
nebo� nemus� b�t ji� v dal��ch verz�ch PHP podporov�na. </para>
Index: phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml:1.2 Wed May 29 18:14:32
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml Sat Jun 8 11:48:22
+2002
@@ -62,15 +62,9 @@
</para> <para>
Proto je tento typ spojen� naz�v�n jako 'persistentn�' - trval�.
</para>
- <para>
-If you need to close idle persistent connections, set a low wait_timeout in
-MySQL
- Pot�ebujete-li uzav�rat persistentn� spojen� d��ve, nastavte ni���
-hodnotu prom�nn� <parameter>wait_timeout</parameter> v MySQL.
-</para>
<note>
<para>
- Persistentn� spojen� je podporov�no pouze v p��pad�, kdy je PHP spu�t�no
+ Persistentn� spojen� funguje pouze v p��pad�, kdy je PHP spu�t�no
jako modul (nikoli CGI). V�ce o t�to problematice naleznete v sekci
<link linkend="features.persistent-connections">Persistentn�
datab�zov� spojen�</link>.
Index: phpdoc-cs/reference/mysql/functions/mysql-query.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-query.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-query.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-query.xml:1.3 Thu May 30 18:24:53
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-query.xml Sat Jun 8 11:48:22 2002
@@ -38,8 +38,8 @@
N�sleduj�c� dotaz je syntakticky nespr�vn�, tak�e jeho vykon�v�n� v
<function>mysql_query</function> sel�e a vr�t� &false;:
<example>
-<title><function>mysql_query</function></title> <programlisting
-role="php"> <![CDATA[
+<title><function>mysql_query</function></title> <programlisting role="php">
+<![CDATA[
<php
$result = mysql_query("SELECT * WHERE 1=1")
or die("�patn� dotaz!");
Index: phpdoc-cs/reference/mysql/functions/mysql-result.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-result.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-result.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-result.xml:1.2 Thu May 30 18:24:53
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-result.xml Sat Jun 8 11:48:22
+2002
@@ -37,7 +37,7 @@
s vol�n�m jin�ch funkc�, proto�e by do�lo k d�len� z�znam� z v�sledku.
</para>
<para>
- Doporu�en� vysoce v�konn� alternativy::
+ Doporu�en� mnohem v�kon�j�� alternativy:
<function>mysql_fetch_row</function>,
<function>mysql_fetch_array</function> a
<function>mysql_fetch_object</function>.
Index: phpdoc-cs/reference/mysql/functions/mysql-select-db.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-select-db.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-select-db.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-select-db.xml:1.2 Thu May 30 18:24:53
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-select-db.xml Sat Jun 8 11:48:22
+2002
@@ -26,12 +26,11 @@
<function>mysql_connect</function> bez parametr�.
</para>
<para>
- Every subsequent call to <function>mysql_query</function> will be
- made on the active database.
+ Ka�d� dal�� vol�n� <function>mysql_query</function> bude vytvo�eno u� na platnou
+datab�zi.
</para>
<para> Viz. tak�:
<function>mysql_connect</function>,
- <function>mysql_pconnect</function>, and
+ <function>mysql_pconnect</function> a
<function>mysql_query</function>.
</para>
<para>
Index: phpdoc-cs/reference/mysql/functions/mysql-stat.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-stat.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-stat.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-stat.xml:1.2 Fri Jun 7 15:50:11
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-stat.xml Sat Jun 8 11:48:22 2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- $Revision: 1.2 $ -->
+<!-- $Revision: 1.3 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.62 -->
<refentry id="function.mysql-stat">
<refnamediv>
@@ -18,7 +18,7 @@
<note>
<para>
<function>mysql_stat</function> vrac� hodnoty stav� pouze pro �as od startu
MySQL serveru,
- vl�kna, pomal� dotazy, otev�en� tabulky, flush tabulky and dotazy za sekundu.
pro
+ vl�kna, pomal� dotazy, otev�en� tabulky, flush tabulky a dotazy za sekundu. Pro
kompletn� v�pis stav� dal��ch prom�nn�ch mus�te pou��t sql dotaz SHOW STATUS.
</para>
</note>
@@ -28,7 +28,7 @@
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect('localhost', "mysql_user", "mysql_password");
+$link = mysql_connect('localhost', "mysql_uziv", "mysql_heslo");
printf("%s\n", mysql_stat($link));
?>
]]>
Index: phpdoc-cs/reference/mysql/functions/mysql-tablename.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-tablename.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-tablename.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-tablename.xml:1.2 Thu May 30 18:24:53
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-tablename.xml Sat Jun 8 11:48:22
+2002
@@ -24,16 +24,20 @@
<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_uziv", "mysql_heslo");
+ $result = mysql_list_tables("mojedb");
+
+ for ($i = 0; $i < mysql_num_rows($result); $i++)
+ printf ("Tabulka: %s\n", mysql_tablename($result, $i));
+
+ mysql_free_result($result);
?>
]]>
</programlisting>
</example>
+ </para>
+ <para>
+ D�le tak�: <function>mysql_list_tables</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml:1.3
phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml:1.4
--- phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml:1.3 Wed Jun 5
16:42:03 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-unbuffered-query.xml Sat Jun 8
+11:48:22 2002
@@ -29,7 +29,7 @@
</para>
<note>
<para>
- V�hoda <function>mysql_unbuffered_query</function> n�co stoj�: Nem��ete
+ ka�d� v�hoda <function>mysql_unbuffered_query</function> n�co stoj�: Nem��ete
pou��vat funkci <function>mysql_num_rows</function> k zji�t�n� po�tu
z�znam� vr�cen�ch pomoc� <function>mysql_unbuffered_query</function>. D�le tak�
mus�te na��st v�echny z�znamy vracen� nebufferovan�m dotazem p�edt�m, ne�
