PHP Manual
Prev |  | Next

# OCINumCols

OCINumCols -- Return the number of result columns in a statement

## Description

`int OCINumCols`(int stmt);

OCINumCols() returns the number of columns in a statement

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

Prev | Home | Next
OCIRowCount | Up | OCIResult