php man page for pg_field_prtlen

Query: pg_field_prtlen

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

PG_FIELD_PRTLEN(3)														PG_FIELD_PRTLEN(3)

pg_field_prtlen - Returns the printed length

SYNOPSIS
int pg_field_prtlen (resource $result, int $row_number, mixed $field_name_or_number)
DESCRIPTION
int pg_field_prtlen (resource $result, mixed $field_name_or_number) pg_field_prtlen(3) returns the actual printed length (number of characters) of a specific value in a PostgreSQL $result. Row numbering starts at 0. This function will return FALSE on an error. $field_name_or_number can be passed either as an integer or as a string. If it is passed as an integer, PHP recognises it as the field num- ber, otherwise as field name. See the example given at the pg_field_name(3) page. Note This function used to be called pg_fieldprtlen(3).
PARAMETERS
o $result - PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others). o $row - Row number in result. Rows are numbered from 0 upwards. If omitted, current row is fetched.
RETURN VALUES
The field printed length, or FALSE on error.
EXAMPLES
Example #1 Getting information about fields <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); $res = pg_query($dbconn, "select * from authors where author = 'Orwell'"); $i = pg_num_fields($res); for ($j = 0; $j < $i; $j++) { echo "column $j "; $fieldname = pg_field_name($res, $j); echo "fieldname: $fieldname "; echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters "; echo "storage length: " . pg_field_size($res, $j) . " bytes "; echo "field type: " . pg_field_type($res, $j) . " "; } ?> The above example will output: column 0 fieldname: author printed length: 6 characters storage length: -1 bytes field type: varchar column 1 fieldname: year printed length: 4 characters storage length: 2 bytes field type: int2 column 2 fieldname: title printed length: 24 characters storage length: -1 bytes field type: varchar
SEE ALSO
pg_field_size(3). PHP Documentation Group PG_FIELD_PRTLEN(3)
Related Man Pages
mysql_result(3) - php
fbsql_fetch_field(3) - php
mssql_result(3) - php
pg_fetch_object(3) - php
pg_send_query(3) - php
Similar Topics in the Unix Linux Community
length of data greater than 11
Counting the max length of string
Finding the length of the longest column
Length validation
Removing special chars from file and maintain field separator