Re: [PHP] pg_fetch_object

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Fri, Sep 23, 2005 at 08:55:44PM -0400, John DeSoi wrote:
> pg_fetch_object() returns an object with properties that correspond  
> to the fetched row's field names. It can optionally instantiate an  
> object of a specific class, and pass parameters to that class's  
> constructor.
> 
> I'm passing a class name string as the third parameter, but I only  
> get back a stdClass object. I also added an array of params as the  
> 4th parameter to pass to the constructor, but it does not appear to  
> be called.
> 
> Has anyone successfully used this to create a class other than stdClass?

Works here with PHP 5.0.4 and PostgreSQL 8.0.3:

    class Foo {
        function Foo($arg) {
            print "DEBUG: Foo($arg)\n";
        }
    }

    pg_connect("dbname=test user=test password=test");

    $result = pg_query("SELECT 'foo' AS val");
    $obj = pg_fetch_object($result, 0, 'Foo', array("test"));
    var_dump($obj);

    pg_close();

The above code produces the following output:

    DEBUG: Foo(test)
    object(Foo)#1 (1) {
      ["val"]=>
      string(3) "foo"
    }

Could you post a minimal example that doesn't work?

-- 
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

[Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

Add to Google Powered by Linux