Russian Ukraine English
Catalog RSS


(PHP 3>= 3.0.4, PHP 4 )

OCIColumnType -- Returns the data type of a column.


mixed OCIColumnType (int stmt, int col)

OCIColumnType() returns the data type of the column corresponding to the column number (1-based) that is passed in.

Example 1. OCIColumnType

<?php        print "<HTML><PRE>\n";        $conn = OCILogon("scott", "tiger");     $stmt = OCIParse($conn,"select * from emp");     OCIExecute($stmt);     print "<TABLE BORDER=\"1\">";     print "<TR>";     print "<TH>Name</TH>";     print "<TH>Type</TH>";     print "<TH>Length</TH>";     print "</TR>";     $ncols = OCINumCols($stmt);     for ( $i = 1; $i <= $ncols; $i++ ) {         $column_name  = OCIColumnName($stmt,$i);         $column_type  = OCIColumnType($stmt,$i);         $column_size  = OCIColumnSize($stmt,$i);         print "<TR>";         print "<TD>$column_name</TD>";         print "<TD>$column_type</TD>";         print "<TD>$column_size</TD>";         print "</TR>";     }     OCIFreeStatement($stmt);       OCILogoff($conn);        print "</PRE>";     print "</HTML>\n";  ?>          

See also OCINumCols(), OCIColumnName(), and OCIColumnSize().