odbc_fetch_object

(PHP 4 >= 4.0.2, PHP 5)

odbc_fetch_objectFetch a result row as an object

Описание

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

Fetch an object from an ODBC query. See the changelog below for when this function is available.

Список параметров

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.

Список изменений

Версия Описание
4.3.3 This function exists when compiled with IBM DB2 or UnixODBC support.
4.3.2 This function exists when compiled for Windows.
4.0.2 This function exists when compiled with DBMaker support.

Смотрите также

Коментарии

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)) {
 ....
}
2002-02-22 14:29:27
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
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 $ */
2002-04-24 13:57:20
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
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)
2002-09-05 08:55:25
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
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.
2002-11-05 13:45:16
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
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
2003-01-23 12:54:30
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
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)
2003-03-11 08:28:02
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
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
2003-04-30 16:26:58
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
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); 
?>
2003-10-15 05:26:25
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
Автор:
This function requires one of the following to exist: Windows, DB2, or UNIXODBC.
2005-03-21 22:04:54
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html
Автор:
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?
2021-03-04 18:33:36
http://php5.kiev.ua/manual/ru/function.odbc-fetch-object.html

    Поддержать сайт на родительском проекте КГБ