costra Wed May 29 18:14:32 2002 EDT
Modified files:
/phpdoc-cs/reference/mysql/functions 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
Log:
Milk and butter.
Index: phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml:1.2
phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml:1.3
--- phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml:1.2 Tue May 28 18:24:04
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-insert-id.xml Wed May 29 18:14:32
+2002
@@ -27,15 +27,14 @@
<function>mysql_insert_id</function> vrac� 0 pokud pro p�edchoz� dotaz
nebyla vygenerov�na ��dn� hodnota pomoc� AUTO_INCREMENT. I v p��pad�,
�e pot�ebujete hodnotu pou��t pozd�ji, dbejte na to, abyste funkci
-<function>mysql_insert_id</function> okam�it� po dotazu, pro n�j� byla
+<function>mysql_insert_id</function> volali okam�it� po dotazu, pro n�j� byla
vygenerov�na hodnota pomoc� AUTO_INCREMENT.
</para>
<note>
<para>
- Hodnota MySQL SQL funkce
- <literal>LAST_INSERT_ID()</literal> v�dy obsahuje nejvy��� posledn�
-vygenerovanou hodnotu AUTO_INCREMENT a nen� mezi dal��mi dotazy
-vynulov�na.
+ Hodnota MySQL SQL funkce <literal>LAST_INSERT_ID()</literal> v�dy obsahuje
+nejvy��� posledn� vygenerovanou hodnotu AUTO_INCREMENT a nen� mezi dal��mi
+dotazy vynulov�na.
</para>
</note>
<warning>
@@ -44,9 +43,9 @@
API funkc� <literal>mysql_insert_id()</literal> z typu <literal>long</literal>
(ekvivalent v PHP <type>int</type>). Pokud je sloupec AUTO_INCREMENT typu
BIGINT, hodnota vr�cen� <function>mysql_insert_id</function>
-bude nespr�vn�. M�sto toho pou�ijte vnit�n� MySQL SQL funkci
-<literal>LAST_INSERT_ID()</literal> p��mo v SQL dotazu. </para>
- </warning>
+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>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-list-dbs.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-list-dbs.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-list-dbs.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-list-dbs.xml:1.1 Sun Apr 14 19:47:09
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-list-dbs.xml Wed May 29 18:14:32
+2002
@@ -5,7 +5,7 @@
<refnamediv>
<refname>mysql_list_dbs</refname>
<refpurpose>
- Na�te v�echny datab�ze dostupn� na MySQL serveru
+ Na�te v�echny dostupn� datab�ze na MySQL serveru
</refpurpose>
</refnamediv>
<refsect1>
@@ -17,18 +17,19 @@
</parameter></methodparam>
</methodsynopsis>
<para>
- <function>mysql_list_dbs</function> will return a result pointer
- containing the databases available from the current mysql
- daemon. Use the <function>mysql_tablename</function> function to
- traverse this result pointer, or any function for result tables.
- </para>
+ <function>mysql_list_dbs</function> vrac� ukazatel v�sledku obsahuj�c�
+ datab�ze dostupn� na aktu�ln�m mysql d�monovi. Lze pou��t
+ nap��klad spole�n� s funkc� <function>mysql_tablename</function>
+ k z�sk�n� n�zv� tabulek, p��padn� jin�ch funkc�ch k z�sk�n� dal��ch
+ informac� o tabulk�ch.
+ </para>
<para>
<example>
- <title><function>mysql_list_dbs</function> example</title>
+ <title><function>mysql_list_dbs</function> p��klad</title>
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect('localhost', 'myname', 'secret');
+$link = mysql_connect('localhost', 'mojejmeno', 'tajne');
$db_list = mysql_list_dbs($link);
while ($row = mysql_fetch_object($db_list)) {
@@ -38,12 +39,12 @@
]]>
</programlisting>
<para>
- The above example would produce the following output:
+ P�edchoz� p��klad by m�l n�sleduj�c� v�stup:
<screen>
<![CDATA[
-database1
-database2
-database3
+databaze1
+databaze2
+databaze3
...
]]>
</screen>
@@ -52,13 +53,13 @@
</para>
<note>
<para>
- The above code would just as easily work with
- <function>mysql_fetch_row</function> or other similar functions.
- </para>
- </note>
+ P�edchoz� k�d by tak snadno pracoval i s
+ <function>mysql_fetch_row</function> �i podobn�mi funkcemi.
+</para> </note>
<para>
- For downward compatibility <function>mysql_listdbs</function> can
- also be used. This is deprecated however.
+ Z d�vod� zp�tn� kompatibility m��ete tak� narazit na funkci
+<function>mysql_listdbs</function>. Tuto funkci v�ak nedoporu�ujeme pou��vat,
+nebo� nemus� b�t ji� v dal��ch verz�ch PHP podporov�na.
</para>
<para>
Viz. tak� <function>mysql_db_name</function>.
Index: phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml:1.1 Sun Apr 14
19:47:09 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-list-fields.xml Wed May 29 18:14:32
+2002
@@ -4,7 +4,7 @@
<refentry id="function.mysql-list-fields">
<refnamediv>
<refname>mysql_list_fields</refname>
- <refpurpose>Na�te v�sledek s obsahem polo�ky</refpurpose>
+ <refpurpose>Na�te v�sledek s obsahem sloupce</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
@@ -17,23 +17,22 @@
</parameter></methodparam>
</methodsynopsis>
<para>
- <function>mysql_list_fields</function> retrieves information
- about the given tablename. Arguments are the database name and
- the table name. A result pointer is returned which can be used
- with <function>mysql_field_flags</function>,
- <function>mysql_field_len</function>,
- <function>mysql_field_name</function>, and
- <function>mysql_field_type</function>.
- </para>
+ <function>mysql_list_fields</function> vrac� ukazatel v�sledku o sloupc�ch
+uveden� tabulky. Argumentu jsou jm�no datab�ze a jm�no tabulky.
+Vr�cen� ukazatel v�sledku m��e b�t pou�it spolu s funkcemi
+<function>mysql_field_flags</function>,
+<function>mysql_field_len</function>,
+<function>mysql_field_name</function>, a
+<function>mysql_field_type</function>. </para>
<para>
<example>
- <title><function>mysql_list_fields</function> example</title>
+ <title><function>mysql_list_fields</function> p��klad</title>
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect('localhost', 'myname', 'secret');
+$link = mysql_connect('localhost', 'mojejmeno', 'tajne');
-$fields = mysql_list_fields("database1", "table1", $link);
+$fields = mysql_list_fields("databaze1", "tabulka1", $link);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
@@ -42,12 +41,12 @@
]]>
</programlisting>
<para>
- The above example would produce the following output:
+ P�edchoz� p��klad by m�l n�sleduj�c� v�stup:
<screen>
<![CDATA[
-field1
-field2
-field3
+sloupec1
+sloupec2
+sloupec3
...
]]>
</screen>
@@ -55,8 +54,9 @@
</example>
</para>
<para>
- For downward compatibility <function>mysql_listfields</function>
- can also be used. This is deprecated however.
+ Z d�vod� zp�tn� kompatibility m��ete tak� narazit na funkci
+<function>mysql_listfields</function>. Tuto funkci v�ak nedoporu�ujeme pou��vat,
+nebo� nemus� b�t ji� v dal��ch verz�ch PHP podporov�na.
</para>
<!-- TODO: this is equiv. with 'select * from $table where &false;,'
which implies you can better use the field-research functions
Index: phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml:1.1 Sun Apr 14
19:47:09 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-list-tables.xml Wed May 29 18:14:32
+2002
@@ -17,16 +17,16 @@
</parameter></methodparam>
</methodsynopsis>
<para>
- <function>mysql_list_tables</function> takes a database name and
- returns a result pointer much like the
- <function>mysql_db_query</function> function. You can use the
- <function>mysql_tablename</function> function to extract the
- actual table names from the result pointer, or any other result
- table function.
- </para>
- <para>
- For downward compatibility <function>mysql_listtables</function>
- can also be used. This is deprecated however.
+ <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
+ z ukazatele v�sledku nebo pou��t jin� funkce k zji�t�n� dal��ch
+ informc� o tabulk�ch.
+ </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>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml:1.1 Sun Apr 14
19:47:09 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-num-fields.xml Wed May 29 18:14:32
+2002
@@ -4,28 +4,51 @@
<refentry id="function.mysql-num-fields">
<refnamediv>
<refname>mysql_num_fields</refname>
- <refpurpose>Vr�t� po�et polo�ek ve v�sledku</refpurpose>
+ <refpurpose>Vr�t� po�et sloupc� ve v�sledku</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_num_fields</methodname>
-
+
<methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
</methodsynopsis>
<para>
- <function>mysql_num_fields</function> returns the number of
- fields in a result set.
- </para>
+ <function>mysql_num_fields</function> vrac� po�et sloupc� z�skan�ch
+sql dotazem. </para>
<para>
Viz. tak�:
<function>mysql_db_query</function>,
<function>mysql_query</function>,
<function>mysql_fetch_field</function>,
<function>mysql_num_rows</function>.</para>
+
+ <para>
+ <example>
+ <title><function>mysql_num_fields</function> p��klad</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+$r = mysql_query("SELECT sloupec1, sloupec2, sloupec3 FROM tabulka";
+$pocet_sloupcu = mysql_num_fields($r);
+echo "Po�et sloupc� ve v�sledku: " . $pocet_sloupcu;
+]]>
+ </programlisting>
+ <para>
+ P�edchoz� p��klad by m�l n�sleduj�c� v�stup:
+ <screen>
+<![CDATA[
+Po�et sloupc� ve v�sledku: 3
+]]>
+ </screen>
+ </para>
+ </example>
+ </para>
+
<para>
- For downward compatibility <function>mysql_numfields</function>
- can also be used. This is deprecated however.
+ Z d�vod� zp�tn� kompatibility m��ete tak� narazit na funkci
+<function>mysql_numfields</function>. Tuto funkci v�ak nedoporu�ujeme pou��vat,
+nebo� nemus� b�t ji� v dal��ch verz�ch PHP podporov�na.
</para>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml:1.1 Sun Apr 14 19:47:10
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-num-rows.xml Wed May 29 18:14:32
+2002
@@ -10,27 +10,27 @@
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_num_rows</methodname>
-
+
<methodparam><type>resource</type><parameter>v�sledek</parameter></methodparam>
</methodsynopsis>
<para>
- <function>mysql_num_rows</function> returns the number of rows in
- a result set. This command is only valid for SELECT statements.
- To retrieve the number of rows affected by a INSERT, UPDATE or
- DELETE query, use <function>mysql_affected_rows</function>.
- <example>
- <title><function>mysql_num_rows</function> example</title>
+ <function>mysql_num_rows</function> vrac� po�et z�znam� ve v�sledku
+dotazu. Tento p��kaz je pou�iteln� pouze pro dotaz typu SELECT. Pot�ebujete-li
+z�skat po�et z�znam� ovlivn�n�ch dotazy INSERT, UPDATE nebo DELETE, pou�ijte
+<function>mysql_affected_rows</function>.
+<example>
+ <title><function>mysql_num_rows</function> p��klad</title>
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect("localhost", "username", "password");
-mysql_select_db("database", $link);
+$link = mysql_connect("localhost", "mojejmeno", "heslo");
+mysql_select_db("databaze", $link);
-$result = mysql_query("SELECT * FROM table1", $link);
+$result = mysql_query("SELECT * FROM tabulka1", $link);
$num_rows = mysql_num_rows($result);
-echo "$num_rows Rows\n";
+echo "$num_rows ��dk�\n";
?>
]]>
@@ -41,13 +41,13 @@
Viz. tak�:
<function>mysql_affected_rows</function>,
<function>mysql_connect</function>,
- <function>mysql_select_db</function>, and
+ <function>mysql_select_db</function>, a
<function>mysql_query</function>.
</para>
<para>
- For downward compatibility <function>mysql_numrows</function> can
- also be used. This is deprecated however.
- </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>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml:1.1 Sun Apr 14 19:47:11
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-pconnect.xml Wed May 29 18:14:32
+2002
@@ -16,71 +16,71 @@
server
</parameter></methodparam>
<methodparam
- choice="opt"><type>string</type><parameter>username</parameter></methodparam>
+ choice="opt"><type>string</type><parameter>jmeno</parameter></methodparam>
<methodparam
- choice="opt"><type>string</type><parameter>password</parameter></methodparam>
+ choice="opt"><type>string</type><parameter>heslo</parameter></methodparam>
</methodsynopsis>
<para>
- Returns a positive MySQL persistent link identifier on success,
- or &false; on error.
- </para>
- <para>
- <function>mysql_pconnect</function> establishes a connection
- to a MySQL server. The following defaults are assumed for
- missing optional parameters: <parameter>server</parameter> =
- 'localhost:3306', <parameter>username</parameter> = name of the
- user that owns the server process and
- <parameter>password</parameter> = empty password.
- </para>
- <para>
- The <parameter>server</parameter> parameter can also include a port
- number. eg. "hostname:port" or a path to a socket
- eg. ":/path/to/socket" for the localhost.
- <note>
+ Vytvo�� persistentn� (trval�) spojen� s MySQL serverem a vrac�
+ identifik�tor spojen�. P�i ne�sp�n�m pokusu o spojen� vrac�
+&false;. </para>
+ <para>
+ <function>mysql_pconnect</function> otev�e spojen� s MySQL server.
+Je-li funkce vol�na bez nepovinn�ch paramtr�, jsou u nich p�edpokl�d�ny
+n�sleduj�c� v�choz� hodnoty: <parameter>server</parameter> = 'localhost:3306',
+<parameter>jmeno</parameter> = jm�no vlastn�ka procesu a
+<parameter>heslo</parameter> = pr�zdn� heslo. </para>
+ <para>
+ Parametr <parameter>server</parameter> m��e obsahovat ��slo portu
+ ve stylu "hostname:port" nebo cestu k soketu ve stylu
+":/cesta/k/soketu" pro localhost.
+ <note>
<para>
- Support for ":port" was added in 3.0B4.
+ Podpora pro ":port" byla p�id�na v PHP 3.0B4.
</para>
<para>
- Support for the ":/path/to/socket" was added in
- 3.0.10.
+ Podpora pro ":/cesta/k/soketu" byla p�id�na v PHP 3.0.10.
</para>
</note>
</para>
<!-- TODO move the story to features.persistent, and refer to that -->
<para>
- <function>mysql_pconnect</function> acts very much like
- <function>mysql_connect</function> with two major differences.
+ Funkce <function>mysql_pconnect</function> je velmi podobn� funkci
+ <function>mysql_connect</function> s dv�ma hlavn�mi rozd�ly.
</para>
<para>
- First, when connecting, the function would first try to find a
- (persistent) link that's already open with the same host,
- username and password. If one is found, an identifier for it
- will be returned instead of opening a new connection.
+ Za prv�, funkce se nejprve pokus� nal�zt ji� existuj�c� (persistentn�)
+ spojen� otev�en� na stejn�m portu pod stejn�m jm�nem a heslem. Je-li
+ takov� spojen� nalezeno, pou�ije se nam�sto vytv��en� nov�ho.
</para>
<para>
- Second, the connection to the SQL server will not be closed when
- the execution of the script ends. Instead, the link will remain
- open for future use (<function>mysql_close</function> will not
- close links established by <function>mysql_pconnect</function>).
+ Za druh�, spojen� s SQL serverem nebude uzav�eno p�i ukon�en� b�hu skriptu.
+ Z�stane otev�eno pro pou�it� v dal��ch skriptech, kter� teprve budou
+ spou�t�ny (<function>mysql_close</function> neuzav�e persistentn�
+ spojen� vytvo�en� pomoc� <function>mysql_pconnect</function>).
+</para> <para>
+ Proto je tento typ spojen� naz�v�n jako 'persistentn�' - trval�.
</para>
<para>
- This type of link is therefore called 'persistent'.
- </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>
- Note, that these kind of links only work if you are using
- a module version of PHP. See the
- <link linkend="features.persistent-connections">Persistent
- Database Connections</link> section for more information.
+ Persistentn� spojen� je podporov�no 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>.
</para>
</note>
<warning>
<para>
- Using persistent connections can require a bit of tuning of your Apache
- and MySQL configurations to ensure that you do not exceed the number of
- connections allowed by MySQL.
- </para>
+ Pou��v�n� persistetn�ho spojen� m��e vy�adovat malou �pravu v
+konfiguraci Apache a MySQL k zaji�t�n� nep�ekro�en� maxim�ln�ho limitu
+povolen�ch p�ipojen� k MySQL. </para>
</warning>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-query.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-query.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-query.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-query.xml:1.1 Sun Apr 14 19:47:11
2002
+++ phpdoc-cs/reference/mysql/functions/mysql-query.xml Wed May 29 18:14:32 2002
@@ -15,86 +15,73 @@
choice="opt"><type>resource</type><parameter>spojeni</parameter></methodparam>
</methodsynopsis>
<para>
- <function>mysql_query</function> sends a query to the currently
- active database on the server that's associated with the
- specified link identifier. If
- <parameter>spojeni</parameter> isn't specified, the last
- opened link is assumed. If no link is open, the function tries
- to establish a link as if <function>mysql_connect</function> was
- called with no arguments, and use it.
- </para>
- <note>
- <para>
- The query string should not end with a semicolon.
- </para>
+ <function>mysql_query</function> Provede dotaz na aktu�ln�m spojen� v
+aktivn� datab�zi na serveru a vr�t� identifik�tor v�sledku. Nen�-li
+parametr <parameter>spojeni</parameter> uveden, pou�ije posledn� otev�en�
+spojen�. Pokud nen� ��dn� otev�en� spojen� nalezeno, funkce se ho pokus�
+vytvo�it za pou�it� v�choz�ch hodnot funkce <function>mysql_connect</function>
+(jakoby byla vol�na bez parametr�) </para>
+<note>
+ <para>
+ �et�zec dotazu by nem�l kon�it st�edn�kem.
+ </para>
</note>
<para>
- Only for SELECT statements <function>mysql_query</function>
- returns a resource identifier or &false; if the query was
- not executed correctly. For other type of SQL statements,
- <function>mysql_query</function> returns &true; on success
- and &false; on error. A non-&false; return value
- means that the query was legal and could be executed by
- the server. It does not indicate anything about the number of
- rows affected or returned. It is perfectly possible for a query
- to succeed but affect no rows or return no rows.
- </para>
- <para>
- The following query is syntactically invalid, so
- <function>mysql_query</function> fails and returns &false;:
- <example>
- <title><function>mysql_query</function></title>
- <programlisting role="php">
-<![CDATA[
+ Pouze p�i pou�it� dotazu typu SELECT je vr�cen identifik�tor v�sledku �i
+&false; pokud p�i vykon�v�n� dotazu do�lo k chyb�. P�i ostatn�ch typech dotaz�
+<function>mysql_query</function> vrac� &true; p�i �sp�n�m dotazu nebo
+&false; dojde-li k chyb�. Ne-&false; vr�cen� hodnota znamen�, �e dotaz byl
+vykon�n serverem bez chyb. Tato funkce nezaznamen�v� ��dn� �daje o po�tu
+ovlivn�n�ch nebo vr�cen�ch ��dk�. Lze pouze zjistit, zda dotaz prob�hl v
+po��dku.</para>
+<para>
+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[
<php
$result = mysql_query("SELECT * WHERE 1=1")
- or die("Invalid query");
+ or die("�patn� dotaz!");
?>
]]>
</programlisting>
</example>
</para>
<para>
- The following query is semantically invalid if
- <literal>my_col</literal> is not a column in the table
- <literal>my_tbl</literal>, so <function>mysql_query</function>
- fails and returns &false;:
+ N�sleduj�c� dotaz je v�znamov� nespr�vn�
+ <literal>my_col</literal> nen� sloupec v tabulce
+ <literal>my_tbl</literal>, tak�e <function>mysql_query</function>
+ sel�e a vr�t� &false;:
<example>
<title><function>mysql_query</function></title>
<programlisting role="php">
<![CDATA[
<?php
$result = mysql_query("SELECT my_col FROM my_tbl")
- or exit ("Invalid query");
+ or exit ("�patn� dotaz!");
?>
]]>
</programlisting>
</example>
</para>
<para>
- <function>mysql_query</function> will also fail and return &false;
- if you don't have permission to access the table(s) referenced by
- the query.
- </para>
- <para>
- Assuming the query succeeds, you can call
- <function>mysql_num_rows</function> to find out how many rows
- were returned for a SELECT statment or
- <function>mysql_affected_rows</function> to find out how many
- rows were affected by a DELETE, INSERT, REPLACE, or UPDATE
- statement.
- </para>
- <para>
- Only for SELECT statements, <function>mysql_query</function>
- returns a new result identifier that you can pass to
- <function>mysql_fetch_array</function> and other
- functions dealing with result tables. When you are done with the
- result set, you can free the resources associated with it by
- calling <function>mysql_free_result</function>. Although, the
- memory will automatically be freed at the end of the script's
- execution.
- </para>
- <para>
+ <function>mysql_query</function> tak� v�dy sel�e a vr�t� &false;
+ jestli�e nem�te dostate�n� opr�vn�n� p��stupu do tabulky (tabulek)
+uveden�ch v dotazu.</para>
+ <para>
+ Pot�ebujete-li zjistit po�et z�znam� vr�cen�ch dotazem typu SELECT,
+pou�ijte n�sledn� funkci <function>mysql_num_rows</function> �i p��padn� funkci
+<function>mysql_affected_rows</function>, pokud pot�ebujete zjistit po�et v�ech
+ovlivn�n�ch z�znam� dotazy typ� DELETE, INSERT, REPLACE nebo UPDATE. </para>
+ <para>
+ Pouze p�i dotazu typu SELECT <function>mysql_query</function>
+ vrac� nov� identifik�tor dotazu, kter� lze pou��t nap��klad pro vol�n�
+funkce <function>mysql_fetch_array</function> a dal��ch funkc� pro zpracov�n�
+v�sledk� dotazu. Nepot�ebujete-li ji� obsah v�sledku dotazu, m��ete uvolnit
+pam�t vol�n�m funkce <function>mysql_free_result</function>. Nicm�n� pam�t bude
+uvoln�na automaticky na konci b�hu skriptu. </para>
+ <para>
Viz. tak�: <function>mysql_num_rows</function>
<function>mysql_affected_rows</function>,
<function>mysql_unbuffered_query</function>,
@@ -103,7 +90,7 @@
<function>mysql_fetch_row</function>,
<function>mysql_fetch_assoc</function>,
<function>mysql_result</function>,
- <function>mysql_select_db</function>, and
+ <function>mysql_select_db</function>, a
<function>mysql_connect</function>.
</para>
</refsect1>
