example:
<?php
// select all fields from salay table
$sql = "SELECT * FROM SALARY";
$stmt = db2_prepare($conn,$sql);
if(db2_execute($stmt)){
$columns = db2_num_fields($stmt);
for($i=0;$i<$columns;$i++){
$fieldName[] = db2_field_name($stmt,$i);
}
print_r($fieldName);
}else{
echo db2_stmt_errormsg();
}
/* output
* Array ( [0] => ID [1] => USERID [2] => VALUE )
*/
?>
db2_field_name
(PECL ibm_db2 >= 1.0.0)
db2_field_name — Returns the name of the column in the result set
Description
Returns the name of the specified column in the result set.
Parameters
-
stmt -
Specifies a statement resource containing a result set.
-
column -
Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a string containing the name of the column.
Return Values
Returns a string containing the name of the specified column. If the
specified column does not exist in the result
set, db2_field_name() returns false.
See Also
- db2_field_display_size() - Returns the maximum number of bytes required to display a column
- db2_field_num() - Returns the position of the named column in a result set
- db2_field_precision() - Returns the precision of the indicated column in a result set
- db2_field_scale() - Returns the scale of the indicated column in a result set
- db2_field_type() - Returns the data type of the indicated column in a result set
- db2_field_width() - Returns the width of the current value of the indicated column in a result set
add a note
User Contributed Notes 1 note
andryzulfikar at gmail dot com ¶
12 years ago
