costra Fri Jun 7 15:42:44 2002 EDT
Added files:
/phpdoc-cs/reference/mysql/functions mysql-info.xml
mysql-list-processes.xml
mysql-ping.xml
mysql-real-escape-string.xml
mysql-stat.xml
mysql-thread-id.xml
Modified files:
/phpdoc-cs/reference/mysql/functions mysql-character-set-name.xml
mysql-escape-string.xml
Log:
Some fixes and new translations
Modified Files:
mysql-character-set-name.xml (en rev. 1.3) mysql-escape-string.xml (1.5)
Added Files:
mysql-info.xml (1.3) mysql-list-processes.xml (1.2) mysql-ping.xml (1.3)
mysql-real-escape-string.xml (1.3) mysql-stat.xml (1.2)
mysql-thread-id.xml (1.4)
Index: phpdoc-cs/reference/mysql/functions/mysql-character-set-name.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-character-set-name.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-character-set-name.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-character-set-name.xml:1.1 Thu
Jun 6 17:52:12 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-character-set-name.xml Fri Jun 7
+15:42:44 2002
@@ -9,8 +9,7 @@
<methodsynopsis>
<type>int</type><methodname>mysql_character_set_name</methodname>
<methodparam
-choice="opt"><type>resource</type><parameter>spojeni</parameter></methodpa
-r a m > </methodsynopsis> <para>
+choice="opt"><type>resource</type><parameter>spojeni</parameter></methodparam>
+</methodsynopsis> <para>
<function>mysql_character_set_name</function> vrac� jm�no v�choz�
znakov� str�nky aktu�ln�ho spojen�.</para>
<example>
Index: phpdoc-cs/reference/mysql/functions/mysql-escape-string.xml
diff -u phpdoc-cs/reference/mysql/functions/mysql-escape-string.xml:1.1
phpdoc-cs/reference/mysql/functions/mysql-escape-string.xml:1.2
--- phpdoc-cs/reference/mysql/functions/mysql-escape-string.xml:1.1 Sun Apr 14
19:47:07 2002
+++ phpdoc-cs/reference/mysql/functions/mysql-escape-string.xml Fri Jun 7 15:42:44
+2002
@@ -5,7 +5,7 @@
<refnamediv>
<refname>mysql_escape_string</refname>
<refpurpose>
- Uprav� �et�zec pro pou�it� v mysql_query.
+ Uprav� �et�zec pro bezpe�n� pou�it� v mysql_query.
</refpurpose>
</refnamediv>
<refsect1>
@@ -16,16 +16,49 @@
<methodparam><type>string</type><parameter>neupraveny_retezec</parameter></methodparam>
</methodsynopsis>
<para>
- 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.
+ Tato funkce opat�� speci�ln� znaky v <parameter>neupraveny_retezec</parameter>
+ zp�tn�m lom�tkem pro bezpe�n� pou�it� v <function>mysql_query</function>
+ (konce ��dk� jsou nahrazeny zna�kou \n atd.).
</para>
<note>
<simpara>
<function>mysql_escape_string</function> nep�id�v� zp�tn� lom�tka p�ed
znaky <literal>%</literal> a <literal>_</literal>.
</simpara>
+ <simpara>
+ Funkce je t�m�� identick� s <function>mysql_real_escape_string</function>.
+ Vyjma toho, �e mysql_real_escape_string() uprav� �et�zec podle nastaven� znakov�
+ sady v aktu�ln�m identifik�toru spojen�.
+<function>mysql_escape_string</function>
+ nepou��v� identifik�tor spojen� a ani nebere v potaz aktu�ln� znakovou sadu.
+ </simpara>
+ </note>
+ <example>
+ <title><function>mysql_escape_string</function> p��klad</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>
+ P�edchoz� p��klad by zobrazil n�sleduj�c� v�stup:
+ <screen>
+<![CDATA[
+Escaped string: Zak\'s Laptop
+]]>
+ </screen>
+ </para>
+ </example>
+ <para>
+ D�le tak�:
+ <function>mysql_real_escape_string</function>,
+ <function>addslashes</function> a
+ <link linkend="ini.magic-quotes-gpc">magic_quotes_gpc</link>
+ directive.
+ </para>
</note>
</refsect1>
</refentry>
Index: phpdoc-cs/reference/mysql/functions/mysql-info.xml
+++ phpdoc-cs/reference/mysql/functions/mysql-info.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<!-- $Revision: 1.1 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 -->
<refentry id="function.mysql-info">
<refnamediv>
<refname>mysql_info</refname>
<refpurpose>
Vrac� informace o posledn�m dotazu
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_info</methodname>
<methodparam choice="opt"><type>resource</type><parameter>
spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_info</function> vrac� detailn� informace o posledn�m
dotazu v pou�it�m <parameter>spojeni</parameter>.
Pokud <parameter>spojeni</parameter> nen� uvedeno, pou�ije se posledn�
otev�en� spojen�.
</para>
<para>
<function>mysql_info</function> vrac� �etezec z v�emi dotazy vylistovan�mi
n�e. Pro v�echny ostatn� &false;. Form�t �et�zce je z�visl� na pou�it�m
typu dotazu.
<example>
<title>P��slu�n� MySQL dotazy</title>
<programlisting role="mysql">
<![CDATA[
INSERT INTO ... SELECT ...
String format: Records: 23 Duplicates: 0 Warnings: 0
INSERT INTO ... VALUES (...),(...),(...)...
String format: Records: 37 Duplicates: 0 Warnings: 0
LOAD DATA INFILE ...
String format: Records: 42 Deleted: 0 Skipped: 0 Warnings: 0
ALTER TABLE
String format: Records: 60 Duplicates: 0 Warnings: 0
UPDATE
String format: Rows matched: 65 Changed: 65 Warnings: 0
]]>
</programlisting>
</example>
��sla uveden� v p��kladu jsou jen pro ilustraci; jejich hodnoty budou
shodn� s v�sledkem dotazu.
</para>
<note>
<para>
<function>mysql_info</function> vrac� hodnotu jinou ne� &false; v p��pad�
dotazu INSERT ... VALUES, ve kter�m jsou uvedeny hodnoty pro z�pis v�ce
z�znam� najednou.
</para>
</note>
<para>
D�le tak�: <function>mysql_affected_rows</function>
</para>
</refsect1>
</refentry>
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
Index: phpdoc-cs/reference/mysql/functions/mysql-list-processes.xml
+++ phpdoc-cs/reference/mysql/functions/mysql-list-processes.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<!-- $Revision: 1.1 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.96 -->
<refentry id="function.mysql-list-processes">
<refnamediv>
<refname>mysql_list_processes</refname>
<refpurpose>List MySQL processes</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>resource</type><methodname>mysql_list_processes</methodname>
<methodparam choice="opt"><type>resource</type><parameter>
spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_list_processes</function> vrac� ukazatel popisuj�c�
aktu�ln� vl�kna serveru.
</para>
<para>
<example>
<title><function>mysql_list_processes</function> p��klad</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect('localhost', 'mysql_jmeno', 'mysql_heslo');
$result = mysql_list_processes($link);
while ($row = mysql_fetch_row($result)){
printf("%s %s %s %s %s\n", $row["Id"], $row["Host"], $row["db"],
$row["Command"], $row["Time"]);
}
mysql_free_result ($result);
?>
]]>
</programlisting>
<para>
P�edchoz� p��klad by zobrazit n�sleduj�c� v�stup:
<screen>
<![CDATA[
1 localhost test Processlist 0
4 localhost mysql sleep 5
]]>
</screen>
</para>
</example>
</para>
<para>
See also:
<function>mysql_thread_id</function>
</para>
</refsect1>
</refentry>
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
Index: phpdoc-cs/reference/mysql/functions/mysql-ping.xml
+++ phpdoc-cs/reference/mysql/functions/mysql-ping.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<!-- $Revision: 1.1 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.100 -->
<refentry id="function.mysql-ping">
<refnamediv>
<refname>mysql_ping</refname>
<refpurpose>Ov��� spojen� se serverem, p��padn�, nen�-li spojen� dostupn�,
pokus� se p�ipojit znovu.</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>bool</type><methodname>mysql_ping</methodname>
<methodparam choice="opt"><type>resource</type><parameter>
spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_ping</function> zkou��, zda je �i nen� spojen� se serverem.
V p��pad�, �e spojen� je ztraceno, automaticky se pokus� vytvo�it nov� spojen�.
Tato funkce m��e b�t pou�ita ve scriptech, kter� z�st�vaj� dlouho dobu ne�inn�
k zji�t�n�, zda je sepojen� se serverem ji� zav�eno a v p��pad� nutnosti nav�ou
automaticky spojen� nov�.
<function>mysql_ping</function> vrac� &true; pokud je spojen� nav�z�no, jinak
&false;.
</para>
<para>
D�le tak�:
<function>mysql_thread_id</function>,
<function>mysql_list_processes</function>.
</para>
</refsect1>
</refentry>
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
Index: phpdoc-cs/reference/mysql/functions/mysql-real-escape-string.xml
+++ phpdoc-cs/reference/mysql/functions/mysql-real-escape-string.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<!-- $Revision: 1.1 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.100 -->
<refentry id="function.mysql-real-escape-string">
<refnamediv>
<refname>mysql_real_escape_string</refname>
<refpurpose>
Uprav� �et�zec pro bezpe�n� pou�it� v mysql_query.
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_real_escape_string</methodname>
<methodparam><type>string</type><parameter>neupraveny_retezec</parameter></methodparam>
<methodparam
choice="opt"><type>resource</type><parameter>spojeni</parameter></methodparam>
</methodsynopsis>
<para>
Tato funkce opat�� speci�ln� znaky v <parameter>neupraveny_retezec</parameter>
zp�tn�m lom�tkem pro bezpe�n� pou�it� v <function>mysql_query</function>
v z�vislosti na aktu�ln� znakov� sad� spojen� (konce ��dk� jsou nahrazeny zna�kou
\n atd.).
</para>
<note>
<simpara>
<function>mysql_real_escape_string</function> nep�id�v� zp�tn� lom�tka p�ed
<literal>%</literal> and <literal>_</literal>.
</simpara>
</note>
<example>
<title><function>mysql_real_escape_string</function> p��klad</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$item = "Zak's and Derick's Laptop";
$escaped_item = mysql_real_escape_string($item);
printf ("Escaped string: %s\n", $escaped_item);
?>
]]>
</programlisting>
<para>
P�edchoz� p��klad by zobrazil n�sleduj�c� v�stup:
<screen>
<![CDATA[
Escaped string: Zak\'s and Derick\'s Laptop
]]>
</screen>
</para>
</example>
<para>
D�le tak�:
<function>mysql_escape_string</function>,
<function>mysql_character_set_name</function>.
</para>
</refsect1>
</refentry>
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
Index: phpdoc-cs/reference/mysql/functions/mysql-stat.xml
+++ phpdoc-cs/reference/mysql/functions/mysql-stat.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<!-- $Revision: 1.1 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.62 -->
<refentry id="function.mysql-stat">
<refnamediv>
<refname>mysql_stat</refname>
<refpurpose>Vrac� aktu�ln� stav syst�mu</refpurpose>
</refnamediv>
<refsect1>
<title>popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_stat</methodname>
<methodparam
choice="opt"><type>resource</type><parameter>spojeni</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_stat</function> vrac� aktu�ln� stav syst�mu.
</para>
<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
kompletn� v�pis stav� dal��ch prom�nn�ch mus�te pou��t sql dotaz SHOW STATUS.
</para>
</note>
<para>
<example>
<title><function>mysql_stat</function> p��kaz</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect('localhost', "mysql_user", "mysql_password");
printf("%s\n", mysql_stat($link));
?>
]]>
</programlisting>
<para>
p�edchoz� p��klad by zobrazil n�sleduj�c� v�stup:
<screen>
<![CDATA[
Uptime: 5380 Threads: 1 Questions: 1321299 Slow queries: 1 Opens: 26 Flush tables:
1 Open tables: 17 Queries per second avg: 245.595
]]>
</screen>
</para>
</example>
</para>
</refsect1>
</refentry>
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
Index: phpdoc-cs/reference/mysql/functions/mysql-thread-id.xml
+++ phpdoc-cs/reference/mysql/functions/mysql-thread-id.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<!-- $Revision: 1.1 $ -->
<refentry id="function.mysql-thread-id">
<refnamediv>
<refname>mysql_thread_id</refname>
<refpurpose>Vr�t� id aktu�ln�ho vl�kna</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_thread_id</methodname>
<methodparam
choice="opt"><type>resource</type><parameter>spojeni</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_thread_id</function> Vr�t� id aktu�ln�ho vl�kna. Je-li spojen�
ztraceno a znovu
nav�z�no pomoc� <function>mysql_ping</function>, id vl�nka bude jin�.
</para>
<example>
<title><function>mysql_thread_id</function> p��klad</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect('localhost', 'mysql_uziv', 'mysql_heslo');
$thread_id = mysql_thread_id($link);
if ($thread_id){
printf ("id aktu�ln�ho vl�kna je %d\n", $thread_id);
}
?>
]]>
</programlisting>
<para>
P�edchoz� p��klad by zobrazil n�sleduj�c� v�stup:
<screen>
<![CDATA[
id aktu�ln�ho vl�kna je 73
]]>
</screen>
</para>
</example>
<para>
D�le tak�:
<function>mysql_ping</function>,
<function>mysql_list_processes</function>.
</para>
</refsect1>
</refentry>
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->
