   #PHP Manual Oracle 8 functions ocinlogon ociparse

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                  ocinumcols

   (PHP 3>= 3.0.4, PHP 4 )
   ocinumcols --  Return the number of result columns in a statement

Description

   int ocinumcols ( resource stmt)

   ocinumcols() returns the number of columns in the statement stmt.

   Example 1. ocinumcols() example
   <?php
       echo "<pre>\n";
       $conn = OCILogon("scott", "tiger");
       $stmt = OCIParse($conn, "select * from emp");
       OCIExecute($stmt);
       while (OCIFetch($stmt)) {
           echo "\n";
           $ncols = OCINumCols($stmt);
           for ($i = 1; $i <= $ncols; $i++) {
               $column_name  = OCIColumnName($stmt, $i);
               $column_value = OCIResult($stmt, $i);
               echo $column_name . ': ' . $column_value . "\n";
           }
           echo "\n";
       }
       OCIFreeStatement($stmt);
       OCILogoff($conn);
       echo "</pre>";
   ?>
   ______________________________________________________________________

   Prev      Home     Next
   ocinlogon  Up  ociparse
