cvs: phpdoc-ro /reference/mysql/functions mysql-affected-rows.xml mysql-field-seek.xml

radical Tue Oct 26 07:42:01 2004 EDT Added files: /phpdoc-ro/reference/mysql/functions mysql-affected-rows.xml mysql-field-seek.xml Log: Traduse in RO Astept raspuns de la lista in privinta modificarilor in mysql-affected-rows.xml http://cvs.php.net/co.php/phpdoc-ro/reference/mysql/functions/mysql-affected-rows.xml?r=1.1&p=1 Index: phpdoc-ro/reference/mysql/functions/mysql-affected-rows.xml +++ phpdoc-ro/reference/mysql/functions/mysql-affected-rows.xml <?xml version="1.0" encoding="iso-8859-1"?> <!-- $Revision: 1.1 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 --> <refentry id="function.mysql-affected-rows"> <refnamediv> <refname>mysql_affected_rows</refname> <refpurpose>Numarul de randuri dintr-un tabel al bazei de date curente afectate de ultima operatie</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>mysql_affected_rows</methodname> <methodparam choice="opt"><type>resource</type> <parameter>link_identifier</parameter></methodparam> </methodsynopsis> <para> <function>mysql_affected_rows</function> intoarce numarul de randuri afectate de ultima operatie daca aceasta a fost una din urmatoarele: INSERT, UPDATE sau DELETE. Aceasta valoare este dependenta de identificatorul de conexiune <parameter>link_identifier</parameter>. Daca <parameter>link_identifier</parameter> nu este specificat, se considera implicita ultima conexiune creata cu <function>mysql_connect</function>. </para> <note> <para> Daca folositi tranzactii, penrtu o valoare reala trebuie sa apelati <function>mysql_affected_rows</function> imediat dupa INSERT, UPDATE, sau DELETE, nu dupa definitivare (commit). </para> </note> <para> Daca ultima operatie a fost DELETE fara o clauza WHERE, atunci toate inregistrarile din table vor fi sterse dar aceasta functie va intoarce zero. </para> <note> <para> Daca folositi UPDATE, MySQL nu va modifica coloanele a caror valoare noua este egala cu cea veche. Acest lucru creaza posibilitatea ca <function>mysql_affected_rows</function> sa nu intoarca un numarul la care va asteptati, ci ea va intoarce numarul de randuri care au fost efectiv modificate de ultima operatie. </para> </note> <para> <function>mysql_affected_rows</function> nu functioneaza cu operatiuni de tip SELECT; doar operatii care modifica inregistrari. Pentru a prelua numarul de randuri rezultate in urma unei cereri de tip SELECT, va recomandam sa folositi <function>mysql_num_rows</function>. </para> <para> Daca ultima cerere a esuat, functia va intoarce -1. <example> <title>Solicitare de stergere</title> <programlisting role="php"> <![CDATA[ <?php /* conectare la baza de date */ $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Nu am putut stabili o conexiune: ' . mysql_error()); } mysql_select_db('mydb'); /* aar trebui sa eintoarca numarul de randuri sterse */ mysql_query('DELETE FROM mytable WHERE id < 10'); printf("Randuri sterse: %d\n", mysql_affected_rows()); /* cu o clauza de tip WHERE care este totdeauna falsa, intoarce 0 */ mysql_query('DELETE FROM mytable WHERE 0'); printf("randuri sterse: %d\n", mysql_affected_rows()); ?> ]]> </programlisting> <para> Exemplul de mai sus va produce urmatoarele: </para> <screen> <![CDATA[ Records deleted: 10 Records deleted: 0 ]]> </screen> </example> </para> <para> <example> <title>Solicitare UPDATE</title> <programlisting role="php"> <![CDATA[ <?php /* conectare la baza de dare */ mysql_connect("localhost", "mysql_user", "mysql_password") or die("Nu am putut stabili o conexiune: " . mysql_error()); mysql_select_db("mydb"); /* solicitare UPDATE */ mysql_query("UPDATE mytable SET used=1 WHERE id < 10"); printf ("Inregistrari modificate: %d\n", mysql_affected_rows()); mysql_query("COMMIT"); ?> ]]> </programlisting> <para> Exemplul de mai sus va produce urmatoarele: </para> <screen> <![CDATA[ Updated Records: 10 ]]> </screen> </example> </para> <para> Vedeti de asemenea <function>mysql_num_rows</function>, si <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 --> http://cvs.php.net/co.php/phpdoc-ro/reference/mysql/functions/mysql-field-seek.xml?r=1.1&p=1 Index: phpdoc-ro/reference/mysql/functions/mysql-field-seek.xml +++ phpdoc-ro/reference/mysql/functions/mysql-field-seek.xml <?xml version="1.0" encoding="iso-8859-1"?> <!-- $Revision: 1.1 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.2 --> <refentry id="function.mysql-field-seek"> <refnamediv> <refname>mysql_field_seek</refname> <refpurpose> Muta pointerul rezultatului la un camp specificat </refpurpose> </refnamediv> <refsect1> <title>descriere</title> <methodsynopsis> <type>int</type><methodname>mysql_field_seek</methodname> <methodparam><type>resource</type><parameter>result</parameter></methodparam> <methodparam><type>int</type><parameter>field_offset</parameter></methodparam> </methodsynopsis> <para> Muta la campul specificat. Daca urmatorul apel catre <function>mysql_fetch_field</function> nu include nu specifica locatia unui camp, tlocatia specificata in <function>mysql_field_seek</function> va fi returnata. </para> <para> Vedeti si <function>mysql_fetch_field</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 -->