Codeigniter error : Fatal error: Cannot use object of type CI_DB_mysql_result as array

Question

I'm trying to implement a php codeigniter model for tree and every time I run my controller, I am getting the following error :

Fatal error: Cannot use object of type CI_DB_mysql_result as array in C:\AppServ\www\tree\application\models\Btree.php on line 50

I tried to fix this syntax in line

$currentID = $row['id'];

however, still getting the same error message.

My model function is:

public function fetchTree($parentArray, $parentID = null)
{
    // Create the query
    if ($parentID == null)
        $parentID = -1;

    $sql = "SELECT `id` FROM `{$this->tblName}` WHERE `id`= ". intval($parentID);

    // Execute the query and go through the results.
    $result = $this->db->query($sql);
    if ($result)
    {
        while ($row = $result)
        {
            // Create a child array for the current ID
            $currentID = $row['id'];
            $parentArray[$currentID] = array();

            // Print all children of the current ID
            $this->fetchTree($parentArray[$currentID], $currentID);
        }
        $result->close();
    }
}

jszobody · Accepted Answer · 2013-11-16 19:31:27Z

4

Your problem is with this line:

while($row = $result)

You're setting $row to the entire query object. You want to loop through the results of the query.

Try this instead:

$query = $this->db->query($sql);
foreach($query->result_array() AS $row) {
    $currentID = $row['id'];
    ...

edited Nov 16, 2013 at 19:31

answered Nov 16, 2013 at 19:24

jszobody

29k6 gold badges66 silver badges76 bronze badges

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

Comments

Mostafa Talebi · Accepted Answer · 2013-11-17 11:08:59Z

2

just the simpler solution is to have direct conversion to arrays:

$result = $this->db->query($sql)->result_array();

answered Nov 17, 2013 at 11:08

Mostafa Talebi

9,27718 gold badges69 silver badges110 bronze badges

Comments

Dogelismoツ · Accepted Answer · 2018-03-07 15:06:41Z

0

try this

    public function fetchTree($parentArray, $parentID = null)
{

     // Create the query
        if ($parentID == null)
            $parentID = -1;

    $sql = "SELECT `id` FROM `{$this->tblName}` WHERE `id`= ". intval($parentID);

    // Execute the query and go through the results.
    $result = $this->db->query($sql);
    if ($result)
    {
        while ($row = $result)
        {
            // Create a child array for the current ID
            $currentID = $row['id'];
            $parentArray[$currentID] = array();

            // Print all children of the current ID
            $this->fetchTree($parentArray[$currentID], $currentID);
        }
        $result->close();
    }
}

answered Mar 7, 2018 at 15:06

Dogelismoツ

1910 bronze badges

Collectives™ on Stack Overflow

Codeigniter error : Fatal error: Cannot use object of type CI_DB_mysql_result as array

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related