PHP - Manual: odbc_fetch_object

2024-11-15

odbc_fetch_row »

« odbc_fetch_into

odbc_fetch_object

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

odbc_fetch_object — Fetch a result row as an object

说明

odbc_fetch_object(resource $statement, int $row = -1): stdClass|false

Fetch an object from an ODBC query.

参数

statement: The result resource from odbc_exec().
row: Optionally choose which row number to retrieve.

返回值

Returns an object that corresponds to the fetched row, or false if there are no more rows.

注释

注意: This function exists when compiled with DBMaker, IBM DB2 or UnixODBC support.

参见

odbc_fetch_row() - Fetch a row
odbc_fetch_array() - Fetch a result row as an associative array
odbc_num_rows() - Number of rows in a result

add a note

User Contributed Notes 10 notes

down

general at maccrafters dot com ¶

19 years ago


Here's a bit of code I came up with tha behaves just like mysql_fetch_object()

    function odbc_fetch_object($result)
    {
        $rs=array();
        if(odbc_fetch_into($result,&$rs))
        {
            foreach($rs as $key=>$value)
            {
    $fkey=strtoupper(odbc_field_name($result,$key+1));
                $rs_obj->$fkey = trim($value);

            }
        }
        return($rs_obj);
    }

Special thanks to previous posters for giving me a starting point for this code.

down

Anonymous ¶

1 year ago


This would be so much more useful if it contained information on what the object returned contains. From var_dump() it seems just an assoc array in object form. But is there column type info, for example?

down

thorsten at rinne dot info ¶

18 years ago


odbc_fetch_object() works nice with PHP 4.3.3 under W2K with IBM DB2 V.7.2 and V.8.1:

<?php
$conn = odbc_connect($db_name, $username, $password) or die(odbc_error_msg()); 
$sql = "SELECT * FROM TABLE"; 
$result = odbc_exec($conn, $sql);
while ($rows = odbc_fetch_object($result)) { 
    print $rows->COLUMNNAME;
    }
odbc_close($conn); 
?>

down

h4 at locked dot org ¶

19 years ago


my 2 cents:

function data($res) {
    $obj = new stdClass();
    $data_array = array();
        
    if (!odbc_fetch_into($res, $data_array)) {
        return 0;
    }

    $num_fields = odbc_num_fields($res);

    for ($i = 0;$i < $num_fields; $i++) {
        $name = odbc_field_name($res, $i + 1);
        if (!$name) {
            return 0;
        }
            
        $obj->{$name} = $data_array[$i];
    }
        
    return $obj;
}

works fine for me (PHP 4.3.1)

down

charlesk at netgaintechnology dot com ¶

19 years ago


I asked one of the developers to enable this function in the CVS.  I tried it and it worked.  I didnt do anything special.  I was using a Microsoft Access ODBC driver that came with my Windows XP Pro Install. 

I was using the Apache web server.

Charles

down

kynaston at yahoo dot com ¶

19 years ago


If you're using Masoud's code in PHP4.2+, change the fifth line to:

odbc_fetch_into($result,&$rs);

(the order of arguments have changed)

down

Marcus dot Karlsson at usa dot net ¶

20 years ago


It' possible to get both odbc_fetch_object() and odbc_fetch_array() to work just by removing #ifdef HAVE_DBMAKER/#endif in php_odbc.h line 216 (219) and the same in php_odbc.c line 87 (90) and 1229 (1380).

I've done this sucessfully in the PHP 4.2.0 release using ODBC towards a MySQL database.

I really can't understand why the #ifdef is there from the beginning, but they do have their reasons.

These were the files i "patched"
/* $Id: php_odbc.c,v 1.120.2.1 2002/04/08 22:21:30 sniper Exp $ */
/* $Id: php_odbc.h,v 1.45.2.1 2002/03/12 02:27:47 sniper Exp $ */

down

-1

j dot a dot z at bluewin dot ch ¶

19 years ago


hey "general at maccrafters dot com"

thank you very much for your code. it saved me time!
however i extended it a bit!
---------------------------------------------
    function __odbc_fetch_object($res)
    {
        if( function_exists("odbc_fetch_object") )
            return odbc_fetch_object($res);

        $rs = array();
        $rs_obj = false;
        if( odbc_fetch_into($res, &$rs) )
        {
            foreach( $rs as $key=>$value )
            {
                $fkey = odbc_field_name($res, $key+1);
                $rs_obj->$fkey = trim($value);
            }
        }
        return $rs_obj;
    }
---------------------------------------------
cheers, jaz

down

-1

masuod_a at hotmail dot com ¶

20 years ago


This function not availible in PHP 4.1.1 , you can try this : 

if (function_exists(odbc_fetch_object))
 return;
function odbc_fetch_object($result, $rownumber=1) {
 $rs=array();
 odbc_fetch_into($result, $rownumber,$rs);
 foreach ($rs as $key => $value) {
   $fkey=strtolower(odbc_field_name($result, $key+1));  
   $rs_obj->$fkey = $value;
 }
 return $rs_obj;
}
if you wanna use this function in a loop  you must set rownumber parameter
you can't use this function like :
 while ($myobj=odbc_fetch_object($res)) {
 ....
}

down

-1

philip ¶

17 years ago


This function requires one of the following to exist: Windows, DB2, or UNIXODBC.

add a note

官方地址：https://www.php.net/manual/en/function.odbc-fetch-object.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位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 adodb手册 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 opcache预加载 Composer的Packagist资源 mysql面试题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 PHP7添加redis扩展 Packagist / Composer 中国全量镜像 PHP获取指定函数定义在哪个文件中及行号 PHP mkdir()写出来的权限与mode值不符合 adodb连接mysql多个数据库的问题常用的php ADODB使用方法集锦

略微加速

PHP官方手册 - 互联网笔记

odbc_fetch_object

说明

参数

返回值

注释

参见

User Contributed Notes 10 notes