cvs: phpdoc-he /reference/mysql/functions mysql-fetch-array.xml mysql-fetch-assoc.xml mysql-ping.xml

Index: phpdoc-he/reference/mysql/functions/mysql-fetch-array.xml
+++ phpdoc-he/reference/mysql/functions/mysql-fetch-array.xml
<?xml version="1.0" encoding="windows-1255"?>
<!-- $Revision: 1.1 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.27 -->
<!-- HE-Revision: 1.00 Maintainer: shimi Status: complete -->
  <refentry id="function.mysql-fetch-array">
   <refnamediv>
    <refname>mysql_fetch_array</refname>
    <refpurpose>
     îöéá ùåøú úåöàä ëîòøê àñåöéàèéáé, îòøê îñôøé, àå ùðéäí.
    </refpurpose>
   </refnamediv>
   <refsect1>
    <title>úéàåø</title>
     <methodsynopsis>
      <type>îòøê</type><methodname>mysql_fetch_array</methodname>
      <methodparam><type>îùàá</type><parameter>úåöàä</parameter></methodparam>
      <methodparam choice="opt"><type>òøê ùìí</type><parameter>
        ñåâ_úåöàä
       </parameter></methodparam>
     </methodsynopsis>
    <para>
     îçæéøä îòøê ùúåàí ìùåøä ùðîùëä, àå &false; àí àéï éåúø ùåøåú.</para>
    <para>
     <function>mysql_fetch_array</function> äéðä âéøñà îùåôøú éåúø ùì 
     <function>mysql_fetch_row</function>.  áðåñó ìàçñåï äîéãò áúàéí
     äîñôøééí ùì îòøê äúåöàä, äéà âí îàçñðú àú äîéãò áöåøä àñåöéàèéáéú,
     ëê ùùîåú äùãåú îùîùéí ëîôúç äàéðã÷ñ.
    </para>
    <para>
     àí ìùðé èåøéí (àå éåúø) éù àú àåúå ùí ùãä, äèåø äàçøåï äåà æä
     ùé÷áì àú ä÷ãéîåú òì äàçøéí. ëãé ìâùú ìèåø(éí) àçøéí òí àåúå äùí,
     àúí çééáéí ìäùúîù áàéðã÷ñ äîñôøé ùì äèåø, àå ìéöåø alias òáåø äèåø.
     áèåøéí îñåâ alias, àéðëí éëåìéí ìâùú ìúåëï  òí ùí äèåø äî÷åøé
     (òì éãé ùéîåù á<literal>'ùãä'</literal> áãåâîà æå).
     <example>
      <title>ùàéìúà òí ùîåú ùãåú ëôåìéí</title>
      <programlisting role="sql">
<![CDATA[
select table1.field as foo, table2.field as bar from table1, table2
]]>
      </programlisting>
     </example>
    </para>
    <para>
     ãáø çùåá ùéù ìöééï ìâáé ùéîåù á <function>mysql_fetch_array</function> 
     äåà ùôåð÷öéä æå <emphasis>àéðä àéèéú îùîòåúéú</emphasis> îùéîåù á
     <function>mysql_fetch_row</function>, ìîøåú ùäéà îåñéôä òøê ðåñó øá.
    </para>
    <para>
     äôøîèø äùðé äàåôöéåðìé <parameter>ñåâ_úåöàä</parameter>
     áôåð÷öéä <function>mysql_fetch_array</function> äåà ÷áåò åéëåì
     ìäéåú àçã îäòøëéí äáàéí: MYSQL_ASSOC, MYSQL_NUM å MYSQL_BOTH.
     éëåìú æå ðåñôä á PHP 3.0.7, åáäéòãø äôøîèø, éçùá äãáø ëàéìå
     äôøîèø äåà MYSQL_BOTH.
    </para>
    <para>
     òì éãé ùéîåù á MYSQL_BOTH, ú÷áìå îòøê áòì àéðã÷ñéí îñôøééí 
     åàñåöéàèéáééí. òì éãé ùéîåù á MYSQL_ASSOC, ú÷áìå ø÷ àú äàéðã÷ñéí
     äàñåöéàèéáééí (ëîå ùäôåð÷öéä <function>mysql_fetch_assoc</function>
     òåáãú), åùéîåù á MYSQL_NUM éâøåí ì÷áìú àéðã÷ñ îñôøé áìáã (ëîå
     ùäôåð÷öéä <function>mysql_fetch_row</function> òåáãú).
    </para>
    &mysql.field-case;
    <example>
     <title>mysql_fetch_array òí MYSQL_NUM</title>
     <programlisting role="php">
<![CDATA[
<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("ëùìåï áçéáåø: " . mysql_error());
    mysql_select_db("mydb");

    $result = mysql_query("SELECT id, name FROM mytable");

    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
        printf ("îæää: %s  ùí: %s", $row[0], $row[1]);  
    }

    mysql_free_result($result);
?>
]]>
     </programlisting>
    </example>
    <example>
     <title>mysql_fetch_array òí MYSQL_ASSOC</title>
     <programlisting role="php">
<![CDATA[
<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("ëùìåï áçéáåø: " . mysql_error());
    mysql_select_db("mydb");

    $result = mysql_query("SELECT id, name FROM mytable");

    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
        printf ("îæää: %s  ùí: %s", $row["id"], $row["name"]);
    }

    mysql_free_result($result);
?>
]]>
     </programlisting>
    </example>
    <example>
     <title>mysql_fetch_array òí MYSQL_BOTH</title>
     <programlisting role="php">
<![CDATA[
<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("ëùìåï áçéáåø: " . mysql_error());
    mysql_select_db("mydb");

    $result = mysql_query("SELECT id, name FROM mytable");

    while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
        printf ("îæää: %s  ùí: %s", $row[0], $row["name"]);
    }

    mysql_free_result($result);
?>
]]>
     </programlisting>
    </example>
    <para>
     øàä âí:
     <function>mysql_fetch_row</function> å
     <function>mysql_fetch_assoc</function>.
    </para>
   </refsect1>
  </refentry>

<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->

Index: phpdoc-he/reference/mysql/functions/mysql-fetch-assoc.xml
+++ phpdoc-he/reference/mysql/functions/mysql-fetch-assoc.xml
<?xml version="1.0" encoding="windows-1255"?>
<!-- $Revision: 1.1 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.45 -->
<!--  HE-Revision: 1.00 Maintainer: shimi Status: complete -->
  <refentry id="function.mysql-fetch-assoc">
   <refnamediv>
    <refname>mysql_fetch_assoc</refname>
    <refpurpose>
     îùéëú ùåøú úåöàä ëîòøê àñåöéàèéáé
    </refpurpose>
   </refnamediv>
   <refsect1>
    <title>úéàåø</title>
     <methodsynopsis>
      <type>îòøê</type><methodname>mysql_fetch_assoc</methodname>
      <methodparam><type>îùàá</type><parameter>úåöàä</parameter></methodparam>
     </methodsynopsis>
    <para>
     îçæéøä îòøê àñåöéàèéáé îäùåøä äðîùëú, àå &false; àí àéï éåúø ùåøåú</para>
    <para>
     <function>mysql_fetch_assoc</function> äéðä æää ì÷øéàä ì 
     <function>mysql_fetch_array</function> òí MYSQL_ASSOC áúåø
     äôøîèø äàåôöéåðìé äùðé. äéà îçæéøä ø÷ îòøê àñåöéàèéáé.
     æåäé äãøê ùáä <function>mysql_fetch_array</function> ôòìä áî÷åø.
     àí àúí öøéëéí âí àú äàéðã÷ñ äîñôøé åâí àú äàñåöéàèéáé ùì äîòøê,
     òìéëí ìäùúîù áôåð÷öéä <function>mysql_fetch_array</function>.
    </para>
    <para>
     àí ùðééí àå éåúø îäèåøéí ùì äúåöàä äí áòìé àåúå ùí ùãä,
     äèåø äàçøåï äåà æä ùé÷áì òãéôåú. ëãé ìâùú àì äèåø(éí) äàçø(éí)
     òí àåúå äùí, òìéëí ìâùú àì äúåöàä òí àéðã÷ñ îñôøé, àå ìäåñéó
     ùí alias. øàå àú äãåâîà áôåð÷öéä <function>mysql_fetch_array</function>
     òáåø úéàåø ìâáé ùîåú alias.
    </para>
    <para>
     ãáø çùåá ùéù ìöééï äåà ùùéîåù á <function>mysql_fetch_assoc</function>
     <emphasis>àéðå àéèé îùîòåúéú</emphasis> îùéîåù á 
     <function>mysql_fetch_row</function>, åáàåúå äæîï îåñéó òøê îùîòåúé.
    </para>
    &mysql.field-case;
    <example>
     <title>ãåâîà îåøçáú ùì <function>mysql_fetch_assoc</function></title>
     <programlisting role="php">
<![CDATA[
<?php

    $conn = mysql_connect("localhost", "mysql_user", "mysql_password");
    
    if (!$conn) {
        echo "ëùìåï áçéáåø ìîñã äðúåðéí: " . mysql_error();
        exit;
    }
    
    if (!mysql_select_db("mydbname")) {
        echo "ëùìåï ááçéøú îñã äðúåðéí: " . mysql_error();
        exit;
    }
    
    $sql = "SELECT id as userid, fullname, userstatus 
            FROM   sometable
            WHERE  userstatus = 1";

    $result = mysql_query($sql);

    if (!$result) {
        echo "ëùìåï áäøöú äùàéìúà ($sql) îîñã äðúåðéí: " . mysql_error();
        exit;
    }
    
    if (mysql_num_rows($result) == 0) {
        echo "ìà ðîöàå ùåøåú, àéï îä ìäãôéñ, åìëï úäéä éöéàä àåèåîèéú îäôåð÷öéä";
        exit;
    }
    
    // ëì òåã ùåøä ðåñôú ùì îéãò ÷ééîú, äëðñ àåúä á $row ëîòøê àñåöéàèéáé
    // äòøä: àí àúí îöôéí ø÷ ìùåøä àçú, àéï öåøê ìäùúîù áìåìàä
    // äòøä: àí úùúîùå á extract($row); áúåê äìåìàä äáàä, àúí úéöøå àú
    // $userid, $fullname åàú $userstatus
    while ($row = mysql_fetch_assoc($result)) {
        echo $row["userid"];
        echo $row["fullname"];
        echo $row["userstatus"];
    }
	    
    mysql_free_result($result);

?>
]]>
     </programlisting>
    </example>
    <para>
     øàä âí 
     <function>mysql_fetch_row</function>,
     <function>mysql_fetch_array</function>,
     <function>mysql_query</function>, å
     <function>mysql_error</function>.
    </para>
   </refsect1>
  </refentry>

<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->

Index: phpdoc-he/reference/mysql/functions/mysql-ping.xml
+++ phpdoc-he/reference/mysql/functions/mysql-ping.xml
<?xml version="1.0" encoding="windows-1255"?>
<!-- $Revision: 1.1 $ -->
<!-- splitted from ./en/functions/mysql.xml, last change in rev 1.100 -->
<!--  HE-Revision: 1.00 Maintainer: shimi Status: complete --> 
  <refentry id="function.mysql-ping">
   <refnamediv>
    <refname>mysql_ping</refname>
    <refpurpose>îáöò ôéðâ àì ùøú î÷åùø, àå îúçáø îçãù àí àéï ÷éùåø</refpurpose>
   </refnamediv>
   <refsect1>
    <title>úéàåø</title>
     <methodsynopsis>
      <type>áåìéàðé</type><methodname>mysql_ping</methodname>
      <methodparam choice="opt"><type>îùàá</type><parameter>
       îæää_÷éùåø
       </parameter></methodparam>
     </methodsynopsis>
    <para>
     <function>mysql_ping</function> áåã÷ú äàí äçéáåø ìùøú ôåòì àå ìà.
     àí äçéáåø ëáø ìà ôåòì, äôåð÷öéä úðñä äúçáøåú îçãù àåèåîèéú. ôåð÷öéä
     æå îùîùú áòé÷ø áñ÷øéôèéí ùðùàøéí ììà ôòåìä ìîùê æîï øá (idle),
     òì îðú ìáãå÷ äàí äùøú ðéú÷ àú ä÷éùåø åäàí ÷éùåø îçãù ðçåõ.
     <function>mysql_ping</function> îçæéøä &true; àí ä÷éùåø ìùøú ôåòì,
     å &false; àí äåà ìà.
    </para>
    <para>
     øàä âí:
     <function>mysql_thread_id</function>,
     <function>mysql_list_processes</function>.
    </para>
   </refsect1>
  </refentry>

<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->