PHP: Hypertext Preprocessor (original) (raw)

pg_num_fields

(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)

pg_num_fields — Returns the number of fields in a result

Description

Note:

This function used to be called pg_numfields().

Return Values

The number of fields (columns) in the result. On error, -1 is returned.

Changelog

Version Description
8.1.0 The result parameter expects an PgSql\Result instance now; previously, a resource was expected.

Examples

Example #1 pg_num_fields() example

`<?php result=pgquery(result = pg_query(result=pgq​uery(conn, "SELECT 1, 2");$num = pg_num_fields($result);

echo

$num . " field(s) returned.\n";
?>`

The above example will output:

See Also

Found A Problem?

mark at redbrick dot dcu dot ie

22 years ago

`Here is a simple example for using pg_num_feilds, pg_num_rows and pg_result together. I'm simply SELECTing * from a table named markie on the current pg_connect().

\n"; for($lt = 0; lt<pgnumrows(lt < pg_num_rows(lt<pgn​umr​ows(results); $lt++) { echo "\n"; for($gt = 0; gt<pgnumfields(gt < pg_num_fields(gt<pgn​umf​ields(results); $gt++) { echo "" . pg_result($results, lt,lt, lt,gt) . "\n"; } echo "\n"; } echo "\n";pg_close($pgsql_conn); ?>

This code snippet will print out the rows and columns into a HTML table.

Regards, --mark

`