   #PHP Manual PostgreSQL functions PostgreSQL functions pg_cancel_query

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                               pg_affected_rows

   (PHP 4 >= 4.2.0)
   pg_affected_rows -- Returns number of affected records (tuples)

Description

   int pg_affected_rows ( resource result)

   pg_affected_rows() returns the number of tuples
   (instances/records/rows) affected by INSERT, UPDATE, and DELETE
   queries executed by pg_query(). If no tuple is affected by this
   function, it will return 0.

   Example 1. pg_affected_rows() example
   <?php
        $result = pg_query($conn, "INSERT INTO authors VALUES ('Orwell',
   2002, 'Animal Farm')");
        $cmdtuples = pg_affected_rows($result);
        echo $cmdtuples . " tuples are affected.\n";
   ?>

     Note: This function used to be called pg_cmdtuples().

   See also pg_query() and pg_num_rows().
   ______________________________________________________________________

   Prev                 Home            Next
   PostgreSQL functions  Up  pg_cancel_query
