• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • oci_num_fields()

    (PHP 5, PHP 7, PECL OCI8 >= 1.1.0)

    返回结果列的数目

    说明

    oci_num_fields(resource $statement): int

    oci_num_fields()返回$statement中的列的数目。

    Example #1 oci_num_fields()例子

    <?php
        echo "<pre>\n";
        $conn = oci_connect("scott", "tiger");
        $stmt = oci_parse($conn, "select * from emp");
        oci_execute($stmt);
        while (oci_fetch($stmt)) {
            echo "\n";
            $ncols = oci_num_fields($stmt);
            for ($i = 1; $i <= $ncols; $i++) {
                $column_name  = oci_field_name($stmt, $i);
                $column_value = oci_result($stmt, $i);
                echo $column_name . ': ' . $column_value . "\n";
            }
            echo "\n";
        }
        oci_free_statement($stmt);
        oci_close($conn);
        echo "</pre>";
    ?>
    

    oci_num_fields()在出错时返回FALSE

    Note:

    在 PHP 5.0.0 之前的版本必须使用ocinumcols()替代本函数。该函数名仍然可用,为向下兼容作为oci_num_fields()的别名。不过其已被废弃,不推荐使用。

    The following is not immediately obvious:
    If you need the number of columns in a REF CURSOR returned from a PL/SQL procedure, you need to use OCINumColumns() on the cursor handle returned by OCINewCursor after it is bound and executed, not the statement handle. Same applies for OCIColumnName() and friends.