Fatal error: Cannot use object of type stdClass as array in

Question

I'm getting the error:

"Fatal error: Cannot use object of type stdClass as array in" on line 183

From this code:

$getvidids = $ci->db->query(
    "SELECT * FROM videogroupids " . 
    "WHERE videogroupid='$videogroup' AND used='0' LIMIT 10");

foreach ($getvidids->result() as $row){
    $vidid = $row['videoid'];              //This is line 183
}

Anyone know what's wrong with the above code? Or what this error means?

The error is saying your variable $row is of type stdClass, and that you should access its member variables using $row->videoid rather than $row['videoid']. — Eric Leschinski
– Eric Leschinski, Commented Mar 28, 2017 at 0:47

Community · Accepted Answer · 2020-06-20 09:12:55Z

64

CodeIgniter returns result rows as objects, not arrays. From the user guide:

result()

This function returns the query result as an array of objects, or an empty array on failure.

You'll have to access the fields using the following notation:

foreach ($getvidids->result() as $row) {
    $vidid = $row->videoid;
}

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Mar 23, 2011 at 23:26

BoltClock

728k165 gold badges1.4k silver badges1.4k bronze badges

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

Comments

icchanobot · Accepted Answer · 2011-03-24 01:56:50Z

18

if you really want an array instead you can use:

$getvidids->result_array()

which would return the same information as an associative array.

answered Mar 24, 2011 at 1:56

icchanobot

3,34330 silver badges37 bronze badges

Comments

wav · Accepted Answer · 2020-02-19 16:53:52Z

Controller (Example: User.php)

<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Users extends CI_controller
{

    // Table
    protected  $table = 'users';

    function index()
    {
        $data['users'] = $this->model->ra_object($this->table);
        $this->load->view('users_list', $data);
    }
}

View (Example: users_list.php)

<table>
    <thead>
        <tr>
            <th>Name</th>
            <th>Surname</th>
        </tr>
    </thead>

    <tbody>
        <?php foreach($users as $user) : ?>
            <tr>
            <td><?php echo $user->name; ?></td>
            <td><?php echo $user->surname; ?></th>
        </tr>
        <?php endforeach; ?>
    </tbody>
</table>
<!-- // User table -->

Bilal Khalid · Accepted Answer · 2013-11-19 14:14:47Z

-3

Sorry.Though it is a bit late but hope it would help others as well . Always use the stdClass object.e.g

 $getvidids = $ci->db->query("SELECT * FROM videogroupids WHERE videogroupid='$videogroup'   AND used='0' LIMIT 10");

foreach($getvidids->result() as $key=>$myids)
{

  $vidid[$key] = $myids->videoid;  // better methodology to retrieve and store multiple records in arrays in loop
 }

answered Nov 19, 2013 at 14:14

Bilal Khalid

956 silver badges22 bronze badges

1 Comment

Wesley Smith Over a year ago

Why would you drop in 2 years after an answer was accepted and leave the same answer?

Collectives™ on Stack Overflow

Fatal error: Cannot use object of type stdClass as array in

4 Answers 4

result()

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

result()

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related