   #PHP Manual Oracle 8 functions ocirollback ocisavelob

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                  ocirowcount

   (PHP 3>= 3.0.7, PHP 4 )
   ocirowcount -- Gets the number of affected rows

Description

   int ocirowcount ( resource stmt)

   ocirowcount() returns the number of rows affected for e.g.
   update-statements. This function will not tell you the number of rows
   that a select will return!

   Example 1. ocirowcount() example
   <?php
       echo "<pre>";
       $conn = OCILogon("scott", "tiger");
       $stmt = OCIParse($conn, "create table emp2 as select * from emp");
       OCIExecute($stmt);
       echo OCIRowCount($stmt) . " rows inserted.<br />";
       OCIFreeStatement($stmt);
       $stmt = OCIParse($conn, "delete from emp2");
       OCIExecute($stmt);
       echo OCIRowCount($stmt) . " rows deleted.<br />";
       OCICommit($conn);
       OCIFreeStatement($stmt);
       $stmt = OCIParse($conn, "drop table emp2");
       OCIExecute($stmt);
       OCIFreeStatement($stmt);
       OCILogOff($conn);
       echo "</pre>";
   ?>
   ______________________________________________________________________

   Prev        Home       Next
   ocirollback  Up  ocisavelob
