OCIColumnName

OCIColumnName -- カラムの名前を返す

説明

string OCIColumnName(int stmt, int col);

OCIColumnName は指定した(1から始まる)カラム 番号に対応するカラムの名前を返します。

例 1. OCIColumnName


 <?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"; 
 ?>   

OCINumCols, OCIColumnType, OCIColumnSize も参照下さい。