Oracle 8
ociDefineByName ociBindByName ociLogon ociPLogon ociNLogon ociLogOff ociexecute ociCommit ociRollback ociNewDescriptor ociRowCount ociNumCols ociResult ociFetch ociFetchInto ociFetchStatement ociColumnIsNULL ociColumnName ociColumnSize ociColumnType ociServerVersion ociStatementType ociNewCursor ociFreeStatement ociFreeCursor ociFreeDesc ociparse ociError ociinternaldebug OCICancel ocisetprefetch OCIWriteLobToFile OCISaveLobFile OCISaveLob OCILoadLob OCIColumnScale OCIColumnPrecision OCIColumnTypeRaw OCINewCollection OCIFreeCollection OCICollAssign OCICollAssignElem OCICollGetElem OCICollMax OCICollSize OCICollTrim
Description
mixed ocicolumntype(resource stmt ,int col )
ocicolumntype retourne le type de données de la colonne correspondant au numéro de colonne col dans le résultat stmt (les colonnes sont indexées à partir de 1).
<?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";?>
Voir aussi ocinumcols, ocicolumnname et ocicolumnsize.