PHP 8.1.0 RC 2 available for testing

db2_field_name

(PECL ibm_db2 >= 1.0.0)

db2_field_name Returns the name of the column in the result set

Описание

db2_field_name(resource $stmt, mixed $column): string

Returns the name of the specified column in the result set.

Список параметров

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.

Возвращаемые значения

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.

Смотрите также

  • 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() - Возвращает тип данных указанного столбца в наборе результатов
  • db2_field_width() - Возвращает ширину текущего значения указанного столбца в наборе результатов

add a note add a note

User Contributed Notes 1 note

up
0
andryzulfikar at gmail dot com
9 years ago
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 )
*/
?>
To Top