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

From: Date: Mon, 19 May 2003 18:44:35 +0000
Subject: cvs: phpdoc-he /reference/mysql/functions mysql-fetch-array.xml mysql-fetch-assoc.xml mysql-ping.xml
Groups: php.doc.he 
Request: Send a blank email to doc-he+get-116@lists.php.net to get a copy of this message
shimi Mon May 19 14:44:35 2003 EDT Added files: /phpdoc-he/reference/mysql/functions mysql-fetch-array.xml mysql-fetch-assoc.xml mysql-ping.xml Log: file has been fully translated

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 -->
« previous php.doc.he (#116) next »