slawek Sat May 4 16:30:55 2002 EDT
Added files:
/phpdoc/pl/reference/mysql/functions mysql-info.xml
Modified files:
/phpdoc/pl/reference/mysql reference.xml
/phpdoc/pl/reference/mysql/functions mysql-affected-rows.xml
mysql-change-user.xml
mysql-character-set-name.xml
mysql-close.xml
mysql-connect.xml
mysql-create-db.xml
mysql-data-seek.xml
mysql-db-name.xml
mysql-db-query.xml
mysql-drop-db.xml
mysql-errno.xml
mysql-error.xml
mysql-escape-string.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-flags.xml
mysql-field-len.xml
mysql-field-name.xml
mysql-field-seek.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-dbs.xml
mysql-list-fields.xml
mysql-list-processes.xml
mysql-list-tables.xml
mysql-num-fields.xml
mysql-num-rows.xml
mysql-pconnect.xml
mysql-ping.xml mysql-query.xml
mysql-real-escape-string.xml
mysql-result.xml
mysql-select-db.xml
mysql-stat.xml
mysql-tablename.xml
mysql-thread-id.xml
mysql-unbuffered-query.xml
Log:
All mysql related files in sync with en/ tree.
Index: phpdoc/pl/reference/mysql/reference.xml
diff -u phpdoc/pl/reference/mysql/reference.xml:1.3
phpdoc/pl/reference/mysql/reference.xml:1.4
--- phpdoc/pl/reference/mysql/reference.xml:1.3 Sat May 4 07:20:27 2002
+++ phpdoc/pl/reference/mysql/reference.xml Sat May 4 16:30:48 2002
@@ -1,5 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- $Revision: 1.3 $ -->
+<!-- EN-Revision: 1.5 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<reference id="ref.mysql">
<title>MySQL</title>
<titleabbrev>MySQL</titleabbrev>
@@ -17,7 +18,7 @@
<section id="mysql.requirements">
<title>Wymagania</title>
<para>
- Aby funkcje by�y dost�pne, nale�y skompilowa� PHP z obs�ug� MySQL
+ Aby funkcje by�y dost�pne, nale�y skompilowa� PHP z obs�ug� MySQL.
</para>
</section>
@@ -42,9 +43,9 @@
<title>Konfiguracja</title>
<para>
Zachowanie funkcji MySQL zale�y od ustawie� w
- <link linkend="configuration">pliku konfiguracyjnym</link>.
+ <link linkend="configuration.file">pliku konfiguracyjnym</link> &php.ini;.
<table>
- <title><link linkend="ini.sect.mysql">Opcje konfiguracyjne MySQL</link></title>
+ <title>Opcje konfiguracyjne MySQL</title>
<tgroup cols="3">
<thead>
<row>
@@ -89,12 +90,135 @@
<entry>NULL</entry>
<entry>PHP_INI_ALL</entry>
</row>
+ <row>
+ <entry>mysql.default_password</entry>
+ <entry>NULL</entry>
+ <entry>PHP_INI_ALL</entry>
+ </row>
</tbody>
</tgroup>
</table>
Aby uzyska� wi�cej informacji na temat sta�ych PHP_INI_* zobacz
<function>ini_set</function>.
</para>
+ <para>
+ Oto kr�tki opis poszczeg�lnych opcji konfiguracyjnych:
+ <variablelist>
+
+ <varlistentry id="ini.mysql.allow-persistent">
+ <term>
+ <parameter>mysql.allow_persistent</parameter>
+ <type>boolean</type>
+ </term>
+ <listitem>
+ <para>
+ Czy pozwala� na
+ <link linkend="features.persistent-connections">sta�e po��czenia</link>
+ z MySQL.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.max-persistent">
+ <term>
+ <parameter>mysql.max_persistent</parameter>
+ <type>integer</type>
+ </term>
+ <listitem>
+ <para>
+ Maksymalna liczba sta�ych po��cze� MySQL na ka�dy proces.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.max-links">
+ <term>
+ <parameter>mysql.max_links</parameter>
+ <type>integer</type>
+ </term>
+ <listitem>
+ <para>
+ Maksymalna liczba po��cze� MySQL na proces, w��czaj�c w to po��czenia
+ sta�e.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-port">
+ <term>
+ <parameter>mysql.default_port</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ Domy�lny numer portu TCP, kt�ry b�dzie u�yty przy ��czeniu si� z
+ serwerm baz danych, je�li nie zostanie podany �aden inny. Je�li
+ nie b�dzie podany port domy�lny, b�dzie on pobrany ze zmiennej
+ �rodowiskowej <literal>MYSQL_TCP_PORT</literal>, wpisu
+ <literal>mysql-tcp</literal> w pliku
+ <filename>/etc/services</filename> lub podanej przy kompilacji opcji
+ <literal>MYSQL_PORT</literal>, w tym w�a�nie porz�dku. Pod Win32 u�yta
+ b�dzie tylko sta�a <literal>MYSQL_PORT</literal>.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-socket">
+ <term>
+ <parameter>mysql.default_socket</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ Domy�lna nazwa gniazda, kt�re b�dzie u�yte do ��czenia si� z lokalnym
+ serwerem baz danych, je�li nie zostanie podana �adna inna nazwa.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-host">
+ <term>
+ <parameter>mysql.default_host</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ Domy�lny serwer, kt�ry b�dzie u�ywany przy ��czeniu si� z
+ baz� danych, je�li nie zostanie podany �aden inny. Nie dotyczy
+ <link linkend="ini.safe-mode">trybu bezpiecznego</link>.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-user">
+ <term>
+ <parameter>mysql.default_user</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ Domy�lna nazwa u�ytkownika, kt�ra b�dzie u�ywana przy ��czeniu si� z
+ Nie dotyczy <link linkend="ini.safe-mode">trybu bezpiecznego</link>.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="ini.mysql.default-password">
+ <term>
+ <parameter>mysql.default_password</parameter>
+ <type>string</type>
+ </term>
+ <listitem>
+ <para>
+ Domy�lne has�o, kt�re b�dzie u�yte przy ��czeniu si� z serwerem baz
+ danych, je�li nie zostanie podane �adne inne. Nie dotyczy
+ <link linkend="ini.safe-mode">trybu bezpiecznego</link>.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ </variablelist>
+ </para>
</section>
<section id="mysql.resources">
@@ -139,6 +263,18 @@
<entry>
Kolumny s� zwracane jako tablica indeksowana numerycznie. Indeks
zaczyna si� od 0 i wskazuje na pierwsze pole w wyniku.
+ </entry>
+ </row>
+ <row>
+ <entry>MYSQL_STORE_RESULT</entry>
+ <entry>
+ Wynik operacji MySQL jest buforowany.
+ </entry>
+ </row>
+ <row>
+ <entry>MYSQL_USE_RESULT</entry>
+ <entry>
+ Wynik operacji MySQL nie jest buforowany.
</entry>
</row>
</tbody>
Index: phpdoc/pl/reference/mysql/functions/mysql-affected-rows.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-affected-rows.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-affected-rows.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-affected-rows.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-affected-rows.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-affected-rows' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-affected-rows">
<refnamediv>
<refname>mysql_affected_rows</refname>
@@ -52,9 +50,64 @@
</para>
<para>
Je�li ostatnie zapytanie nie powiod�o si�, funkcja zwr�ci -1.
+ <example>
+ <title>Zapytanie DELETE</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+/* ��czenie z baz� */
+mysql_pconnect('localhost', 'uzytkownik', 'haslo') or
+ die ('Nie mo�na si� po��czy�');
+
+/* to powinno zwr�ci� poprawn� liczb� usuni�tych rekord�w */
+mysql_query("DELETE FROM mytable WHERE id < 10");
+printf ("Usuni�tych rekord�w: %d\n", mysql_affected_rows());
+
+/* bez warunku 'where' zwr�cone zostanie 0 */
+mysql_query("DELETE FROM mytable");
+printf ("Usuni�tych rekord�w: %d\n", mysql_affected_rows());
+?>
+]]>
+ </programlisting>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ <screen>
+<![CDATA[
+Usuni�tych rekord�w: 10
+Usuni�tych rekord�w: 0
+]]>
+ </screen>
+ </para>
+ </example>
+ <example>
+ <title>Zapytanie UPDATE</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+/* ��czenie z baz� */
+mysql_pconnect('localhost', 'uzytkownik', 'haslo') or
+ die ('Nie mo�na si� po��czy�');
+
+/* aktualizacja rekord�w */
+mysql_query("UPDATE mytable SET used=1 WHERE id < 10");
+printf ("Zaktualizowanych rekord�w: %d\n", mysql_affected_rpws());
+mysql_query("COMMIT");
+?>
+]]>
+ </programlisting>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ <screen>
+<![CDATA[
+Zaktualizowanych rekord�w: 10
+]]>
+ </screen>
+ </para>
+ </example>
</para>
<para>
- Patrz tak�e: <function>mysql_num_rows</function>.
+ Patrz tak�e: <function>mysql_num_rows</function>,
+ <function>mysql_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-change-user.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-change-user.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-change-user.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-change-user.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-change-user.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-change-user' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-change-user">
<refnamediv>
<refname>mysql_change_user</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-character-set-name.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-character-set-name.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-character-set-name.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-character-set-name.xml:1.2 Wed
Apr 17 03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-character-set-name.xml Sat May 4
+16:30:51 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.25 -->
-<!-- last change to 'mysql-character-set-name' in en/ tree in rev 1.100 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.100 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-character_set_name">
<refnamediv>
<refname>mysql_character_set_name</refname>
@@ -23,7 +21,7 @@
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect('localhost', 'u�ytkownik', 'has�o');
+$link = mysql_connect('localhost', 'uzytkownik', 'haslo');
$charset = mysql_character_set_name($link);
printf ("obecny zestaw znak�w to %s\n", $charset);
?>
Index: phpdoc/pl/reference/mysql/functions/mysql-close.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-close.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-close.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-close.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-close.xml Sat May 4 16:30:51 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-close' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-close">
<refnamediv>
<refname>mysql_close</refname>
@@ -43,9 +41,9 @@
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_connect("serwer", "uzytkownik", "haslo")
- or die("Nie mo�na si� po��czy�");
- print ("Po��czenie nawi�zane");
+ $link = mysql_connect('localhost', 'uzytkownik', 'haslo')
+ or die('Nie mo�na si� po��czy�');
+ print ('Po��czenie nawi�zane');
mysql_close($link);
?>
]]>
Index: phpdoc/pl/reference/mysql/functions/mysql-connect.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-connect.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-connect.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-connect.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-connect.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-connect' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-connect">
<refnamediv>
<refname>mysql_connect</refname>
@@ -80,9 +78,9 @@
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_connect("localhost", "uzytkownik", "haslo")
- or die("Nie mo�na si� po��czy�");
- print ("Po��czenie nawi�zane");
+ $link = mysql_connect('localhost', 'uzytkownik', 'haslo')
+ or die('Nie mo�na si� po��czy�');
+ print ('Po��czenie nawi�zane');
mysql_close($link);
?>
]]>
Index: phpdoc/pl/reference/mysql/functions/mysql-create-db.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-create-db.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-create-db.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-create-db.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-create-db.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-create-db' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-create-db">
<refnamediv>
<refname>mysql_create_db</refname>
@@ -30,10 +28,10 @@
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_pconnect("serwer", "uzytkownik", "haslo")
- or die("Nie mo�na si� po��czy�");
- if (mysql_create_db("my_db")) {
- print ("Utworzono baz�\n");
+ $link = mysql_pconnect('localhost', 'uzytkownik', 'haslo')
+ or die('Nie mo�na si� po��czy�');
+ if (mysql_create_db('my_db')) {
+ print ('Utworzono baz�\n');
} else {
printf ("B��d podczas tworzenia bazy: %s\n", mysql_error ());
}
@@ -45,8 +43,16 @@
Aby zachowa� zgodno�� z poprzednimi wersjami, mo�na u�y� r�wnie�
<function>mysql_createdb</function>. Jest to jednak niezalecane.
</para>
+ <note>
+ <para>
+ Stosowanie funkcji <function>mysql_create_db</function> jest niezalecane.
+ Sugerowane jest wydawanie polecenia CREATE DATABASE przy u�yciu funkcji
+ <function>mysql_query</function>.
+ </para>
+ </note>
<para>
- Patrz tak�e: <function>mysql_drop_db</function>.
+ Patrz tak�e: <function>mysql_drop_db</function>,
+ <function>mysql_query</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-data-seek.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-data-seek.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-data-seek.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-data-seek.xml:1.3 Sat May 4 07:20:27
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-data-seek.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-data-seek' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-data-seek">
<refnamediv>
<refname>mysql_data_seek</refname>
@@ -25,22 +23,30 @@
wywo�anie <function>mysql_fetch_row</function> zwr�ci ten wiersz.
</para>
<para>
- <parameter>numer_wiersza</parameter> liczony jest od 0.
+ <parameter>numer_wiersza</parameter> liczony jest od 0. Zakres warto�ci
+ od 0 do mysql_num_rows - 1.
</para>
+ <note>
+ <para>
+ Funkcj� <function>mysql_data_seek</function> mo�na stosowa� jedynie w
+ po��czeniu z <function>mysql_query</function>, nie z
+ <function>mysql_unbuffered_query</function>.
+ </para>
+ </note>
<example>
<title>mysql_data_seek</title>
<programlisting role="php">
<![CDATA[
<?php
- $link = mysql_pconnect("serwer", "uzytkownik", "haslo")
- or die("Nie mo�na si� po��czy�");
+ $link = mysql_pconnect('serwer', 'uzytkownik', 'haslo')
+ or die('Nie mo�na si� po��czy�');
- mysql_select_db("baza")
- or die("Nie mo�na wybra� bazy danych");
+ mysql_select_db('baza')
+ or die('Nie mo�na wybra� bazy danych');
- $query = "SELECT last_name, first_name FROM friends";
+ $query = 'SELECT last_name, first_name FROM friends';
$result = mysql_query($query)
- or die("Zapytanie zako�czone niepowodzeniem");
+ or die('Zapytanie zako�czone niepowodzeniem');
/* pobieramy wiersze w odwrotnej kolejno�ci */
for ($i = mysql_num_rows($result) - 1; $i >=0; $i--) {
@@ -60,6 +66,10 @@
]]>
</programlisting>
</example>
+ <para>
+ Patrz tak�e: <function>mysql_query</function>,
+ <function>mysql_num_rows</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-db-name.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-db-name.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-db-name.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-db-name.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-db-name.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-db-name' in en/ tree in rev 1.23 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.23 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-db-name">
<refnamediv>
<refname>mysql_db_name</refname>
@@ -35,7 +33,7 @@
<?php
error_reporting(E_ALL);
-mysql_connect("serwer", "uzytkownik", "haslo");
+mysql_connect('localhost', 'uzytkownik', 'haslo');
$db_list = mysql_list_dbs();
$i = 0;
Index: phpdoc/pl/reference/mysql/functions/mysql-db-query.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-db-query.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-db-query.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-db-query.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-db-query.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-db-query' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-db-query">
<refnamediv>
<refname>mysql_db_query</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-drop-db.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-drop-db.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-drop-db.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-drop-db.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-drop-db.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-drop-db' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-drop-db">
<refnamediv>
<refname>mysql_drop_db</refname>
@@ -28,8 +26,16 @@
Aby zachowa� zgodno�� z poprzednimi wersjami, mo�na u�y� r�wnie�
<function>mysql_dropdb</function>. Jest to jednak niezalecane.
</para>
+ <note>
+ <para>
+ Stosowanie funkcji <function>mysql_drop_db</function> jest niezalecane.
+ Sugerowane jest wydawanie polecenia DROP DATABASE przy u�yciu funkcji
+ <function>mysql_query</function>.
+ </para>
+ </note>
<para>
- Patrz tak�e: <function>mysql_create_db</function>.
+ Patrz tak�e: <function>mysql_create_db</function>,
+ <function>mysql_query</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-errno.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-errno.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-errno.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-errno.xml:1.3 Sat May 4 07:20:27
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-errno.xml Sat May 4 16:30:51 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-errno' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-errno">
<refnamediv>
<refname>mysql_errno</refname>
@@ -30,20 +28,32 @@
<function>mysql_error</function> i <function>mysql_errno</function>),
dlatego je�li jej u�ywasz, upewnij si�, by zrobi� to przed u�yciem
nast�pnej funkcji MySQL.
- <informalexample>
+ <example>
+ <title>Przyk�ad u�ycia mysql_errno</title>
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("nieistniejacyserwer");
-echo mysql_errno().": ".mysql_error()."<BR>";
-mysql_select_db("niematakiejbazy");
-echo mysql_errno().": ".mysql_error()."<BR>";
-$conn = mysql_query("SELECT * FROM niematakiejtabeli");
-echo mysql_errno().": ".mysql_error()."<BR>";
+mysql_connect('localhost', 'uzytkownik', 'haslo');
+
+mysql_select_db('niematakiejbazy');
+echo mysql_errno() . ": " . mysql_error(). "\n";
+
+mysql_select_db('takiejbazytezniema');
+mysql_query('SELECT * FROM niematakiejtabeli');
+echo mysql_errno() . ": " . mysql_error() . "\n";
?>
]]>
</programlisting>
- </informalexample>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ </para>
+ <screen>
+<![CDATA[
+1049: Unknown database 'niematakiejbazy'
+1146: Table 'takiejbazytezniema.niematakiejtabeli' doesn't exist
+]]>
+ </screen>
+ </example>
</para>
<para>
Patrz tak�e: <function>mysql_error</function>
Index: phpdoc/pl/reference/mysql/functions/mysql-error.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-error.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-error.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-error.xml:1.3 Sat May 4 07:20:27
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-error.xml Sat May 4 16:30:51 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-error' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.5 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-error">
<refnamediv>
<refname>mysql_error</refname>
@@ -30,20 +28,32 @@
<function>mysql_error</function> i <function>mysql_errno</function>),
dlatego je�li jej u�ywasz, upewnij si�, by zrobi� to przed u�yciem
nast�pnej funkcji MySQL.
- <informalexample>
+ <example>
+ <title>Przyk�ad u�ycia mysql_error</title>
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("nieistniejacyserwer");
-echo mysql_errno().": ".mysql_error()."<BR>";
-mysql_select_db("niematakiejbazy");
-echo mysql_errno().": ".mysql_error()."<BR>";
-$conn = mysql_query("SELECT * FROM niematakiejtabeli");
-echo mysql_errno().": ".mysql_error()."<BR>";
+mysql_connect('localhost', 'uzytkownik', 'haslo');
+
+mysql_select_db('niematakiejbazy');
+echo mysql_errno() . ": " . mysql_error(). "\n";
+
+mysql_select_db('takiejbazytezniema');
+mysql_query('SELECT * FROM niematakiejtabeli');
+echo mysql_errno() . ": " . mysql_error() . "\n";
?>
]]>
</programlisting>
- </informalexample>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ </para>
+ <screen>
+<![CDATA[
+1049: Unknown database 'niematakiejbazy'
+1146: Table 'takiejbazytezniema.niematakiejtabeli' doesn't exist
+]]>
+ </screen>
+ </example>
</para>
<para>
Patrz tak�e: <function>mysql_errno</function>
Index: phpdoc/pl/reference/mysql/functions/mysql-escape-string.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-escape-string.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-escape-string.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-escape-string.xml:1.3 Sat May 4
07:20:27 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-escape-string.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-escape-string' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.62 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-escape-string">
<refnamediv>
<refname>mysql_escape_string</refname>
@@ -57,7 +55,9 @@
</example>
<para>
Patrz tak�e:
- <function>mysql_real_escape_string</function>
+ <function>mysql_real_escape_string</function>,
+ <function>addslashes</function> oraz dyrektywa
+ <link linkend="ini.magic-quotes-gpc">magic_quotes_gpc</link>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-fetch-array.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-fetch-array.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-fetch-array.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-fetch-array.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-fetch-array.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-fetch-array' in en/ tree in rev 1.27 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.27 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-fetch-array">
<refnamediv>
<refname>mysql_fetch_array</refname>
@@ -36,13 +34,14 @@
lub przez stworzenie aliasa. Po stworzeniu aliasa nie mo�na
ju� odwo�ywa� si� do danej kolumny u�ywaj�c jej prawdziwej nazwy
(w tym przyk�adzie u�ywaj�c <literal>'pole'</literal>).
- <informalexample>
+ <example>
+ <title>Zapytanie z powtarzaj�cymi si� nazwami p�l</title>
<programlisting role="sql">
<![CDATA[
-select tjeden.pole as cos tdwa.pole as cos2 from tjeden, tdwa
+select table1.field as foo table2.field as bar from table1, table2
]]>
</programlisting>
- </informalexample>
+ </example>
</para>
<para>
Godne uwagi jest to, �e u�ycie <function>mysql_fetch_array</function>
@@ -62,30 +61,68 @@
MYSQL_NUM indeksowanej tylko numerycznie (jak w
<function>mysql_fetch_row</function>).
</para>
- <para>
- Po dalsze szczeg�y patrz tak�e
- <function>mysql_fetch_row</function> i
- <function>mysql_fetch_assoc</function>.
- </para>
<example>
- <title><function>mysql_fetch_array</function></title>
+ <title>mysql_fetch_array z MYSQL_NUM</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+mysql_connect('localhost', 'uzytkownik', 'haslo') or
+ die('Nie mo�na si� po��czy�');
+mysql_select_db('baza');
+
+$result = mysql_query("SELECT id, nazwa FROM tabela");
+
+while (($row = mysql_fetch_array($result, MYSQL_NUM))
+ printf ("ID: %s Nazwa: %s", $row[0], $row[1]);
+
+mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
+ <example>
+ <title>mysql_fetch_array z MYSQL_ASSOC</title>
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("serwer","uzytkownik","haslo");
-mysql_select_db("baza");
-$result = mysql_query("select id_uzytkownika, pelna_nazwa from tabela");
-while ($row = mysql_fetch_array($result)) {
- echo "id_uzytkownika: ".$row["id_uzytkownika"]."<br>\n";
- echo "id_uzytkownika: ".$row[0]."<br>\n";
- echo "pelna_nazwa: ".$row["pelna_nazwa"]."<br>\n";
- echo "pelna_nazwa: ".$row[1]."<br>\n";
-}
+mysql_connect('localhost', 'uzytkownik', 'haslo') or
+ die('Nie mo�na si� po��czy�');
+mysql_select_db('baza');
+
+$result = mysql_query("SELECT id, nazwa FROM tabela");
+
+while (($row = mysql_fetch_array($result, MYSQL_ASSOC))
+ printf ("ID: %s Nazwa: %s", $row["id"], $row["nazwa"]);
+
mysql_free_result($result);
?>
]]>
</programlisting>
</example>
+ <example>
+ <title>mysql_fetch_array z MYSQL_BOTH</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+mysql_connect('localhost', 'uzytkownik', 'haslo') or
+ die('Nie mo�na si� po��czy�');
+mysql_select_db('baza');
+
+$result = mysql_query("SELECT id, nazwa FROM tabela");
+
+while (($row = mysql_fetch_array($result, MYSQL_BOTH))
+ printf ("ID: %s Nazwa: %s", $row[0], $row["nazwa"]);
+
+mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ Patrz tak�e:
+ <function>mysql_fetch_row</function>,
+ <function>mysql_fetch_assoc</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-fetch-assoc.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-fetch-assoc.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-fetch-assoc.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-fetch-assoc.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-fetch-assoc.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-fetch-assoc' in en/ tree in rev 1.45 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.45 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-fetch-assoc">
<refnamediv>
<refname>mysql_fetch_assoc</refname>
@@ -41,19 +39,14 @@
<emphasis>nie</emphasis> jest znacz�co wolniejsze od u�ycia
<function>mysql_fetch_row</function>, a jest bardziej funkcjonalne.
</para>
- <para>
- Po dalsze szczeg�y patrz tak�e
- <function>mysql_fetch_row</function> i
- <function>mysql_fetch_array</function>.
- </para>
<example>
<title><function>mysql_fetch_assoc</function></title>
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("serwer","uzytkownik","haslo");
-mysql_select_db("baza");
-$result = mysql_query("select * from tabela");
+mysql_connect('localhost','uzytkownik','haslo');
+mysql_select_db('baza');
+$result = mysql_query('select * from tabela');
while ($row = mysql_fetch_assoc($result)) {
echo $row["id_uzytkownika"];
echo $row["pelna_nazwa"];
@@ -63,6 +56,12 @@
]]>
</programlisting>
</example>
+ <para>
+ Patrz tak�e:
+ <function>mysql_fetch_row</function>,
+ <function>mysql_fetch_array</function> i
+ <function>mysql_query</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-fetch-field.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-fetch-field.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-fetch-field.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-fetch-field.xml:1.3 Sat May 4
07:20:27 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-fetch-field.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-fetch-field' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-fetch-field">
<refnamediv>
<refname>mysql_fetch_field</refname>
@@ -98,11 +96,11 @@
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("serwer","uzytkownik","haslo");
- or die ("Nie mo�na si� po��czy�");
-mysql_select_db("baza");
-$result = mysql_query("select * from tabela")
- or die("Zapytanie zako�czone niepowodzeniem");
+mysql_connect('localhost','uzytkownik','haslo');
+ or die ('Nie mo�na si� po��czy�');
+mysql_select_db('baza');
+$result = mysql_query('select * from tabela')
+ or die('Zapytanie zako�czone niepowodzeniem');
/* pobieramy dane kolumny */
$i = 0;
while ($i < mysql_num_fields($result)) {
Index: phpdoc/pl/reference/mysql/functions/mysql-fetch-lengths.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-fetch-lengths.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-fetch-lengths.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-fetch-lengths.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-fetch-lengths.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-fetch-lengths' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-fetch-lengths">
<refnamediv>
<refname>mysql_fetch_lengths</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-fetch-object.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-fetch-object.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-fetch-object.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-fetch-object.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-fetch-object.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-fetch-object' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-fetch-object">
<refnamediv>
<refname>mysql_fetch_object</refname>
@@ -49,9 +47,9 @@
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("serwer","uzytkownik","haslo");
+mysql_connect('localhost','uzytkownik','haslo');
mysql_select_db($db);
-$result = mysql_query("select * from tabela");
+$result = mysql_query('select * from tabela');
while ($row = mysql_fetch_object($result)) {
echo $row->id_uzytkownika;
echo $row->pelna_nazwa;
Index: phpdoc/pl/reference/mysql/functions/mysql-fetch-row.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-fetch-row.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-fetch-row.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-fetch-row.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-fetch-row.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-fetch-row' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-fetch-row">
<refnamediv>
<refname>mysql_fetch_row</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-field-flags.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-field-flags.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-field-flags.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-field-flags.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-field-flags.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-field-flags' in en/ tree in rev 1.17 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.17 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-field-flags">
<refnamediv>
<refname>mysql_field_flags</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-field-len.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-field-len.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-field-len.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-field-len.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-field-len.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-field-len' in en/ tree in rev 1.17 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.17 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-field-len">
<refnamediv>
<refname>mysql_field_len</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-field-name.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-field-name.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-field-name.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-field-name.xml:1.3 Sat May 4
07:20:28 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-field-name.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-field-name' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-field-name">
<refnamediv>
<refname>mysql_field_name</refname>
@@ -40,7 +38,7 @@
* nazwa_uzytkownika
* haslo
*/
-$link = mysql_connect('localhost', $uzytkownik, 'haslo');
+$link = mysql_connect('localhost', 'uzytkownik', 'haslo');
mysql_select_db($dbname, $link)
or die("Nie mo�na otworzy� bazy $dbname");
$res = mysql_query("select * from users", $link);
Index: phpdoc/pl/reference/mysql/functions/mysql-field-seek.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-field-seek.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-field-seek.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-field-seek.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-field-seek.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-field-seek' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-field-seek">
<refnamediv>
<refname>mysql_field_seek</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-field-table.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-field-table.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-field-table.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-field-table.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-field-table.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-field-table' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-field-table">
<refnamediv>
<refname>mysql_field_table</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-field-type.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-field-type.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-field-type.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-field-type.xml:1.3 Sat May 4
07:20:28 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-field-type.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-field-type' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-field-type">
<refnamediv>
<refname>mysql_field_type</refname>
@@ -28,32 +26,44 @@
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("serwer","uzytkownik","haslo");
-mysql_select_db("baza");
-$result = mysql_query("SELECT * FROM tabela");
+mysql_connect('localhost','uzytkownik','haslo');
+mysql_select_db('baza');
+$result = mysql_query('SELECT * FROM tabela');
$fields = mysql_num_fields($result);
$rows = mysql_num_rows($result);
-$i = 0;
-$table = mysql_field_table($result, $i);
-echo "Tabela '".$table."' ma ".$fields." p�l i ".$rows." wierszy <br />";
-echo "Tabela ma nast�puj�ce pola <br />";
-while ($i < $fields) {
+$table = mysql_field_table($result, 0);
+echo "Tabela '".$table."' ma ".$fields." p�l i ".$rows." wierszy\n";
+echo "Tabela ma nast�puj�ce pola:\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."<br />";
+ echo $type." ".$name." ".$len." ".$flags."\n";
$i++;
}
+mysql_free_result($result);
mysql_close();
-
?>
]]>
</programlisting>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ </para>
+ <screen>
+<![CDATA[
+Tabela 'tabela' ma 4 p�l i 1 wierszy
+Tabela ma nast�puj�ce pola:
+string name 64 not_null primary_key binary
+int ret 1 not_null
+string dl 128 not_null
+string type 9 not_null enum
+]]>
+ </screen>
</example>
</para>
- <para>
- Aby zachowa� zgodno�� z poprzednimi wersjami, mo�na u�y� r�wnie�
+ <para>
+ Aby zachowa� zgodno�� z poprzednimi wersjami, mo�na u�y� r�wnie�
<function>mysql_fieldtype</function>. Jest to jednak niezalecane.
</para>
</refsect1>
Index: phpdoc/pl/reference/mysql/functions/mysql-free-result.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-free-result.xml:1.1
phpdoc/pl/reference/mysql/functions/mysql-free-result.xml:1.2
--- phpdoc/pl/reference/mysql/functions/mysql-free-result.xml:1.1 Sun Apr 14
21:39:30 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-free-result.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-free-result' in en/ tree in rev 1.102 -->
-<!-- EN-Revision: 0.0 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.102 -->
+<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.2 $ -->
<refentry id="function.mysql-free-result">
<refnamediv>
<refname>mysql_free_result</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-get-client-info.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-get-client-info.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-get-client-info.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-get-client-info.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-get-client-info.xml Sat May 4
+16:30:51 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-get-client-info' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.62 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-get-client-info">
<refnamediv>
<refname>mysql_get_client_info</refname>
@@ -18,8 +16,28 @@
<function>mysql_get_client_info</function> zwraca ci�g znak�w
zawieraj�cy wersj� bibliotek klienta MySQL.
</para>
+ <example>
+ <title>mysql_get_client_info</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+printf ("MySQL client info: %s\n", mysql_get_client_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ </para>
+ <screen>
+<![CDATA[
+MySQL client info: 3.23.39
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_client_info</function> dodano w PHP 4.0.5.
+ Patrz tak�e: <function>mysql_get_host_info</function>,
+ <function>mysql_get_proto_info</function> i
+ <function>mysql_get_server_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-get-host-info.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-get-host-info.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-get-host-info.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-get-host-info.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-get-host-info.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-get-host-info' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.62 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-get-host-info">
<refnamediv>
<refname>mysql_get_host_info</refname>
@@ -22,8 +20,30 @@
<parameter>identyfikator_po��czenia</parameter> nie zostanie podany,
wykorzystane zostanie ostatnio otwarte po��czenie.
</para>
+ <example>
+ <title>mysql_get_host_info</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+mysql_connect('localhost', 'uzytkownik', 'haslo') or
+ die('Nie mo�na si� po��czy�');
+printf ("MySQL host info: %s\n", mysql_get_host_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ </para>
+ <screen>
+<![CDATA[
+MySQL host info: Localhost via UNIX socket
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_host_info</function> dodano w PHP 4.0.5.
+ Patrz tak�e: <function>mysql_get_client_info</function>,
+ <function>mysql_get_proto_info</function> i
+ <function>mysql_get_server_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-get-proto-info.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-get-proto-info.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-get-proto-info.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-get-proto-info.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-get-proto-info.xml Sat May 4
+16:30:51 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-get-proto-info' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.62 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-get-proto-info">
<refnamediv>
<refname>mysql_get_proto_info</refname>
@@ -21,8 +19,30 @@
<parameter>identyfikator_po��czenia</parameter> nie zostanie podany,
wykorzystane zostanie ostatnio otwarte po��czenie.
</para>
+ <example>
+ <title>mysql_get_proto_info</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+mysql_connect('localhost', 'uzytkownik', 'haslo') or
+ die('Nie mo�na si� po��czy�');
+printf ("MySQL protocol version: %s\n", mysql_get_proto_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ </para>
+ <screen>
+<![CDATA[
+MySQL protocol version : 10
+]]>
+ </screen>
+ </example>
<para>
- <function>mysql_get_proto_info</function> dodano w PHP 4.0.5.
+ Patrz tak�e: <function>mysql_get_client_info</function>,
+ <function>mysql_get_host_info</function> i
+ <function>mysql_get_server_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-get-server-info.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-get-server-info.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-get-server-info.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-get-server-info.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-get-server-info.xml Sat May 4
+16:30:51 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.25 -->
-<!-- last change to 'mysql-get-server-info' in en/ tree in rev 1.96 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.96 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-get-server-info">
<refnamediv>
<refname>mysql_get_server_info</refname>
@@ -23,6 +21,31 @@
</para>
<para>
<function>mysql_get_server_info</function> dodano w PHP 4.0.5.
+ </para>
+ <example>
+ <title>mysql_get_server_info</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+mysql_connect('localhost', 'uzytkownik', 'haslo') or
+ die('Nie mo�na si� po��czy�');
+printf ("MySQL server version: %s\n", mysql_get_server_info());
+?>
+]]>
+ </programlisting>
+ <para>
+ Powy�szy przyk�ad da nast�puj�cy wynik:
+ </para>
+ <screen>
+<![CDATA[
+MySQL server version: 4.0.1-alpha
+]]>
+ </screen>
+ </example>
+ <para>
+ Patrz tak�e: <function>mysql_get_client_info</function>,
+ <function>mysql_get_host_info</function> i
+ <function>mysql_get_proto_info</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-insert-id.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-insert-id.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-insert-id.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-insert-id.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-insert-id.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-insert-id' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-insert-id">
<refnamediv>
<refname>mysql_insert_id</refname>
@@ -50,6 +48,24 @@
<literal>LAST_INSERT_ID()</literal>.
</para>
</warning>
+ <example>
+ <title>Przyk�ad u�ycia mysql_insert_id</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ mysql_connect('localhost', 'uzytkownik', 'haslo') or
+ die('Nie mo�na si� po��czy�');
+ mysql_select_db('baza');
+
+ mysql_query("INSERT INTO mytable (product) values ('kossu')");
+ printf ("Ostatnio dodany rekord ma id %d\n", mysql_insert_id());
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ Patrz tak�e: <function>mysql_query</function>.
+ </para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-list-dbs.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-list-dbs.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-list-dbs.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-list-dbs.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-list-dbs.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-list-dbs' in en/ tree in rev 1.16 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.16 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-list-dbs">
<refnamediv>
<refname>mysql_list_dbs</refname>
@@ -31,7 +29,7 @@
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect ("serwer","uzytkownik","haslo");
+$link = mysql_connect ('localhost','uzytkownik','haslo');
$db_list = mysql_list_dbs($link);
while ($row = mysql_fetch_object($db_list)) {
Index: phpdoc/pl/reference/mysql/functions/mysql-list-fields.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-list-fields.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-list-fields.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-list-fields.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-list-fields.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-list-fields' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-list-fields">
<refnamediv>
<refname>mysql_list_fields</refname>
@@ -33,9 +31,9 @@
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect ("serwer","uzytkownik","haslo");
+$link = mysql_connect ('localhost','uzytkownik','haslo');
-$fields = mysql_list_fields("baza", "tabela", $link);
+$fields = mysql_list_fields('baza', 'tabela', $link);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
Index: phpdoc/pl/reference/mysql/functions/mysql-list-processes.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-list-processes.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-list-processes.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-list-processes.xml:1.3 Sat May 4
07:20:28 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-list-processes.xml Sat May 4
+16:30:51 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.25 -->
-<!-- last change to 'mysql-list-processes' in en/ tree in rev 1.96 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.96 -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-list-processes">
<refnamediv>
<refname>mysql_list_processes</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-list-tables.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-list-tables.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-list-tables.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-list-tables.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-list-tables.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-list-tables' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-list-tables">
<refnamediv>
<refname>mysql_list_tables</refname>
@@ -20,7 +18,7 @@
<para>
<function>mysql_list_tables</function> przyjmuje jako argument
nazw� bazy i zwraca wska�nik wyniku podobnie jak funkcja
- <function>mysql_db_query</function>. �eby uzyska� nazwy tabel
+ <function>mysql_query</function>. �eby uzyska� nazwy tabel
za wska�nika wyniku nale�y u�y� funkcji
<function>mysql_tablename</function> lub innej operuj�cej na
tablicach wynik�w.
@@ -28,6 +26,29 @@
<para>
Aby zachowa� zgodno�� z poprzednimi wersjami, mo�na u�y� r�wnie�
<function>mysql_listtables</function>. Jest to jednak niezalecane.
+ </para>
+ <example>
+ <title>Przyk�ad u�ycia mysql_list_tables</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+mysql_connect('localhost', 'uzytkownik', 'haslo') or
+ die('Nie mo�na si� po��czy�');
+mysql_select_db('baza');
+
+$result = mysql_list_tables();
+
+while (($row = mysql_fetch_row($result))
+ printf ("Tabela: %s\n", $row[0]);
+
+mysql_free_result($result);
+?>
+]]>
+ </programlisting>
+ </example>
+ <para>
+ Patrz tak�e: <function>mysql_list_dbs</function>,
+ <function>mysql_tablename</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-num-fields.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-num-fields.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-num-fields.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-num-fields.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-num-fields.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-num-fields' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-num-fields">
<refnamediv>
<refname>mysql_num_fields</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-num-rows.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-num-rows.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-num-rows.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-num-rows.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-num-rows.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-num-rows' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-num-rows">
<refnamediv>
<refname>mysql_num_rows</refname>
@@ -24,10 +22,10 @@
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect ("serwer","uzytkownik","haslo");
-mysql_select_db("baza", $link);
+$link = mysql_connect ('serwer','uzytkownik','haslo');
+mysql_select_db('baza', $link);
-$result = mysql_query("SELECT * FROM tabela", $link);
+$result = mysql_query('SELECT * FROM tabela', $link);
$num_rows = mysql_num_rows($result);
echo "$num_rows wierszy\n";
@@ -36,10 +34,18 @@
</programlisting>
</example>
</para>
+ <note>
+ <para>
+ Je�li funkcja <function>mysql_num_rows</function> jest u�ywana w
+ po��czeniu z <function>mysql_unbuffered_query</function>, poprawna
+ warto�� zostanie zwr�cona dopiero po odebraniu wszystkich wierszy wyniku.
+ </para>
+ </note>
<para>
Patrz tak�e:
<function>mysql_affected_rows</function>,
<function>mysql_connect</function>,
+ <function>mysql_data_seek</function>,
<function>mysql_select_db</function> i
<function>mysql_query</function>.
</para>
Index: phpdoc/pl/reference/mysql/functions/mysql-pconnect.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-pconnect.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-pconnect.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-pconnect.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-pconnect.xml Sat May 4 16:30:51
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-pconnect' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-pconnect">
<refnamediv>
<refname>mysql_pconnect</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-ping.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-ping.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-ping.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-ping.xml:1.3 Sat May 4 07:20:28
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-ping.xml Sat May 4 16:30:52 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.25 -->
-<!-- last change to 'mysql-ping' in en/ tree in rev 1.100 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.100 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-ping">
<refnamediv>
<refname>mysql_ping</refname>
@@ -27,8 +25,8 @@
</para>
<para>
Patrz tak�e:
- <function>mysql_thread_id</function>
- <function>mysql_list_processes</function>
+ <function>mysql_thread_id</function>,
+ <function>mysql_list_processes</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-query.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-query.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-query.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-query.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-query.xml Sat May 4 16:30:52 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-query' in en/ tree in rev 1.62 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.62 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-query">
<refnamediv>
<refname>mysql_query</refname>
@@ -14,6 +12,7 @@
<type>resource</type><methodname>mysql_query</methodname>
<methodparam><type>string</type><parameter>zapytanie</parameter></methodparam>
<methodparam
choice="opt"><type>resource</type><parameter>identyfikator_po��czenia</parameter></methodparam>
+ <methodparam
+choice="opt"><type>int</type><parameter>typ_wyniku</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_query</function> wysy�a zapytanie do aktywnej
@@ -23,9 +22,15 @@
po��czenie nie jest otwarte, podj�ta zostanie pr�ba ustanowienia
go, poprzez wywo�anie <function>mysql_connect</function> bez argument�w.
</para>
+ <para>
+ Opcjonalny argument <parameter>result_mode</parameter> mo�e przyjmowa�
+ warto�� MYSQL_USE_RESULT lub MYSQL_STORE_RESULT. Domy�lnie u�ywana jest
+ warto�� MYSQL_STORE_RESULT, zatem wynik jest buforowany. Odpowiednikiem
+ u�ycia drugiej opcji jest funkcja <function>mysql_unbuffered_query</function>.
+ </para>
<note>
<para>
- Zapytanie nie powinno ko�czy� si� znakiem �rednika.
+ Zapytanie nie powinno ko�czy� si� znakiem �rednika.
</para>
</note>
<para>
Index: phpdoc/pl/reference/mysql/functions/mysql-real-escape-string.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-real-escape-string.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-real-escape-string.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-real-escape-string.xml:1.3 Sat
May 4 07:20:28 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-real-escape-string.xml Sat May 4
+16:30:52 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.25 -->
-<!-- last change to 'mysql-real-escape-string' in en/ tree in rev 1.100 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.100 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-real-escape-string">
<refnamediv>
<refname>mysql_real_escape_string</refname>
@@ -53,8 +51,8 @@
</example>
<para>
Patrz tak�e:
- <function>mysql_escape_string</function>
- <function>mysql_character_set_name</function>
+ <function>mysql_escape_string</function>,
+ <function>mysql_character_set_name</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-result.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-result.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-result.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-result.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-result.xml Sat May 4 16:30:52
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-result' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-result">
<refnamediv>
<refname>mysql_result</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-select-db.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-select-db.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-select-db.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-select-db.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-select-db.xml Sat May 4 16:30:52
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-select-db' in en/ tree in rev 1.2 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-select-db">
<refnamediv>
<refname>mysql_select_db</refname>
Index: phpdoc/pl/reference/mysql/functions/mysql-stat.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-stat.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-stat.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-stat.xml:1.2 Wed Apr 17 03:16:12
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-stat.xml Sat May 4 16:30:52 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-stat' in en/ tree in rev 1.62 -->
<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.62 -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-stat">
<refnamediv>
<refname>mysql_stat</refname>
@@ -31,7 +29,7 @@
<programlisting role="php">
<![CDATA[
<?php
-$link = mysql_connect('localhost', 'u�ytkownik', 'has�o');
+$link = mysql_connect('localhost', 'uzytkownik', 'haslo');
printf("%s\n", mysql_stat($link));
?>
]]>
Index: phpdoc/pl/reference/mysql/functions/mysql-tablename.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-tablename.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-tablename.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-tablename.xml:1.3 Sat May 4 07:20:28
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-tablename.xml Sat May 4 16:30:52
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-tablename' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.4 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-tablename">
<refnamediv>
<refname>mysql_tablename</refname>
@@ -25,17 +23,20 @@
<programlisting role="php">
<![CDATA[
<?php
-mysql_connect("serwer");
-$result = mysql_list_tables("baza");
-$i = 0;
-for ($i = 0; $i < mysql_num_rows($result); $i++) {
- $tb_names[$i] = mysql_tablename($result, $i);
- echo $tb_names[$i] . "<br />";
-}
+mysql_connect('localhost', 'uzytkownik', 'haslo');
+$result = mysql_list_tables('baza');
+
+for ($i = 0; $i < mysql_num_rows($result); $i++)
+ printf ("Tabela: %s\n", mysql_tablename($result, $i));
+
+mysql_free_result($result);
?>
]]>
</programlisting>
</example>
+ </para>
+ <para>
+ Patrz tak�e: <function>mysql_list_tables</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-thread-id.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-thread-id.xml:1.3
phpdoc/pl/reference/mysql/functions/mysql-thread-id.xml:1.4
--- phpdoc/pl/reference/mysql/functions/mysql-thread-id.xml:1.3 Sat May 4 07:20:28
2002
+++ phpdoc/pl/reference/mysql/functions/mysql-thread-id.xml Sat May 4 16:30:52
+2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.25 -->
-<!-- last change to 'mysql-thread-id' in en/ tree in rev 1.100 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.100 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.4 $ -->
<refentry id="function.mysql-thread-id">
<refnamediv>
<refname>mysql_thread_id</refname>
@@ -45,8 +43,8 @@
</example>
<para>
Patrz tak�e:
- <function>mysql_ping</function>
- <function>mysql_list_processes</function>
+ <function>mysql_ping</function>,
+ <function>mysql_list_processes</function>.
</para>
</refsect1>
</refentry>
Index: phpdoc/pl/reference/mysql/functions/mysql-unbuffered-query.xml
diff -u phpdoc/pl/reference/mysql/functions/mysql-unbuffered-query.xml:1.2
phpdoc/pl/reference/mysql/functions/mysql-unbuffered-query.xml:1.3
--- phpdoc/pl/reference/mysql/functions/mysql-unbuffered-query.xml:1.2 Wed Apr 17
03:16:12 2002
+++ phpdoc/pl/reference/mysql/functions/mysql-unbuffered-query.xml Sat May 4
+16:30:52 2002
@@ -1,8 +1,6 @@
<?xml version="1.0" encoding="iso-8859-2"?>
-<!-- splitted from ./pl/functions/mysql.xml, last change in rev 1.16 -->
-<!-- last change to 'mysql-unbuffered-query' in en/ tree in rev 1.2 -->
-<!-- EN-Revision: 1.2 Maintainer: slawek Status: ready -->
-<!-- OLD-Revision: 1.100/EN.1.2 -->
+<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
+<!-- $Revision: 1.3 $ -->
<refentry id="function.mysql-unbuffered-query">
<refnamediv>
<refname>mysql_unbuffered_query</refname>
@@ -17,6 +15,7 @@
<type>resource</type><methodname>mysql_unbuffered_query</methodname>
<methodparam><type>string</type><parameter>zapytanie</parameter></methodparam>
<methodparam
choice="opt"><type>resource</type><parameter>identyfikator_po��czenia</parameter></methodparam>
+ <methodparam
+choice="opt"><type>int</type><parameter>typ_wyniku</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_unbuffered_query</function> wysy�a
@@ -26,8 +25,14 @@
generuj� du�e wyniki. Po drugie, mo�na pracowa� na zbiorze wynikowym
ju� po odebraniu od bazy pierwszego wiersza. Nie trzeba czeka�, a�
zako�czy si� dzia�anie zapytania. Przy pracy z kilkoma po��czeniami do
- bazy, nale�y doda� opcjonalny parametr
+ bazy, nale�y doda� opcjonalny argument
<parameter>identyfikator_po��czenia</parameter>.
+ </para>
+ <para>
+ Opcjonalny argument <parameter>result_mode</parameter> mo�e przyjmowa�
+ warto�� MYSQL_USE_RESULT lub MYSQL_STORE_RESULT. Domy�lnie u�ywana jest
+ warto�� MYSQL_USE_RESULT, zatem wynik nie jest buforowany. Odpowiednikiem
+ u�ycia drugiej opcji jest funkcja <function>mysql_query</function>.
</para>
<note>
<para>
Index: phpdoc/pl/reference/mysql/functions/mysql-info.xml
+++ phpdoc/pl/reference/mysql/functions/mysql-info.xml
<?xml version="1.0" encoding="iso-8859-2"?>
<!-- EN-Revision: 1.3 Maintainer: slawek Status: ready -->
<!-- $Revision: 1.1 $ -->
<refentry id="function.mysql-info">
<refnamediv>
<refname>mysql_info</refname>
<refpurpose>
Pobiera informacje o ostatnim zapytaniu
</refpurpose>
</refnamediv>
<refsect1>
<title>Opis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_info</methodname>
<methodparam choice="opt"><type>resource</type><parameter>
identyfikator_po��czenia
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_info</function> zwraca szczeg�owe informacje o ostatnim
zapytaniu wykonanym przy u�yciu podanego
<parameter>identyfikatora_po��czenia</parameter>.
Je�li <parameter>identyfikator_po��czenia</parameter> nie zostanie podany,
domy�lnie przyjmowane jest ostatnio otwarte po��czenie.
</para>
<para>
<function>mysql_info</function> zwraca warto�� typu <type>string</type>
dla polece� wymienionych poni�ej. Dla wszystkich innych zwracana jest
warto�� &false;. Format zwracanej warto�ci zale�y od polecenia.
<example>
<title>Formaty zwracanych warto�ci</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>
Podane warto�ci s� jedynie przyk�adowe. B�d� one r�ne, w zale�no�ci od
zapytania.
</para>
<note>
<para>
Dla polece� typu INSERT ... VALUES, <function>mysql_info</function>
zwraca warto�� r�n� od &false;, tylko je�li w zapytaniu podanych
zosta�o kilka warto�ci.
</para>
</note>
<para>
Patrz tak�e: <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
-->
