odbc_fetch_object()

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

Fetch a result row as an object

说明

odbc_fetch_object(resource $result[,int $rownumber]): object

Fetch an object from an ODBC query.

参数

$result

The result resource from odbc_exec().

$rownumber

Optionally choose which row number to retrieve.

返回值

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

注释

Note: 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

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); 
?>

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)

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

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.

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)

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 $ */

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

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)) {
 ....
}

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