OCIColumnName

(PHP 3 = 3.0.4, PHP 4 )

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

説明

string OCIColumnName ( int stmt, int col)

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

例 1OCIColumnName

 ?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() も参照下さい。