pg_field_type - PHP code example

PHP Functions

A php function is an executable piece of code that performs a specific task. There are more than 1,000 built-in functions within the PHP distribution, and you can also create your own custom functions to achieve a particular programming goal.

PHP is a loosely typed language, meaning that it does not enforce the types of variables and arguments passed to functions. Often, PHP will do a bit of type juggling to convert an integer variable into a string argument before continuing execution. This is a result of the language being used as a general-purpose programming language.

There are some cases where you may want to specify the types of variables and arguments that a function accepts. For example, you might want to prevent a stack trace from printing the values of method parameters that are associated with sensitive data such as passwords or credentials. You can do this by annotating a parameter with the SensitiveParameter attribute.

pg_field_type() returns the base type name of a field in the given PostgreSQL result resource. It uses the PostgreSQL pg_type system table to look up the database field meta-data for a given OID. This function used to be called pg_field_type_oid().

pg_field_meta_data() returns the table definition for the given table as an array. This function is EXPERIMENTAL. Its behavior, API, and documentation might change in a future version of PHP. It expects a PgSqlResult instance as a resource, instead of an PgQueryOid, as the first parameter.

pg_field_type example

/** * Generates an array of objects representing field meta-data. */
    public function getFieldData(): array
    {
        $retVal = [];

        for ($i = 0, $c = $this->getFieldCount(); $i < $c; $i++) {
            $retVal[$i]             = new stdClass();
            $retVal[$i]->name       = pg_field_name($this->resultID, $i);
            $retVal[$i]->type       = pg_field_type_oid($this->resultID, $i);
            $retVal[$i]->type_name  = pg_field_type($this->resultID, $i);
            $retVal[$i]->max_length = pg_field_size($this->resultID, $i);
            $retVal[$i]->length     = $retVal[$i]->max_length;
            // $retVal[$i]->primary_key = (int)($fieldData[$i]->flags & 2);             // $retVal[$i]->default = $fieldData[$i]->def;         }

        return $retVal;
    }

    /** * Frees the current result. * * @return void */

        $a['affected rows'] = pg_affected_rows($result);
        $a['last OID'] = pg_last_oid($result);

        $fields = pg_num_fields($result);

        for ($i = 0; $i < $fields; ++$i) {
            $field = [
                'name' => pg_field_name($result, $i),
                'table' => sprintf('%s (OID: %s)', pg_field_table($result, $i), pg_field_table($result, $i, true)),
                'type' => sprintf('%s (OID: %s)', pg_field_type($result, $i), pg_field_type_oid($result, $i)),
                'nullable' => (bool) pg_field_is_null($result, $i),
                'storage' => pg_field_size($result, $i).' bytes',
                'display' => pg_field_prtlen($result, $i).' chars',
            ];
            if (' (OID: )' === $field['table']) {
                $field['table'] = null;
            }
            if ('-1 bytes' === $field['storage']) {
                $field['storage'] = 'variable size';
            } elseif ('1 bytes' === $field['storage']) {
                $field['storage'] = '1 byte';
            }