Database - Phalcon\Db fetch constants

Question

Database - Phalcon\Db fetch constants

Calin Rada Jun '13

Created Jun '13	Last Reply Jun '13	Replies 1	Views 699	Votes 0

Calin Rada 51.2k

Jun '13

I don't know if it's a bug, but since you use the PDO layer, the constants for fetching records, should have the same value as in PDO.

For example, now you have:

const FETCH_ASSOC = 1; // Should be 2 const FETCH_BOTH = 2; // Should be 4 const FETCH_NUM = 3; // It is ok const FETCH_OBJ = 4; // Should be 5 as in PDO

If you don't correct this, running the following code, will not return the records as expected (object)

    $db = $this->getDI()->get('db')->getInternalHandler();

    $result = $db->query($s_query);
    $result->setFetchMode(\Phalcon\Db::FETCH_OBJ);
    return $result->fetchAll();

But if you replace \Phalcon\Db::FETCH_OBJ with 5 or \PDO::FETCH_OBJ, it works as expected.

Phalcon 1.1.0

Phalcon · Answer 1 · 2013-06-26T09:25:43-07:00

When you get the internal handler you're working over the PDO instance and not with Phalcon\Db\Adapter*, of course you need to use PDO constants there

Calin Rada · Answer 2 · 2013-06-27T00:41:44-07:00

Calin Rada
51.2k

Jun '13

Ok. Thank you.