Issues converting stdClass to array

Question

I have converted one of my websites to use PDO database queries. All the queries are working perfectly except one and I have spent all day trying to solve this problem and nothing is working for me so as a last resort I am asking for some advice here.

This is the function I am having the problem with

    public function getTransactions($iProfileId)
    {

        $rStmt = Db::getInstance()->prepare('SELECT * FROM' . Db::prefix(DbTableName::GIFT_TX) .
                                            'WHERE profileId = :profileId ' .
                                            'ORDER BY createDate ASC, txId ASC');
        
        $rStmt->bindValue(':profileId', $iProfileId, \PDO::PARAM_INT);

        $rStmt->execute();
        $this->getTxs = $rStmt->fetch(\PDO::FETCH_OBJ);
        Db::free($rStmt);
        
                    
        return $this->getTxs;
    }

It returns a single row even though there are many others and as an object


object(stdClass)#47 (8) { ["txId"]=> string(1) "8" ["profileId"]=> string(3) "861" ["type"]=> string(6) "credit" ["credits"]=> string(2) "25" ["createDate"]=> string(19) "2020-06-26 10:48:55" ["isDelete"]=> string(1) "0" ["price"]=> string(4) "0.05" ["merchant"]=> string(6) "PayPal" }

I need this to be returned as an array and to get all the rows with profileId = :profileId

I have tried everything I can find online and have had no success at all.

You only call fetch() once and you call it with \PDO::FETCH_OBJ, so you will end up with 1 row as an object! — Nigel Ren
– Nigel Ren, Commented Jun 26, 2020 at 19:05
PHP docs say... PDO::FETCH_OBJ (integer) Specifies that the fetch method shall return each row as an object with property names that correspond to the column names returned in the result set. — Undefined-Variables
– Undefined-Variables, Commented Jun 26, 2020 at 19:08
I have over 200 functions and this is the only one I have an issue with. — Undefined-Variables
– Undefined-Variables, Commented Jun 26, 2020 at 19:09
On the manual page of fetch() PDO::FETCH_OBJ: returns an anonymous object with property names that correspond to the column names returned in your result set — Nigel Ren
– Nigel Ren, Commented Jun 26, 2020 at 19:11

Nigel Ren · Accepted Answer · 2020-06-26 19:28:06Z

1

Try this code

$this->getTxs = $rStmt->fetchAll(PDO::FETCH_ASSOC);

If in doubt, check out the URL below:

https://www.php.net/manual/en/pdostatement.fetchall.php

edited Jun 26, 2020 at 19:28

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

answered Jun 26, 2020 at 19:15

Balamurugan M

6306 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Issues converting stdClass to array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related