Search DaTutorials:  
HOME
Php Tutorials
Articles
Basics
Date and Time
File Manipulations
Forms
Functions
General
Interactivity
MySql
Navigation
News,Shoutboxes and Blogs
Language Structure and Data Types
Searching
Security
String Manipulation
User Information and Stats
Search For a Tutorial
Php Reference

ocicolumnname

(PHP 3>= 3.0.4, PHP 4 , PHP 5)

ocicolumnname -- Returns the name of a column

Description

string ocicolumnname ( resource stmt, int col)

ocicolumnname() returns the name of the column corresponding to the column number (1-based) that is passed in.

Example 1. ocicolumnname() example

<?php 
   $conn
= OCILogon("scott", "tiger");
  
$stmt = OCIParse($conn, "select * from emp");
  
OCIExecute($stmt);
   echo
"<table border=\"1\">";
   echo
"<tr>";
   echo
"<th>Name</th>";
   echo
"<th>Type</th>";
   echo
"<th>Length</th>";
   echo
"</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);
       echo
"<tr>";
       echo
"<td>$column_name</td>";
       echo
"<td>$column_type</td>";
       echo
"<td>$column_size</td>";
       echo
"</tr>";
   }
   echo
"</table>\n";
  
OCIFreeStatement($stmt); 
  
OCILogoff($conn); 
?>

Note: This function was renamed to oci_field_name() after PHP >= 5.0.0. For downward compatibility ocicolumnname() can also be used. This is deprecated, however.



Copyright © 2001-2004 The PHP Group
All rights reserved.

     The eBay Song | Online Loans | Nicole Scherzinger | Internet Advertising | Toy Store
Home     Link To Us     Ad With Us     Contact Us     Tell A Friend     Affiliates     Blog     MsOfficeHelp