costra Tue Feb 26 15:53:02 2002 EDT
Added files:
/phpdoc/cs/functions mysql.xml
Log:
Zatim prelozene vicemene jen refpurpose
Index: phpdoc/cs/functions/mysql.xml
+++ phpdoc/cs/functions/mysql.xml
<?xml version="1.0" encoding="iso-8859-2"?>
<!-- $Revision: 1.1 $ -->
<reference id="ref.mysql">
<title>MySQL Funkce</title>
<titleabbrev>MySQL</titleabbrev>
<partintro>
<simpara>
Tyto funkce zprost�edkov�vaj� p��stup na MySQL datab�zov� server.
Maj�-li b�t tyto funkce dostupn�, mus� b�t PHP zkompilov�no s
podporou MySQL parametrem <option role="configure">--with-mysql</option>.
Pokud pou�ijete tento parametr bez zadan� cesty k MySQL, PHP pou�ije
vestav�n�
MySQL klient knihovny. U�ivatel�, kte�� spou�t� dal�� aplikace pou��vaj�c�
MySQL (nap�.: spu�t�n� PHP3 a PHP4 jako vz�jemn� moduly v apache �i
auth-mysql)
by m�li v�dy zadat cestu k MySQL:
<option role="configure">--with-mysql=/cesta/k/mysql</option>.
PHP tak pou�ije klientsk� knihovny instalovan� MySQL, ��m� se vyvarujete
mo�n�m
konflikt�m.
</simpara>
<simpara>
V�ce informac� o MySQL naleznete na <ulink
url="&url.mysql;">&url.mysql;</ulink>.
</simpara>
<simpara>
Dokumentace k MySQL je na <ulink
url="&url.mysql.docs;">&url.mysql.docs;</ulink>.
</simpara>
<para>
Chov�n� funkc� MySQL je ovlivn�no nastaven�m v glob�ln�m
<link linkend="configuration">konfihura�n�m</link> souboru.
<table>
<title><link linkend="ini.sect.mysql">Konfigurace MySQL</link>
Volby</title>
<tgroup cols="3">
<thead>
<row>
<entry>Jm�no</entry>
<entry>V�choz�</entry>
<entry>Zm�niteln�</entry>
</row>
</thead>
<tbody>
<row>
<entry>mysql.allow_persistent</entry>
<entry>"On"</entry>
<entry>PHP_INI_SYSTEM</entry>
</row>
<row>
<entry>mysql.max_persistent</entry>
<entry>"-1"</entry>
<entry>PHP_INI_SYSTEM</entry>
</row>
<row>
<entry>mysql.max_links</entry>
<entry>"-1"</entry>
<entry>PHP_INI_SYSTEM</entry>
</row>
<row>
<entry>mysql.default_port</entry>
<entry>NULL</entry>
<entry>PHP_INI_ALL</entry>
</row>
<row>
<entry>mysql.default_socket</entry>
<entry>NULL</entry>
<entry>PHP_INI_ALL</entry>
</row>
<row>
<entry>mysql.default_host</entry>
<entry>NULL</entry>
<entry>PHP_INI_ALL</entry>
</row>
<row>
<entry>mysql.default_user</entry>
<entry>NULL</entry>
<entry>PHP_INI_ALL</entry>
</row>
</tbody>
</tgroup>
</table>
Podrobn� popis a definice konstant PHP_INI_* naleznete v
<function>ini_set</function>.
</para>
<para>
Toto je jednoduch� uk�zkov� p��klad jak se p�ipojit, prov�st dotaz,
zobrazit v�sledn� ��dky a odpojit se z MySQL datab�ze.
<example>
<title>MySQL extension overview example</title>
<programlisting role="php">
<![CDATA[
<?php
// P�ipojen�, v�b�r datab�ze
$link = mysql_connect("mysql_host", "mysql_login", "mysql_heslo")
or die("Nelze se p�ipojit");
print "Connected successfully";
mysql_select_db("moje_databaze")
or die("Nelze vybrat datab�zi");
// P��prava SQL dotazu
$query = "SELECT * FROM moje_tabulka";
$result = mysql_query($query)
or die("Dotaz nelze prov�st");
// Zobrazen� v�sledku v HTML
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
}
print "</table>\n";
// Odpojen� z MySQL datab�ze
mysql_close($link);
?>
]]>
</programlisting>
</example>
</para>
</partintro>
<refentry id="function.mysql-affected-rows">
<refnamediv>
<refname>mysql_affected_rows</refname>
<refpurpose>Vr�t� po�et ovlivn�n�ch (zm�n�n�ch) z�znam� v MySQL
po posledn�m dotazu</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_affected_rows</methodname>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_affected_rows</function> vr�t� po�et z�znam�
ovlivn�n�ch posledn�m pou�it�m dotazu INSERT, UPDATE nebo DELETE,
kter�mu odpov�d� <parameter>identifikator_spojeni</parameter>.
Nen�-li identifik�tor spojen� nen� uveden, pou�ije se posledn�
spojen� otev�en� pomoc� <function>mysql_connect</function>.
</para>
<note>
<para>
Pou��v�te-li transakce, je nutn� <function>mysql_affected_rows</function>
volat a� po dotazu INSERT, UPDATE nebo DELETE, nikoli hned po commitnut�.
</para>
</note>
<para>
Byl-li posledn� dotaz DELETE bez ��sti WHERE, budou sm�zany v�echny
z�znamy z tabulky, ale tato funce vr�t� nulu.
</para>
<note>
<para>
P�i pou�it� UPDATE, MySQL neulo�� sloupce, ve kter�ch je nov�
hodnota shodn� s p�vodn�. Toto m��e zp�sobit, �e
<function>mysql_affected_rows</function> nemus� v�dy p�esn�
souhlasit se skute�n�m po�tem ovlivn�n�ch ��dk�.
</para>
</note>
<para>
<function>mysql_affected_rows</function> nelze pou��t s dotazy SELECT,
ale jen s takov�mi, kter� m�n� z�znamy. K zji�t�n� po�tu ��dk� vr�cen�ch
dotazem SELECT pou�ijte funkci <function>mysql_num_rows</function>.
</para>
<para>
Je-li posledn� dotaz chybn�, funkce vr�t� -1.
</para>
<para>
Viz. tak�: <function>mysql_num_rows</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-change-user">
<refnamediv>
<refname>mysql_change_user</refname>
<refpurpose>
Zm�n� p�ihl�en�ho u�ivatele v sou�asn�m spojen�
</refpurpose>
</refnamediv>
<refsect1>
<title>Charakteristika</title>
<methodsynopsis>
<type>int</type><methodname>mysql_change_user</methodname>
<methodparam><type>string</type><parameter>uzivatel</parameter></methodparam>
<methodparam><type>string</type><parameter>heslo</parameter></methodparam>
<methodparam choice="opt"><type>string</type><parameter>
databaze
</parameter></methodparam>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_change_user</function> zm�n� p�ihl�en�ho u�ivatele
sou�asn�ho aktivn�ho spojen� nebo spojen� definovan� nepovinn�m parametrem
<parameter>identifikator_spojeni</parameter>. Je-li uveden parameter
<parameter>databaze</parameter> nastav� se tato datab�ze jako v�choz�,
v opa�n�m p��pad� z�stane aktivn� sou�asn� datab�ze definovan� ve zm�n�n�m
spojen�.
</para>
<!-- what is returned? bool -> succes/failure i suppose? -->
<!-- in PHP 3 int and in PHP 4 bool -->
<note>
<para>
Tato funkce byla p�id�na v PHP 3.0.13 a vy�aduje pou�it� MySQL
3.23.3 nebo vy���.
</para>
</note>
</refsect1>
</refentry>
<refentry id="function.mysql-close">
<refnamediv>
<refname>mysql_close</refname>
<refpurpose>Ukon�� (zav�e) MySQL spojen�</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>bool</type><methodname>mysql_close</methodname>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
&return.success;
</para>
<para> <function>mysql_close</function> uzav�e spojen� s MySQL
serverem, kter� je asociov�no se ur�it�m identik�torem spojen�
Pokud <parameter>identifikator_spojeni</parameter> nen� zad�n
uzav�e posledn� otev�en� spojen�.
</para>
<para>
Pou�it� <function>mysql_close</function> nen� obvykle nutn�,
proto�e nepersistentn� (netrval�) otev�en� spojen� jsou zav�ena
automaticky po zpracov�n� scriptu. D�le viz.
<link linkend="language.types.resource.self-destruct">freeing
resources</link>.
</para>
<note>
<para>
<function>mysql_close</function> neuzav�e persistentn� spojen�
otev�en� pomoc� <function>mysql_pconnect</function>.
</para>
</note>
<example>
<title>P��klad k MySQL close</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect("kraemer", "marliesle", "tajne")
or exit("Nelze se p�ipojit");
print ("Spojen� nav�z�no");
mysql_close($link);
?>
]]>
</programlisting>
</example>
<para>
Viz. tak�: <function>mysql_connect</function>, a
<function>mysql_pconnect</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-connect">
<refnamediv>
<refname>mysql_connect</refname>
<refpurpose>Vytvo�� spojen� s MySQL Serverem</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>zdroj</type><methodname>mysql_connect</methodname>
<methodparam choice="opt"><type>string</type><parameter>
server
</parameter></methodparam>
<methodparam choice="opt"><type>string</type><parameter>
username
</parameter></methodparam>
<methodparam choice="opt"><type>string</type><parameter>
password
</parameter></methodparam>
</methodsynopsis>
<para>
Returns a MySQL link identifier on success, or &false; on failure.
</para>
<para>
<function>mysql_connect</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>
<para>
Support for ":port" was added in PHP 3.0B4.
</para>
<para>
Support for ":/path/to/socket" was added in
PHP 3.0.10.
</para>
<para>
You can suppress the error message on failure by prepending '@'
to the function name.
</para>
</note>
</para>
<para>
If a second call is made to <function>mysql_connect</function>
with the same arguments, no new link will be established, but
instead, the link identifier of the already opened link will be
returned.
</para>
<para>
The link to the server will be closed as soon as the execution of
the script ends, unless it's closed earlier by explicitly calling
<function>mysql_close</function>.
</para>
<example>
<title>MySQL connect example</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect("localhost", "username", "secret")
or die("Nelze se p�ipojit");
print ("Connected successfully");
mysql_close($link);
?>
]]>
</programlisting>
</example>
<para> Viz. tak�
<function>mysql_pconnect</function> and
<function>mysql_close</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-create-db">
<refnamediv>
<refname>mysql_create_db</refname>
<refpurpose>Vytvo�� MySQL datab�zi</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>bool</type><methodname>mysql_create_db</methodname>
<methodparam><type>string</type><parameter>database
name</parameter></methodparam>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_create_db</function> attempts to create a new
database on the server associated with the specified link
identifier.
</para>
<para>
&return.success;
</para>
<example>
<title>MySQL create database example</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_pconnect("kron", "jutta", "geheim")
or exit("Nelze se p�ipojit");
if (mysql_create_db("my_db")) {
print ("Database created successfully\n");
} else {
printf ("Error creating database: %s\n", mysql_error ());
}
?>
]]>
</programlisting>
</example>
<para>
For downwards compatibility <function>mysql_createdb</function>
can also be used. This is deprecated, however.
</para>
<para>
Viz. tak�: <function>mysql_drop_db</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-data-seek">
<refnamediv>
<refname>mysql_data_seek</refname>
<refpurpose>P�esune ukazatel na aktu�ln� z�znam</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>bool</type><methodname>mysql_data_seek</methodname>
<methodparam><type>zdroj</type><parameter>result_identifier</parameter></method
param>
<methodparam><type>int</type><parameter>row_number</parameter></methodparam>
</methodsynopsis>
<para>
&return.success;
</para>
<para>
<function>mysql_data_seek</function> moves the internal row
pointer of the MySQL result associated with the specified result
identifier to point to the specified row number. The next call
to <function>mysql_fetch_row</function> would return that row.
</para>
<para>
<parameter>Row_number</parameter> starts at 0.
</para>
<example>
<title>MySQL data seek example</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_pconnect("kron", "jutta", "geheim")
or die("Nelze se p�ipojit");
mysql_select_db("samp_db")
or exit("Could not select database");
$query = "SELECT last_name, first_name FROM friends";
$result = mysql_query($query)
or die("Query failed");
// fetch rows in reverse order
for ($i = mysql_num_rows($result) - 1; $i >=0; $i--) {
if (!mysql_data_seek($result, $i)) {
echo "Cannot seek to row $i\n";
continue;
}
if(!($row = mysql_fetch_object($result)))
continue;
echo "$row->last_name $row->first_name<br />\n";
}
mysql_free_result($result);
?>
]]>
</programlisting>
</example>
</refsect1>
</refentry>
<refentry id="function.mysql-db-name">
<refnamediv>
<refname>mysql_db_name</refname>
<refpurpose>Vr�t� seznam v�ech datab�z�</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_db_name</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>row</parameter></methodparam>
<methodparam choice="opt"><type>mixed</type><parameter>
field
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_db_name</function> takes as its first parameter
the result pointer from a call to
<function>mysql_list_dbs</function>. The
<parameter>row</parameter> parameter is an index into the result
set.
</para>
<para>
If an error occurs, &false; is returned. Use
<function>mysql_errno</function> and
<function>mysql_error</function> to determine the nature of the
error.
</para>
<example>
<title><function>mysql_db_name</function> example</title>
<programlisting role="php">
<![CDATA[
<?php
error_reporting(E_ALL);
mysql_connect('dbhost', 'username', 'password');
$db_list = mysql_list_dbs();
$i = 0;
$cnt = mysql_num_rows($db_list);
while ($i < $cnt) {
echo mysql_db_name($db_list, $i) . "\n";
$i++;
}
?>
]]>
</programlisting>
</example>
<para>
For backward compatibility, <function>mysql_dbname</function> is
also accepted. This is deprecated, however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-db-query">
<refnamediv>
<refname>mysql_db_query</refname>
<refpurpose>Provede MySQL dotaz</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>zdroj</type><methodname>mysql_db_query</methodname>
<methodparam><type>string</type><parameter>database</parameter></methodparam>
<methodparam><type>string</type><parameter>query</parameter></methodparam>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
Returns a positive MySQL result resource to the query result,
or &false; on error.
</para>
<para>
<function>mysql_db_query</function> selects a database and
executes a query on it. If the optional link identifier isn't
specified, the function will try to find an open link to the
MySQL server and if no such link is found it'll try to create one
as if <function>mysql_connect</function> was called with no
arguments
</para>
<para>
Viz. tak� <function>mysql_connect</function> and
<function>mysql_query</function>.
</para>
<para>
<note>
<simpara>
This function has been deprecated since PHP 4.0.6.
Do not use this function. Use <function>mysql_select_db</function>
and <function>mysql_query</function> instead.
</simpara>
</note>
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-drop-db">
<refnamediv>
<refname>mysql_drop_db</refname>
<refpurpose>Vyma�e (odstran�) MySQL datab�zi</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>bool</type><methodname>mysql_drop_db</methodname>
<methodparam><type>string</type><parameter>database_name</parameter></methodpar
am>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
&return.success;
</para>
<para>
<function>mysql_drop_db</function> attempts to drop (remove) an
entire database from the server associated with the specified
link identifier.
</para>
<para>
For downward compatibility <function>mysql_dropdb</function>
can also be used. This is deprecated, however.
</para>
<para>
Viz. tak�: <function>mysql_create_db</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-errno">
<refnamediv>
<refname>mysql_errno</refname>
<refpurpose>
Vr�t� ��slenou hodnotu chybov� zpr�vy p�edchoz�ho MySQL p��kazu.
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_errno</methodname>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
Returns the error number from the last MySQL function, or
<literal>0</literal> (zero) if no error occurred.
</para>
<para>
Errors coming back from the MySQL database backend no longer
issue warnings. Instead, use <function>mysql_errno</function> to
retrieve the error code. Note that this function only returns the
error code from the most recently executed MySQL function (not
including <function>mysql_error</function> and
<function>mysql_errno</function>), so if you want to use it,
make sure you check the value before calling another mySQL
function.
<informalexample>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect("marliesle");
echo mysql_errno().": ".mysql_error()."<BR>";
mysql_select_db("nonexistentdb");
echo mysql_errno().": ".mysql_error()."<BR>";
$conn = mysql_query("SELECT * FROM nonexistenttable");
echo mysql_errno().": ".mysql_error()."<BR>";
?>
]]>
</programlisting>
</informalexample>
</para>
<para>
Viz. tak�: <function>mysql_error</function>
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-error">
<refnamediv>
<refname>mysql_error</refname>
<refpurpose>
Vr�t� text chybov� zpr�vy p�edchoz�ho MySQL p��kazu.
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_error</methodname>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
Returns the error text from the last MySQL function, or
<literal>''</literal> (the empty string) if no error occurred.
</para>
<para>
Errors coming back from the MySQL database backend no longer
issue warnings. Instead, use <function>mysql_error</function> to
retrieve the error text. Note that this function only returns the
error text from the most recently executed MySQL function (not
including <function>mysql_error</function> and
<function>mysql_errno</function>), so if you want to use it, make
sure you check the value before calling another MySQL function.
<informalexample>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect("marliesle");
echo mysql_errno().": ".mysql_error()."<BR>";
mysql_select_db("nonexistentdb");
echo mysql_errno().": ".mysql_error()."<BR>";
$conn = mysql_query("SELECT * FROM nonexistenttable");
echo mysql_errno().": ".mysql_error()."<BR>";
?>
]]>
</programlisting>
</informalexample>
</para>
<para>
Viz. tak�: <function>mysql_errno</function>
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-escape-string">
<refnamediv>
<refname>mysql_escape_string</refname>
<refpurpose>
Escapes a string for use in a mysql_query.
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_escape_string</methodname>
<methodparam><type>string</type><parameter>unescaped_string</parameter></method
param>
</methodsynopsis>
<para>
This function will escape the <parameter>unescaped_string</parameter>,
so that it is safe to place it in a <function>mysql_query</function>.
</para>
<note>
<simpara>
<function>mysql_escape_string</function> does not escape
<literal>%</literal> and <literal>_</literal>.
</simpara>
</note>
</refsect1>
</refentry>
<refentry id="function.mysql-fetch-array">
<refnamediv>
<refname>mysql_fetch_array</refname>
<refpurpose>
Na�te v�sledn� ��dek do asociativn�ho, ��slen�ho pole nebo oboj�ho.
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>array</type><methodname>mysql_fetch_array</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam choice="opt"><type>int</type><parameter>
result_type
</parameter></methodparam>
</methodsynopsis>
<para>
Returns an array that corresponds to the fetched row, or &false;
if there are no more rows.</para>
<para>
<function>mysql_fetch_array</function> is an extended version of
<function>mysql_fetch_row</function>. In addition to storing the
data in the numeric indices of the result array, it also stores
the data in associative indices, using the field names as keys.
</para>
<para>
If two or more columns of the result have the same field names,
the last column will take precedence. To access the other column(s)
of the same name, you must use the numeric index of the column or
make an alias for the column. For aliased columns, you cannot
access the contents with the original column name (by using
<literal>'field'</literal> in this example).
<informalexample>
<programlisting role="sql">
<![CDATA[
select tone.field as foo ttwo.field as bar from tone, ttwo
]]>
</programlisting>
</informalexample>
</para>
<para>
An important thing to note is that using
<function>mysql_fetch_array</function> is <emphasis>not
significantly</emphasis> slower than using
<function>mysql_fetch_row</function>, while it provides
a significant added value.
</para>
<para>
The optional second argument <parameter>result_type</parameter>
in <function>mysql_fetch_array</function> is a constant and can
take the following values: MYSQL_ASSOC, MYSQL_NUM, and
MYSQL_BOTH. This feature was added in PHP 3.0.7. MYSQL_BOTH
is the default for this argument.
</para>
<para>
By using MYSQL_BOTH, you'll get an array with both associative
and number indices. Using MYSQL_ASSOC, you only get associative
indices (as <function>mysql_fetch_assoc</function> works),
using MYSQL_NUM, you only get number indices (as
<function>mysql_fetch_row</function> works).
</para>
<para>
For further details, see also
<function>mysql_fetch_row</function> and
<function>mysql_fetch_assoc</function>.
</para>
<example>
<title><function>mysql_fetch_array</function> example</title>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect($host, $user, $password);
mysql_select_db("database");
$result = mysql_query("select user_id, fullname from table");
while ($row = mysql_fetch_array($result)) {
echo "user_id: ".$row["user_id"]."<br>\n";
echo "user_id: ".$row[0]."<br>\n";
echo "fullname: ".$row["fullname"]."<br>\n";
echo "fullname: ".$row[1]."<br>\n";
}
mysql_free_result($result);
?>
]]>
</programlisting>
</example>
</refsect1>
</refentry>
<refentry id="function.mysql-fetch-assoc">
<refnamediv>
<refname>mysql_fetch_assoc</refname>
<refpurpose>
Na�te v�sledn� ��dek do asociativn�ho pole
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>array</type><methodname>mysql_fetch_assoc</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
</methodsynopsis>
<para>
Returns an associative array that corresponds to the fetched row,
or &false; if there are no more rows.</para>
<para>
<function>mysql_fetch_assoc</function> is equivalent to calling
<function>mysql_fetch_array</function> with MYSQL_ASSOC for the
optional second parameter. It only returns an associative array.
This is the way <function>mysql_fetch_array</function> originally
worked. If you need the numeric indices as well as the
associative, use <function>mysql_fetch_array</function>.
</para>
<para>
If two or more columns of the result have the same field names,
the last column will take precedence. To access the other
column(s) of the same name, you either need to access the
result with numeric indices by using
<function>mysql_fetch_row</function> or add alias names.
See the example at the <function>mysql_fetch_array</function>
description about aliases.
</para>
<para>
An important thing to note is that using
<function>mysql_fetch_assoc</function> is <emphasis>not
significantly</emphasis> slower than using
<function>mysql_fetch_row</function>, while it
provides a significant added value.
</para>
<para>
For further details, see also
<function>mysql_fetch_row</function> and
<function>mysql_fetch_array</function>.
</para>
<example>
<title><function>mysql_fetch_assoc</function></title>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect($host, $user, $password);
mysql_select_db($database);
$query = "select * from table";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo $row["user_id"];
echo $row["fullname"];
}
mysql_free_result($result);
?>
]]>
</programlisting>
</example>
</refsect1>
</refentry>
<refentry id="function.mysql-fetch-field">
<refnamediv>
<refname>mysql_fetch_field</refname>
<refpurpose>
Na�te informace o sloupci z v�sledku do prom�nn� objektu
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>object</type><methodname>mysql_fetch_field</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam choice="opt"><type>int</type><parameter>
field_offset
</parameter></methodparam>
</methodsynopsis>
<para>
Returns an object containing field information.
</para>
<para>
<function>mysql_fetch_field</function> can be used in order to
obtain information about fields in a certain query result. If
the field offset isn't specified, the next field that wasn't yet
retrieved by <function>mysql_fetch_field</function> is retrieved.
</para>
<para>
The properties of the object are:
<itemizedlist>
<listitem>
<simpara>
name - column name
</simpara>
</listitem>
<listitem>
<simpara>
table - name of the table the column belongs to
</simpara>
</listitem>
<listitem>
<simpara>
max_length - maximum length of the column
</simpara>
</listitem>
<listitem>
<simpara>
not_null - 1 if the column cannot be &null;
</simpara>
</listitem>
<listitem>
<simpara>
primary_key - 1 if the column is a primary key
</simpara>
</listitem>
<listitem>
<simpara>
unique_key - 1 if the column is a unique key
</simpara>
</listitem>
<listitem>
<simpara>
multiple_key - 1 if the column is a non-unique key
</simpara>
</listitem>
<listitem>
<simpara>
numeric - 1 if the column is numeric
</simpara>
</listitem>
<listitem>
<simpara>
blob - 1 if the column is a BLOB
</simpara>
</listitem>
<listitem>
<simpara>
type - the type of the column
</simpara>
</listitem>
<listitem>
<simpara>
unsigned - 1 if the column is unsigned
</simpara>
</listitem>
<listitem>
<simpara>
zerofill - 1 if the column is zero-filled
</simpara>
</listitem>
</itemizedlist>
</para>
<example>
<title><function>mysql_fetch_field</function></title>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect('localhost:3306', $user, $password)
or die ("Nelze se p�ipojit");
mysql_select_db("database");
$result = mysql_query("select * from table")
or die("Query failed");
# get column metadata
$i = 0;
while ($i < mysql_num_fields($result)) {
echo "Information for column $i:<BR>\n";
$meta = mysql_fetch_field($result);
if (!$meta) {
echo "No information available<BR>\n";
}
echo "<PRE>
blob: $meta->blob
max_length: $meta->max_length
multiple_key: $meta->multiple_key
name: $meta->name
not_null: $meta->not_null
numeric: $meta->numeric
primary_key: $meta->primary_key
table: $meta->table
type: $meta->type
unique_key: $meta->unique_key
unsigned: $meta->unsigned
zerofill: $meta->zerofill
</PRE>";
$i++;
}
mysql_free_result($result);
?>
]]>
</programlisting>
</example>
<para>
Viz. tak� <function>mysql_field_seek</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-fetch-lengths">
<refnamediv>
<refname>mysql_fetch_lengths</refname>
<refpurpose>
Zjist� d�lku v�ech polo�ek aktu�ln�ho v�stupu
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>array</type><methodname>mysql_fetch_lengths</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
</methodsynopsis>
<para>
Returns an array that corresponds to the lengths of each field
in the last row fetched by <function>mysql_fetch_row</function>,
or &false; on error.
</para>
<para>
<function>mysql_fetch_lengths</function> stores the lengths of
each result column in the last row returned by
<function>mysql_fetch_row</function>,
<function>mysql_fetch_array</function>, and
<function>mysql_fetch_object</function> in an array, starting at
offset 0.
</para>
<para>
Viz. tak�: <function>mysql_fetch_row</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-fetch-object">
<refnamediv>
<refname>mysql_fetch_object</refname>
<refpurpose>
Na�te v�sledn� ��dek do prom�nn� objektu
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>object</type><methodname>mysql_fetch_object</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam choice="opt"><type>int</type><parameter>
result_type
</parameter></methodparam>
</methodsynopsis>
<para>
Returns an object with properties that correspond to the fetched
row, or &false; if there are no more rows.
</para>
<para>
<function>mysql_fetch_object</function> is similar to
<function>mysql_fetch_array</function>, with one difference - an
object is returned, instead of an array. Indirectly, that means
that you can only access the data by the field names, and not by
their offsets (numbers are illegal property names).
</para>
<para>
The optional argument <parameter>result_type</parameter> is a
constant and can take the following values: MYSQL_ASSOC,
MYSQL_NUM, and MYSQL_BOTH. See
<function>mysql_fetch_array</function> for explanation
of these constants.
</para>
<para>
Speed-wise, the function is identical to
<function>mysql_fetch_array</function>, and almost as quick as
<function>mysql_fetch_row</function> (the difference is
insignificant).
<example>
<title><function>mysql_fetch_object</function> example</title>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect("hostname", "user", "password");
mysql_select_db($db);
$result = mysql_query("select * from table");
while ($row = mysql_fetch_object($result)) {
echo $row->user_id;
echo $row->fullname;
}
mysql_free_result($result);
?>
]]>
</programlisting>
</example>
</para>
<para>
Viz. tak�: <function>mysql_fetch_array</function> and
<function>mysql_fetch_row</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-fetch-row">
<refnamediv>
<refname>mysql_fetch_row</refname>
<refpurpose>Na�te v�sledn� ��dek do pole</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>array</type><methodname>mysql_fetch_row</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
</methodsynopsis>
<para>
Returns an array that corresponds to the fetched row, or &false;
if there are no more rows.
</para>
<para>
<function>mysql_fetch_row</function> fetches one row of data from
the result associated with the specified result identifier. The
row is returned as an array. Each result column is stored in an
array offset, starting at offset 0.
</para>
<para>
Subsequent call to <function>mysql_fetch_row</function> would
return the next row in the result set, or &false; if there are no
more rows.
</para>
<para>
Viz. tak�: <function>mysql_fetch_array</function>,
<function>mysql_fetch_object</function>,
<function>mysql_data_seek</function>,
<function>mysql_fetch_lengths</function>, and
<function>mysql_result</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-field-flags">
<refnamediv>
<refname>mysql_field_flags</refname>
<refpurpose>
Na�te doplnuj�c� informace o polo�ce
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_field_flags</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_field_flags</function> returns the field flags of
the specified field. The flags are reported as a single word
per flag separated by a single space, so that you can split the
returned value using <function>explode</function>.
</para>
<para>The following flags are reported, if your version of MySQL
is current enough to support them: "not_null", "primary_key",
"unique_key", "multiple_key", "blob", "unsigned", "zerofill",
"binary", "enum", "auto_increment", "timestamp".
</para>
<para>
For downward compatibility <function>mysql_fieldflags</function>
can also be used. This is deprecated, however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-field-name">
<refnamediv>
<refname>mysql_field_name</refname>
<refpurpose>
Na�te n�zev polo�ky
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_field_name</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_index</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_field_name</function> returns the name of the
specified field index. <parameter>result</parameter> must be a
valid result identifier and <parameter>field_index</parameter> is
the numerical offset of the field.
</para>
<note>
<para>
<parameter>field_index</parameter> starts at 0.
</para>
<para>
e.g. The index of the third field would actually be 2, the index
of the fourth field would be 3 and so on.
</para>
</note>
<para>
<example>
<title><function>mysql_field_name</function> example</title>
<programlisting role="php">
<![CDATA[
// The users table consists of three fields:
// user_id
// username
// password.
$link = mysql_connect('localhost', $user, "secret");
mysql_select_db($dbname, $link)
or die("Could not set $dbname");
$res = mysql_query("select * from users", $link);
echo mysql_field_name($res, 0) . "\n";
echo mysql_field_name($res, 2);
]]>
</programlisting>
<para>
The above example would produce the following output:
<screen>
<![CDATA[
user_id
password
]]>
</screen>
</para>
</example>
</para>
<para>
For downwards compatibility <function>mysql_fieldname</function>
can also be used. This is deprecated, however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-field-len">
<refnamediv>
<refname>mysql_field_len</refname>
<refpurpose>
Vr�t� d�lku polo�ky
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_field_len</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_field_len</function> returns the length of the
specified field.
</para>
<para>
For downward compatibility <function>mysql_fieldlen</function>
can also be used. This is deprecated, however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-field-seek">
<refnamediv>
<refname>mysql_field_seek</refname>
<refpurpose>
Nastav� ukazatel na zadan� z�znam
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_field_seek</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
<para>
Seeks to the specified field offset. If the next call to
<function>mysql_fetch_field</function> doesn't include a field
offset, the field offset specified in
<function>mysql_field_seek</function> will be returned.
</para>
<para>
Viz. tak�: <function>mysql_fetch_field</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-field-table">
<refnamediv>
<refname>mysql_field_table</refname>
<refpurpose>
Zjist� jm�no tabulky, z n�� je zadan� polo�ka
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_field_table</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
<para>
Returns the name of the table that the specifed field is
in.
</para>
<para>
For downward compatibility <function>mysql_fieldtable</function>
can also be used. This is deprecated, however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-field-type">
<refnamediv>
<refname>mysql_field_type</refname>
<refpurpose>
Zjist� typ polo�ky v�sledku
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_field_type</methodname>
<methodparam><type>iresource</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>field_offset</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_field_type</function> is similar to the
<function>mysql_field_name</function> function. The arguments are
identical, but the field type is returned instead. The field type
will be one of "int", "real", "string", "blob", and others as
detailed in the <ulink url="&url.mysql.docs;">MySQL
documentation</ulink>.
<example>
<title>MySQL field types</title>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect("localhost:3306");
mysql_select_db("wisconsin");
$result = mysql_query("SELECT * FROM onek");
$fields = mysql_num_fields($result);
$rows = mysql_num_rows($result);
$i = 0;
$table = mysql_field_table($result, $i);
echo "Your '".$table."' table has ".$fields." fields and ".$rows." records
<BR>";
echo "The table has the following fields <BR>";
while ($i < $fields) {
$type = mysql_field_type($result, $i);
$name = mysql_field_name($result, $i);
$len = mysql_field_len($result, $i);
$flags = mysql_field_flags($result, $i);
echo $type." ".$name." ".$len." ".$flags."<BR>";
$i++;
}
mysql_close();
?>
]]>
</programlisting>
</example>
</para>
<para>
For downward compatibility <function>mysql_fieldtype</function>
can also be used. This is deprecated, however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-free-result">
<refnamediv>
<refname>mysql_free_result</refname>
<refpurpose>Uvoln� v�sledek z pam�ti</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>bool</type><methodname>mysql_free_result</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_free_result</function> will free all memory
associated with the result identifier <parameter>result</parameter>.
</para>
<para>
<function>mysql_free_result</function> only needs to be called if
you are concerned about how much memory is being used for queries
that return large result sets. All associated result memory is
automatically freed at the end of the script's execution.
<!-- TODO and as of PHP4 before, see freeing resources -->
</para>
<para>
&return.success;
</para>
<para>
For downward compatibility <function>mysql_freeresult</function>
can also be used. This is deprecated, however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-insert-id">
<refnamediv>
<refname>mysql_insert_id</refname>
<refpurpose>
Vr�t� hodnotu id posledn�ho p��kazu INSERT
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_insert_id</methodname>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_insert_id</function> returns the ID generated for
an AUTO_INCREMENT column by the previous INSERT query using the
given <parameter>identifikator_spojeni</parameter>. If
<parameter>identifikator_spojeni</parameter> isn't specified, the last
opened link is assumed.
</para>
<para>
<function>mysql_insert_id</function> returns 0 if the previous
query does not generate an AUTO_INCREMENT value. If you need to
save the value for later, be sure to call
<function>mysql_insert_id</function> immediately after the
query that generates the value.
</para>
<note>
<para>
The value of the MySQL SQL function
<literal>LAST_INSERT_ID()</literal> always contains the most
recently generated AUTO_INCREMENT value, and is not reset
between queries.
</para>
</note>
<warning>
<para>
<function>mysql_insert_id</function> converts the return type of
the native MySQL C API function
<literal>mysql_insert_id()</literal> to a type of
<literal>long</literal> (named <type>int</type> in PHP).
If your AUTO_INCREMENT column has a column type of BIGINT,
the value returned by <function>mysql_insert_id</function>
will be incorrect. Instead, use the internal MySQL SQL function
<literal>LAST_INSERT_ID()</literal> in an SQL query.
</para>
</warning>
</refsect1>
</refentry>
<refentry id="function.mysql-list-dbs">
<refnamediv>
<refname>mysql_list_dbs</refname>
<refpurpose>
Na�te v�echny datab�ze dostupn� na MySQL serveru
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>zdroj</type><methodname>mysql_list_dbs</methodname>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</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>
<para>
<example>
<title><function>mysql_list_dbs</function> example</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect('localhost', 'myname', 'secret');
$db_list = mysql_list_dbs($link);
while ($row = mysql_fetch_object($db_list)) {
echo $row->Database . "\n";
}
?>
]]>
</programlisting>
<para>
The above example would produce the following output:
<screen>
<![CDATA[
database1
database2
database3
..
]]>
</screen>
</para>
</example>
</para>
<note>
<para>
The above code would just as easily work with
<function>mysql_fetch_row</function> or other similar functions.
</para>
</note>
<para>
For downward compatibility <function>mysql_listdbs</function> can
also be used. This is deprecated however.
</para>
<para>
Viz. tak� <function>mysql_db_name</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-list-fields">
<refnamediv>
<refname>mysql_list_fields</refname>
<refpurpose>Na�te v�sledek s obsahem polo�ky</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>zdroj</type><methodname>mysql_list_fields</methodname>
<methodparam><type>string</type><parameter>database_name</parameter></methodpar
am>
<methodparam><type>string</type><parameter>table_name</parameter></methodparam>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</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>
<para>
<example>
<title><function>mysql_list_fields</function> example</title>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect('localhost', 'myname', 'secret');
$fields = mysql_list_fields("database1", "table1", $link);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
echo mysql_field_name($fields, $i) . "\n";;
}
]]>
</programlisting>
<para>
The above example would produce the following output:
<screen>
<![CDATA[
field1
field2
field3
..
]]>
</screen>
</para>
</example>
</para>
<para>
For downward compatibility <function>mysql_listfields</function>
can also be used. This is deprecated however.
</para>
<!-- TODO: this is equiv. with 'select * from $table where &false;,'
which implies you can better use the field-research functions
on a real query, that saves you one mysql-query.
-->
</refsect1>
</refentry>
<refentry id="function.mysql-list-tables">
<refnamediv>
<refname>mysql_list_tables</refname>
<refpurpose>Na�te v�echny tabulky v MySQL datab�zi</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>zdroj</type><methodname>mysql_list_tables</methodname>
<methodparam><type>string</type><parameter>database</parameter></methodparam>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</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.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-num-fields">
<refnamediv>
<refname>mysql_num_fields</refname>
<refpurpose>Vr�t� po�et polo�ek ve v�sledku</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_num_fields</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_num_fields</function> returns the number of
fields in a result set.
</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>
For downward compatibility <function>mysql_numfields</function>
can also be used. This is deprecated however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-num-rows">
<refnamediv>
<refname>mysql_num_rows</refname>
<refpurpose>Vr�t� po�et z�znam� ve v�sledku</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_num_rows</methodname>
<methodparam><type>zdroj</type><parameter>result</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>
<programlisting role="php">
<![CDATA[
<?php
$link = mysql_connect("localhost", "username", "password");
mysql_select_db("database", $link);
$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";
?>
]]>
</programlisting>
</example>
</para>
<para>
Viz. tak�:
<function>mysql_affected_rows</function>,
<function>mysql_connect</function>,
<function>mysql_select_db</function>, and
<function>mysql_query</function>.
</para>
<para>
For downward compatibility <function>mysql_numrows</function> can
also be used. This is deprecated however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-pconnect">
<refnamediv>
<refname>mysql_pconnect</refname>
<refpurpose>
Otev�e persistentn� spojen� s MySQL serverem
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>zdroj</type><methodname>mysql_pconnect</methodname>
<methodparam choice="opt"><type>string</type><parameter>
server
</parameter></methodparam>
<methodparam
choice="opt"><type>string</type><parameter>username</parameter></methodparam>
<methodparam
choice="opt"><type>string</type><parameter>password</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>
<para>
Support for ":port" was added in 3.0B4.
</para>
<para>
Support for the ":/path/to/socket" was added in
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.
</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.
</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>).
</para>
<para>
This type of link is therefore called 'persistent'.
</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.
</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>
</warning>
</refsect1>
</refentry>
<refentry id="function.mysql-query">
<refnamediv>
<refname>mysql_query</refname>
<refpurpose>Po�le MySQL dotaz</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>zdroj</type><methodname>mysql_query</methodname>
<methodparam><type>string</type><parameter>query</parameter></methodparam>
<methodparam
choice="opt"><type>zdroj</type><parameter>identifikator_spojeni</parameter></me
thodparam>
</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>identifikator_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>
</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[
<php
$result = mysql_query("SELECT * WHERE 1=1")
or die("Invalid query");
?>
]]>
</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;:
<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");
?>
]]>
</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>
Viz. tak�: <function>mysql_num_rows</function>
<function>mysql_affected_rows</function>,
<function>mysql_unbuffered_query</function>,
<function>mysql_free_result</function>,
<function>mysql_fetch_array</function>,
<function>mysql_fetch_row</function>,
<function>mysql_fetch_assoc</function>,
<function>mysql_result</function>,
<function>mysql_select_db</function>, and
<function>mysql_connect</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-unbuffered-query">
<refnamediv>
<refname>mysql_unbuffered_query</refname>
<refpurpose>
Po�le SQL dotaz MySQL bez vykon�n� a na�ten� v�sledn�ch z�znam�
</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>zdroj</type><methodname>mysql_unbuffered_query</methodname>
<methodparam><type>string</type><parameter>query</parameter></methodparam>
<methodparam
choice="opt"><type>zdroj</type><parameter>identifikator_spojeni</parameter></me
thodparam>
</methodsynopsis>
<para>
<function>mysql_unbuffered_query</function> sends a SQL query
<parameter>query</parameter> to MySQL, without fetching and
buffering the result rows automatically, as
<function>mysql_query</function> does. On the one hand, this
saves a considerable amount of memory with SQL queries that
produce large result sets. On the other hand, you can start
working on the result set immediately after the first row has
been retrieved: you don't have to wait until the complete SQL
query has been performed. When using multiple DB-connects, you
have to specify the optional parameter
<parameter>identifikator_spojeni</parameter>.
</para>
<note>
<para>
The benefits of <function>mysql_unbuffered_query</function> come
at a cost: You cannot use <function>mysql_num_rows</function> on
a result set returned from
<function>mysql_unbuffered_query</function>. You also have to
fetch all result rows from an unbuffered SQL query, before you
can send a new SQL query to MySQL.
</para>
</note>
<para>
Viz. tak�: <function>mysql_query</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-result">
<refnamediv>
<refname>mysql_result</refname>
<refpurpose>Na�te v�slednou hodnotu jedn� polo�ky</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>mixed</type><methodname>mysql_result</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>row</parameter></methodparam>
<methodparam choice="opt"><type>mixed</type><parameter>
field
</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_result</function> returns the contents of one
cell from a MySQL result set. The field argument can be the
field's offset, or the field's name, or the field's table dot
field name (tablename.fieldname). If the column name has been
aliased ('select foo as bar from...'), use the alias instead of
the column name.
</para>
<para>
When working on large result sets, you should consider using one
of the functions that fetch an entire row (specified below). As
these functions return the contents of multiple cells in one
function call, they're MUCH quicker than
<function>mysql_result</function>. Also, note that specifying a
numeric offset for the field argument is much quicker than
specifying a fieldname or tablename.fieldname argument.
</para>
<para>
Calls to <function>mysql_result</function> should not be mixed
with calls to other functions that deal with the result set.
</para>
<para>
Recommended high-performance alternatives:
<function>mysql_fetch_row</function>,
<function>mysql_fetch_array</function>, and
<function>mysql_fetch_object</function>.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-select-db">
<refnamediv>
<refname>mysql_select_db</refname>
<refpurpose>Vybere MySQL datab�zi</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>bool</type><methodname>mysql_select_db</methodname>
<methodparam><type>string</type><parameter>database_name</parameter></methodpar
am>
<methodparam choice="opt"><type>zdroj</type><parameter>
identifikator_spojeni
</parameter></methodparam>
</methodsynopsis>
<para>
&return.success;
</para>
<para>
<function>mysql_select_db</function> sets the current active
database on the server that's associated with the specified link
identifier. If no link identifier is specified, the last opened
link is assumed. If no link is open, the function will try to
establish a link as if <function>mysql_connect</function> was
called without arguments, and use it.
</para>
<para>
Every subsequent call to <function>mysql_query</function> will be
made on the active database.
</para>
<para> Viz. tak�:
<function>mysql_connect</function>,
<function>mysql_pconnect</function>, and
<function>mysql_query</function>.
</para>
<para>
For downward compatibility <function>mysql_selectdb</function>
can also be used. This is deprecated however.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-tablename">
<refnamediv>
<refname>mysql_tablename</refname>
<refpurpose>Na�te jm�no tabulky</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_tablename</methodname>
<methodparam><type>zdroj</type><parameter>result</parameter></methodparam>
<methodparam><type>int</type><parameter>i</parameter></methodparam>
</methodsynopsis>
<para>
<function>mysql_tablename</function> takes a result pointer
returned by the <function>mysql_list_tables</function> function
as well as an integer index and returns the name of a table. The
<function>mysql_num_rows</function> function may be used to
determine the number of tables in the result pointer.
<example>
<title><function>mysql_tablename</function> Example</title>
<programlisting role="php">
<![CDATA[
<?php
mysql_connect("host");
$result = mysql_list_tables("wisconsin");
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$tb_names[$i] = mysql_tablename($result, $i);
echo $tb_names[$i] . "<BR>";
}
?>
]]>
</programlisting>
</example>
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-get-client-info">
<refnamediv>
<refname>mysql_get_client_info</refname>
<refpurpose>Na�te MySQL klient info</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_get_client_info</methodname>
<void/>
</methodsynopsis>
<para>
<function>mysql_get_client_info</function> returns a string that
represents the client library version.
</para>
<para>
<function>mysql_get_client_info</function> was added in PHP 4.0.5.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-get-host-info">
<refnamediv>
<refname>mysql_get_host_info</refname>
<refpurpose>Na�te MySQL host info</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>string</type><methodname>mysql_get_host_info</methodname>
<methodparam
choice="opt"><type>zdroj</type><parameter>identifikator_spojeni</parameter></me
thodparam>
</methodsynopsis>
<para>
<function>mysql_get_host_info</function> returns a string
describing the type of connection in use for the connection
<parameter>identifikator_spojeni</parameter>, including the server host
name. If <parameter>identifikator_spojeni</parameter> is omited, the
last opened connection will be used.
</para>
<para>
<function>mysql_get_host_info</function> was added in PHP 4.0.5.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-get-proto-info">
<refnamediv>
<refname>mysql_get_proto_info</refname>
<refpurpose>Na�te MySQL protokol info</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_get_proto_info</methodname>
<methodparam
choice="opt"><type>zdroj</type><parameter>identifikator_spojeni</parameter></me
thodparam>
</methodsynopsis>
<para>
<function>mysql_get_proto_info</function> returns the protocol
version used by connection
<parameter>identifikator_spojeni</parameter>. If
<parameter>identifikator_spojeni</parameter> is omited, the last opened
connection will be used.
</para>
<para>
<function>mysql_get_proto_info</function> was added in PHP 4.0.5.
</para>
</refsect1>
</refentry>
<refentry id="function.mysql-get-server-info">
<refnamediv>
<refname>mysql_get_server_info</refname>
<refpurpose>Na�te MySQL server info</refpurpose>
</refnamediv>
<refsect1>
<title>Popis</title>
<methodsynopsis>
<type>int</type><methodname>mysql_get_server_info</methodname>
<methodparam
choice="opt"><type>zdroj</type><parameter>identifikator_spojeni</parameter></me
thodparam>
</methodsynopsis>
<para>
<function>mysql_get_server_info</function> returns the server
version used by connection
<parameter>identifikator_spojeni</parameter>. If
<parameter>identifikator_spojeni</parameter> is omited, the last opened
connection will be used.
</para>
<para>
<function>mysql_get_server_info</function> was added in PHP 4.0.5.
</para>
</refsect1>
</refentry>
</reference>
<!-- 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
-->
