cvs: phpdoc-he /reference/mysql/functions mysql-affected-rows.xml

From: Date: Fri, 16 May 2003 12:22:20 +0000
Subject: cvs: phpdoc-he /reference/mysql/functions mysql-affected-rows.xml
Groups: php.doc.he 
Request: Send a blank email to doc-he+get-82@lists.php.net to get a copy of this message
shimi Fri May 16 08:22:20 2003 EDT Added files: /phpdoc-he/reference/mysql/functions mysql-affected-rows.xml Log: file has been fully translated Index: phpdoc-he/reference/mysql/functions/mysql-affected-rows.xml +++ phpdoc-he/reference/mysql/functions/mysql-affected-rows.xml <?xml version="1.0" encoding="iso-8859-8-i"?> <!-- $Revision: 1.1 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 --> <!-- HE-Revision: 1.00 Maintainer: shimi Status: complete --> <refentry id="function.mysql-affected-rows"> <refnamediv> <refname>mysql_affected_rows</refname> <refpurpose>îçæéø àú îñôø äùåøåú ùäåùôòå áôòåìú ä MySQL äàçøåðä</refpurpose> </refnamediv> <refsect1> <title>úéàåø</title> <methodsynopsis> <type>òøê ùìí</type><methodname>mysql_affected_rows</methodname> <methodparam choice="opt"><type>îùàá</type><parameter> îæää_÷éùåø </parameter></methodparam> </methodsynopsis> <para> <function>mysql_affected_rows</function> îçæéøä àú îñôø äùåøåú ùäåùôòå áò÷áåú ùàéìúú ä INSERT, UPDATE àå DELETE äàçøåðä òì <parameter>îæää_÷éùåø</parameter>. àí îæää ä÷éùåø ìà öåééï, PHP úçùéá æàú ëàéìå öåééï îæää ä÷éùåø äàçøåï ùì <function>mysql_connect</function>. </para> <note> <para> àí äðëí îùúîùéí á transactions, àúí öøéëéí ì÷øåà ì <function>mysql_affected_rows</function> àçøé ùàéìúú INSERT, UPDATE, àå DELETE, åìà àçøé ä - commit. </para> </note> <para> àí äùàéìúà äàçøåðä äééúä ùàéìúú DELETE ììà ôøîèø WHERE, ëì äøùåîåú ééîç÷å îäèáìä, àáì ôåð÷öéä æàú úçæéø àôñ. </para> <note> <para> ëùîùúîùéí á UPDATE, MySQL ìà éòãëï èåøéí ùòøëí äçãù æää ìòøëí äéùï. æä òìåì ìéöåø àôùøåú ù <function>mysql_affected_rows</function> ìà úçæéø àú äîñôø äàîéúé ùì îñôø äùåøåú ùäúàéîå, àìà àú îñôø äùåøåú ùäåùôòå øéàìéú òì éãé äùàéìúà. </para> </note> <para> <function>mysql_affected_rows</function> ìà ôåòìú òì ùàéìúåú îñåâ SELECT; àìà ø÷ òì ùàéìúåú àùø îùðåú øùåîåú. ëãé ì÷áì àú îñôø äùåøåú àùø äåçæøå òì éãé SELECT, éù ìäùúîù á <function>mysql_num_rows</function>. </para> <para> àí äùàéìúà äàçøåðä ðëùìä, ôåð÷öéä æàú úçæéø -1. <example> <title>ùàéìúú-îçé÷ä</title> <programlisting role="php"> <![CDATA[ <?php /* çéáåø àì îñã äðúåðéí */ mysql_pconnect("localhost", "mysql_user", "mysql_password") or die("ëùìåï áçéáåø: " . mysql_error()); /* æä éçæéø àú ä äîñôø äðëåï ùì äøùåîåú ùðîç÷å */ mysql_query("DELETE FROM mytable WHERE id < 10"); printf ("îñôø äøùåîåú ùðîç÷å: %d\n", mysql_affected_rows()); /* ììà ôøîèø WHERE áùàéìúú ä DELETE, äôåð÷öéä úçæéø 0 */ mysql_query("DELETE FROM mytable"); printf ("îñôø äøùåîåú ùðîç÷å: %d\n", mysql_affected_rows()); ?> ]]> </programlisting> <para> äãåâîà ùìòéì úéöåø àú äôìè äáà: <screen> <![CDATA[ îñôø äøùåîåú ùðîç÷å: 10 îñôø äøùåîåú ùðîç÷å: 0 ]]> </screen> </para> </example> <example> <title>ùàéìúú-òãëåï</title> <programlisting role="php"> <![CDATA[ <?php /* çéáåø ìîñã äðúåðéí */ mysql_pconnect("localhost", "mysql_user", "mysql_password") or die("ëùìåï áäúçáøåú:: " . mysql_error()); /* òãëåï øùåîåú */ mysql_query("UPDATE mytable SET used=1 WHERE id < 10"); printf ("îñôø äøùåîåú ùòåãëðå: %d\n", mysql_affected_rows()); mysql_query("COMMIT"); ?> ]]> </programlisting> <para> äãåâîà ùìòéì úéöåø àú äôìè äáà: <screen> <![CDATA[ îñôø äøùåîåú ùòåãëðå: 10 ]]> </screen> </para> </example> </para> <para> øàä âí: <function>mysql_num_rows</function>, <function>mysql_info</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 (#82) next »