costra Thu Mar 28 18:06:30 2002 EDT
Modified files:
/phpdoc/cs/functions mysql.xml
Log:
Next translation to Czech (to Luk: I hope xml is formed well)
Index: phpdoc/cs/functions/mysql.xml
diff -u phpdoc/cs/functions/mysql.xml:1.4 phpdoc/cs/functions/mysql.xml:1.5
--- phpdoc/cs/functions/mysql.xml:1.4 Thu Mar 7 18:39:25 2002
+++ phpdoc/cs/functions/mysql.xml Thu Mar 28 18:06:30 2002
@@ -601,10 +601,10 @@
</para>
<para>
- Errors coming back from the MySQL database backend no longer
- issue (vydat, uve�ejnit) warnings. Instead, use
- <function>mysql_errno</function> to retrieve the error code.
-
+ Chyby vr�cen� MySQL ji� nezp�sobuj� upozor�uj�c� chybov� hl�en� (warning).
+ Pot�ebujete-li zjistit ��seln� k�d chyby, pou�ijte
+ <function>mysql_errno</function>,
+ p��padn� <function>mysql_error</function> k zji�t�n� textu chyby.
Pamatujte, �e tato funkce vrac� chybov� k�d pouze naposledy vykonan�
MySQL funkce (net�k� se <function>mysql_error</function> a
<function>mysql_errno</function>), pokud ji tedy budete pou��vat,
@@ -651,22 +651,22 @@
nenastala.
</para>
<para>
- Errors coming back from the MySQL database backend no longer
- issue warnings. Instead, use <function>mysql_error</function> to
- retrieve the error text. Note that this function only returns the
- error text from the most recently executed MySQL function (not
- including <function>mysql_error</function> and
- <function>mysql_errno</function>), so if you want to use it, make
- sure you check the value before calling another MySQL function.
+ Chyby vr�cen� MySQL ji� nezp�sobuj� upozor�uj�c� chybov� hl�en� (warning).
+ Pot�ebujete-li zjistit text chyby, pou�ijte
+ <function>mysql_error</function>, p��padn� <function>mysql_errno</function>
+ k zji�t�n� ��slen�ho k�du chyby. Pamatujte, �e tato funkce vrac� chybov�
+ k�d pouze naposledy vykonan� MySQL funkce (net�k� se
+ <function>mysql_error</function> a <function>mysql_errno</function>),
+ pokud ji tedy budete pou��vat, mus�te kontrolovat hodnotu je�t� p�ed
+ vol�n�m dal�� MySQL funkce.
<informalexample>
- <programlisting role="php">
-<![CDATA[
-<?php
+ <programlisting role="php">
+<![CDATA[ <?php
mysql_connect("marliesle");
echo mysql_errno().": ".mysql_error()."<BR>";
-mysql_select_db("nonexistentdb");
+mysql_select_db("neexistujicidb");
echo mysql_errno().": ".mysql_error()."<BR>";
-$conn = mysql_query("SELECT * FROM nonexistenttable");
+$conn = mysql_query("SELECT * FROM neexistujicitab");
echo mysql_errno().": ".mysql_error()."<BR>";
?>
]]>
@@ -683,24 +683,27 @@
<refnamediv>
<refname>mysql_escape_string</refname>
<refpurpose>
- Escapes a string for use in a mysql_query.
+ Uprav� �et�zec pro pou�it� v mysql_query.
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_escape_string</methodname>
-
- <methodparam><type>string</type><parameter>unescaped_string</parameter></methodparam>
- </methodsynopsis>
+
+
+<methodparam><type>string</type><parameter>neupraveny_retezec</parameter></methodparam>
+</methodsynopsis>
<para>
- This function will escape the <parameter>unescaped_string</parameter>,
- so that it is safe to place it in a <function>mysql_query</function>.
- </para>
- <note>
+ Tato funkce uprav� <parameter>neupraveny_retezec</parameter> pro snadn�
+ pou�it� v <function>mysql_query</function>. P�ed funk�n� znaky jako
+<literal>"</literal> (uvozovky) �i <literal>'</literal> (apostrofy) jsou
+dopln�na zp�tn� lom�tka, konce ��dk� jsou nahrazeny zna�kou \n.
+ </para>
+ <note>
<simpara>
- <function>mysql_escape_string</function> does not escape
- <literal>%</literal> and <literal>_</literal>.
+ <function>mysql_escape_string</function> nep�id�v� zp�tn� lom�tka p�ed
+znaky <literal>%</literal> a <literal>_</literal>.
</simpara>
</note>
</refsect1>
@@ -717,74 +720,72 @@
<title>Popis</title>
<methodsynopsis>
<type>array</type><methodname>mysql_fetch_array</methodname>
-
+
<methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
<methodparam choice="opt"><type>int</type><parameter>
result_type
</parameter></methodparam>
</methodsynopsis>
<para>
- Returns an array that corresponds to the fetched row, or &false;
- if there are no more rows.</para>
- <para>
- <function>mysql_fetch_array</function> is an extended version of
- <function>mysql_fetch_row</function>. In addition to storing the
- data in the numeric indices of the result array, it also stores
- the data in associative indices, using the field names as keys.
+ Funkce vrac� pole hodnot na�ten�ho ��dku nebo &false;, nen�-li ��dn�
+dal�� ��dek.
</para>
<para>
- If two or more columns of the result have the same field names,
- the last column will take precedence. To access the other column(s)
- of the same name, you must use the numeric index of the column or
- make an alias for the column. For aliased columns, you cannot
- access the contents with the original column name (by using
- <literal>'field'</literal> in this example).
+ <function>mysql_fetch_array</function> je roz���enou verz�
+ <function>mysql_fetch_row</function>. Nav�c zde jsou data ulo�ena v
+poli nejen pod ��seln�mi kl��i, ale tak� pod asociativn�mi textov�mi kl��i
+jmenuj�c�mi se podle n�zvu sloupce sql tabulky.
+ </para>
+ <para>
+ Pokud dva nebo v�ce sloupc� maj� stejn� n�zev, bude dostupn� hodnota
+ pouze toho posledn�ho. Chcete-li p�istupovat i k hodnot�m ostatn�ch
+sloupc�, mus�te k nim v sql dotazu vytvo�it aliasy. N�zev kl��e sloupce, k n�mu�
+je vytvo�em alias, je v�dy jm�no aliasu a proto nen� mo�n� pou��t origin�ln�
+jm�no sloupce v sql tabulce (viz. <literal>'sloupec'</literal> v n�sleduj�c�m
+p��kladu).
<informalexample>
<programlisting role="sql">
<![CDATA[
-select tone.field as foo ttwo.field as bar from tone, ttwo
-]]>
+select prvni_tab.sloupec as prvni_sloupec druha_tab.sloupec as druhy_sloupec
+from prvni_tab, druha_tab ]]>
</programlisting>
</informalexample>
</para>
<para>
- An important thing to note is that using
- <function>mysql_fetch_array</function> is <emphasis>not
- significantly</emphasis> slower than using
- <function>mysql_fetch_row</function>, while it provides
- a significant added value.
- </para>
- <para>
- The optional second argument <parameter>result_type</parameter>
- in <function>mysql_fetch_array</function> is a constant and can
- take the following values: MYSQL_ASSOC, MYSQL_NUM, and
- MYSQL_BOTH. This feature was added in PHP 3.0.7. MYSQL_BOTH
- is the default for this argument.
- </para>
- <para>
- By using MYSQL_BOTH, you'll get an array with both associative
- and number indices. Using MYSQL_ASSOC, you only get associative
- indices (as <function>mysql_fetch_assoc</function> works),
- using MYSQL_NUM, you only get number indices (as
- <function>mysql_fetch_row</function> works).
- </para>
- <para>
- For further details, see also
- <function>mysql_fetch_row</function> and
+ D�le�it� ov�em je, �e pou�it�
+ <function>mysql_fetch_array</function> <emphasis>nen�
+ nijak v�znamn�</emphasis> pomalej�� ne� pou�it�
+ <function>mysql_fetch_row</function>, pokud je jej� pou�it� p�idanou
+hodnotou.
+ </para>
+ <para>
+ Nepovinn� druh� parametr <parameter>result_type</parameter>
+ v <function>mysql_fetch_array</function> je komstanta, kter� m��e nab�vat
+n�sleduj�c�ch hodnot: MYSQL_ASSOC, MYSQL_NUM, a MYSQL_BOTH. Tato vlastnost
+byla p�id�na v PHP 3.0.7. V�choz� hodnota je MYSQL_BOTH.</para>
+ <para>
+ Pou�it�m MYSQL_BOTH z�sk�te pole s asociativn�mi i ��seln�mi kl��i.
+Pou�it�m MYSQL_ASSOC z�sk�te pole pouze s asociativn�mi kl��i (stejn� funguje
+<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><function>mysql_fetch_array</function> example</title>
+ <title><function>mysql_fetch_array</function> p��klad</title>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect($host, $user, $password);
-mysql_select_db("database");
-$result = mysql_query("select user_id, fullname from table");
+mysql_select_db("databaze");
+$result = mysql_query("select uziv_id, celejmeno from tabulka");
while ($row = mysql_fetch_array($result)) {
- echo "user_id: ".$row["user_id"]."<br>\n";
+ echo "user_id: ".$row["uziv_id"]."<br>\n";
echo "user_id: ".$row[0]."<br>\n";
- echo "fullname: ".$row["fullname"]."<br>\n";
+ echo "fullname: ".$row["celejmeno"]."<br>\n";
echo "fullname: ".$row[1]."<br>\n";
}
mysql_free_result($result);
@@ -806,38 +807,37 @@
<title>Popis</title>
<methodsynopsis>
<type>array</type><methodname>mysql_fetch_assoc</methodname>
- <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
+
+ <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
</methodsynopsis>
<para>
- Returns an associative array that corresponds to the fetched row,
- or &false; if there are no more rows.</para>
- <para>
- <function>mysql_fetch_assoc</function> is equivalent to calling
- <function>mysql_fetch_array</function> with MYSQL_ASSOC for the
- optional second parameter. It only returns an associative array.
- This is the way <function>mysql_fetch_array</function> originally
- worked. If you need the numeric indices as well as the
- associative, use <function>mysql_fetch_array</function>.
+ Funkce vrac� asociativn� pole hodnot na�ten�ho ��dku nebo &false;, nen�-li
+��dn� dal�� ��dek.
</para>
<para>
- If two or more columns of the result have the same field names,
- the last column will take precedence. To access the other
- column(s) of the same name, you either need to access the
- result with numeric indices by using
- <function>mysql_fetch_row</function> or add alias names.
- See the example at the <function>mysql_fetch_array</function>
- description about aliases.
+ <function>mysql_fetch_assoc</function> je akvalentem k
+ <function>mysql_fetch_array</function> s nepovinn�m druh�m parametrem
+MYSQL_ASSOC, co� vrac� pouze asociativn� pole. Pokud pot�ebujete pou��vat
+��seln� indexy spolu s asociativn�mi, pou�ijte <function>mysql_fetch_array</function>.
+</para>
+<para>
+ Pokud dva nebo v�ce sloupc� maj� stejn� n�zev, bude dostupn� hodnota
+ pouze toho posledn�ho. Chcete-li p�istupovat i k hodnot�m ostatn�ch
+sloupc�, mus�te k nim v sql dotazu vytvo�it aliasy. N�zev kl��e sloupce, k n�mu�
+je vytvo�em alias, je v�dy jm�no aliasu a proto nen� mo�n� pou��t origin�ln�
+jm�no sloupce v sql tabulce. Pod�vejte se na vysv�tlen� pou�it� alias� v
+p��kladu u <function>mysql_fetch_array</function>.
+ </para>
+ <para>
+ D�le�it� ov�em je, �e pou�it�
+ <function>mysql_fetch_assoc</function> <emphasis>nen�
+ nijak v�znamn�</emphasis> pomalej�� ne� pou�it�
+ <function>mysql_fetch_row</function>, pokud je jej� pou�it� p�idanou
+hodnotou.
</para>
<para>
- An important thing to note is that using
- <function>mysql_fetch_assoc</function> is <emphasis>not
- significantly</emphasis> slower than using
- <function>mysql_fetch_row</function>, while it
- provides a significant added value.
- </para>
- <para>
- For further details, see also
- <function>mysql_fetch_row</function> and
+ Pro dal�� detaily viz. tak�
+ <function>mysql_fetch_row</function> a
<function>mysql_fetch_array</function>.
</para>
<example>
@@ -846,12 +846,12 @@
<![CDATA[
<?php
mysql_connect($host, $user, $password);
-mysql_select_db($database);
-$query = "select * from table";
+mysql_select_db($databaze);
+$query = "select * from tabulka";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
- echo $row["user_id"];
- echo $row["fullname"];
+ echo $row["uziv_id"];
+ echo $row["celejmeno"];
}
mysql_free_result($result);
?>
@@ -872,81 +872,81 @@
<title>Popis</title>
<methodsynopsis>
<type>object</type><methodname>mysql_fetch_field</methodname>
- <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
+
+ <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
<methodparam choice="opt"><type>int</type><parameter>
field_offset
</parameter></methodparam>
</methodsynopsis>
<para>
- Returns an object containing field information.
- </para>
- <para>
- <function>mysql_fetch_field</function> can be used in order to
- obtain information about fields in a certain query result. If
- the field offset isn't specified, the next field that wasn't yet
- retrieved by <function>mysql_fetch_field</function> is retrieved.
+ Vr�t� objekt obsahuj�c� informace o sloupci z v�sledku.
</para>
<para>
- The properties of the object are:
+ <function>mysql_fetch_field</function> m�e�e pou��t v p��pad�, �e
+pot�ebujete z�skat informace o sloupci z ur�it�ho v�sledku. Nen�-li
+specifikov�n n�zev sloupce, funkce na�te informace o prvn�m n�sleduj�c�m je�t�
+nena�ten�m sloupci.</para>
+ <para>
+ Vlastnosti objektu jsou:
<itemizedlist>
<listitem>
<simpara>
- name - column name
+ name - n�zev sloupce
</simpara>
</listitem>
<listitem>
<simpara>
- table - name of the table the column belongs to
+ table - n�zev tabulky, v n�� se tento sloupec nach�z�
</simpara>
</listitem>
<listitem>
<simpara>
- max_length - maximum length of the column
+ max_length - maxim�ln� d�lka sloupce ve znac�ch
</simpara>
</listitem>
<listitem>
<simpara>
- not_null - 1 if the column cannot be &null;
+ not_null - 1 pokud sloupec nem��e b�t &null;
</simpara>
</listitem>
<listitem>
<simpara>
- primary_key - 1 if the column is a primary key
+ primary_key - 1 pokud je sloupec prim�rn� kl��
</simpara>
</listitem>
<listitem>
<simpara>
- unique_key - 1 if the column is a unique key
+ unique_key - 1 pokud je sloupec unik�tn� kl��
</simpara>
</listitem>
<listitem>
<simpara>
- multiple_key - 1 if the column is a non-unique key
+ multiple_key - 1 pokud je sloupec neunik�tn� kl��
</simpara>
</listitem>
<listitem>
<simpara>
- numeric - 1 if the column is numeric
+ numeric - 1 pokud je sloupec ��slo
</simpara>
</listitem>
<listitem>
<simpara>
- blob - 1 if the column is a BLOB
+ blob - 1 pokud je sloupec BLOB
</simpara>
</listitem>
<listitem>
<simpara>
- type - the type of the column
+ type - typ sloupce
</simpara>
</listitem>
<listitem>
<simpara>
- unsigned - 1 if the column is unsigned
+ unsigned - 1 pokud je sloupec bez znam�nka
</simpara>
</listitem>
<listitem>
<simpara>
- zerofill - 1 if the column is zero-filled
+ zerofill - 1 pokud je sloupec dolpn�n nulami na svou velikost
</simpara>
</listitem>
</itemizedlist>
@@ -958,16 +958,16 @@
<?php
mysql_connect('localhost:3306', $user, $password)
or die ("Nelze se p�ipojit");
-mysql_select_db("database");
-$result = mysql_query("select * from table")
+mysql_select_db("databaze");
+$result = mysql_query("select * from tabulka")
or die("Chyba dotazu");
-# get column metadata
+# vr�t� informace o sloupci
$i = 0;
while ($i < mysql_num_fields($result)) {
- echo "Information for column $i:<BR>\n";
+ echo "Informace pro sloupec $i:<BR>\n";
$meta = mysql_fetch_field($result);
if (!$meta) {
- echo "No information available<BR>\n";
+ echo "Nejsou dostupn� ��dn� informace<BR>\n";
}
echo "<PRE>
blob: $meta->blob
@@ -1007,20 +1007,19 @@
<title>Popis</title>
<methodsynopsis>
<type>array</type><methodname>mysql_fetch_lengths</methodname>
- <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
+
+ <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
</methodsynopsis>
<para>
- Returns an array that corresponds to the lengths of each field
- in the last row fetched by <function>mysql_fetch_row</function>,
- or &false; on error.
+ Vr�t� 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> stores the lengths of
- each result column in the last row returned by
- <function>mysql_fetch_row</function>,
- <function>mysql_fetch_array</function>, and
- <function>mysql_fetch_object</function> in an array, starting at
- offset 0.
+ <function>mysql_fetch_lengths</function> obahuje 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
+<function>mysql_fetch_object</function> v poli, za��naj�c�ho kl��em 0.
</para>
<para>
Viz. tak�: <function>mysql_fetch_row</function>.
@@ -1039,45 +1038,42 @@
<title>Popis</title>
<methodsynopsis>
<type>object</type><methodname>mysql_fetch_object</methodname>
- <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
+
+ <methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
<methodparam choice="opt"><type>int</type><parameter>
result_type
</parameter></methodparam>
</methodsynopsis>
<para>
- Returns an object with properties that correspond to the fetched
- row, or &false; if there are no more rows.
- </para>
- <para>
- <function>mysql_fetch_object</function> is similar to
- <function>mysql_fetch_array</function>, with one difference - an
- object is returned, instead of an array. Indirectly, that means
- that you can only access the data by the field names, and not by
- their offsets (numbers are illegal property names).
- </para>
- <para>
- The optional argument <parameter>result_type</parameter> is a
- constant and can take the following values: MYSQL_ASSOC,
- MYSQL_NUM, and MYSQL_BOTH. See
- <function>mysql_fetch_array</function> for explanation
- of these constants.
- </para>
+ Vr�t� objekt, jeho� prom�nn� obsahuj� hodnoty na�ten�ho z�znamu nebo
+&false; nen�-li ��dn� dal�� z�znam.</para>
<para>
- Speed-wise, the function is identical to
- <function>mysql_fetch_array</function>, and almost as quick as
- <function>mysql_fetch_row</function> (the difference is
- insignificant).
+ <function>mysql_fetch_object</function> je obdobou
+ <function>mysql_fetch_array</function>, s jedn�m rozd�lem - narozd�l od
+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>
+ 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>
+
+ 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�).
<example>
- <title><function>mysql_fetch_object</function> example</title>
+ <title><function>mysql_fetch_object</function> p��klad</title>
<programlisting role="php">
<