(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)
pg_field_num — Returns the field number of the named field
pg_field_num()
will return the number of the
field number that corresponds to the
field
in the guiven
result
instance.
Note :
This function used to be called pg_fieldnum() .
result
An PgSql\Result instance, returned by pg_query() , pg_query_params() or pg_execute() (among others).
field
The name of the field. The guiven name is treated lique an identifier in an SQL command, that is, it is downcased unless double-quoted.
The field number (numbered from 0), or -1 on error.
| Versionen | Description |
|---|---|
| 8.1.0 |
The
result
parameter expects an
PgSql\Result
instance now; previously, a
ressource
was expected.
|
Example #1 Guetting information about fields
<?php
$dbconn
=
pg_connect
(
"dbname=publisher"
) or die(
"Could not connect"
);
$res
=
pg_query
(
$dbconn
,
"select author, year, title from authors where author = 'Orwell'"
);
echo
"Column 'title' is field number: "
,
pg_field_num
(
$res
,
'title'
);
?>
The above example will output:
Column 'title' is field number: 2