pg_field_type_oid

(PHP 5 >= 5.1.0, PHP 7, PHP 8)

pg_field_type_oid — Returns the type ID (OID) for the corresponding field number

说明

pg_field_type_oid(PgSql\Result $result, int $field): string|int

pg_field_type_oid() returns an integer containing the OID of the base type of the given field in the given result instance.

You can get more information about the field type by querying PostgreSQL's pg_type system table using the OID obtained with this function. The PostgreSQL format_type() function will convert a type OID into an SQL standard type name.

注意:
If the field uses a PostgreSQL domain (rather than a basic type), it is the OID of the domain's underlying type that is returned, rather than the OID of the domain itself.

参数

result: An PgSql\Result instance, returned by pg_query(), pg_query_params() or pg_execute()(among others).
field: Field number, starting from 0.

返回值

The OID of the field's base type.

更新日志

版本	说明
8.1.0	现在 `result` 参数接受 PgSql\Result 实例，之前接受资源(resource)。

范例

示例 #1 Getting information about fields


<?php
  $dbconn = pg_connect("dbname=publisher") or die("Could not connect");

  // Assume 'title' is a varchar type
  $res = pg_query($dbconn, "select title from authors where author = 'Orwell'");

  echo "Title field type OID: ", pg_field_type_oid($res, 0);
?>

以上例程会输出：

Title field type OID: 1043

参见

pg_field_type() - 返回相应字段的类型名称
pg_field_prtlen() - 返回打印出来的长度
pg_field_name() - 返回字段的名字

add a note

User Contributed Notes 2 notes

down

stanislav dot perfilov at gmail dot com ¶

1 year ago


<?php

private function mapping($q, $result)
    {
        $types = [];
        for ($i = 0, $count = \pg_num_fields($q); $i < $count; ++$i) {
            $types[$i] = \pg_field_type_oid($q, $i);
        }
        foreach ($result as $k => &$row) {
            $i = -1;
            foreach ($row as $name => &$value) {
                ++$i;
                if ($value === null) {
                    continue;
                }
                switch ($types[$i]) {
                    case 20:
                    case 21:
                    case 23: $value = (int)$value; break;
                    case 16507: /*$value = (string)$value; */break;
                    default:
                        throw new \RuntimeException(
                            \pg_field_type($q, $i) .' type. Need mapping ' . \pg_field_type_oid($q, $i)
                        );
                }
            }
        }
        unset($value, $row);

        return $result;
    }

?>

down

mauroi at digbang dot com ¶

17 years ago


This function can be used to improve the performance of your application. 
pg_field_type() makes an internal query to the pg_type table and it can be really slow. 
So if your application previously know the oids of your database, you can save the execution time of this query in every request.

add a note

官方地址：https://www.php.net/manual/en/function.pg-field-type-oid.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 科技开发编程 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL C/C++ 面试数据库 Golang Git 算法正则表达式操作系统 Redis 互联网 MySql JavaScript 运维软件架构设计 Mac OS 国际 TCP/IP Excel Vim Windows Socket Oracle VR MongoDB 运营 Python MemCache 商业硬件电子设计 nginx 娱乐摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 [PHP] inet_pton/inet_ntop IP地址转换函数 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 PHPMailer设置utf8 PHPMailer字符集CharSet 如何在Composer中为GitLab实例设置访问令牌 array_multisort() 多字段排序 laravel框架查看sql语句方式 [原创]诡异的php-fpm超时问题利用php soap实现web service PHP获取指定函数定义在哪个文件中及行号 php设置cookie为httponly防止xss攻击 PHP5 扩展SOAP 调用 webservice PHP-FPM进程数的设定利用PHP SOAP实现WEB SERVICE PHPstorm 里面Terminal 不能使用 esc键吗退出编辑模式吗 PHP7添加redis扩展 ADORecordSet对象纯php实现DES以及TripleDES加密算法 PHP - mysql_real_escape_string()与mysql_escape_string() 的区别

略微加速

PHP官方手册 - 互联网笔记

pg_field_type_oid

说明

参数

返回值

更新日志

范例

参见

User Contributed Notes 2 notes