CodeIgniter : "Fatal error: Cannot use object of type stdClass as array" message

There are times when the error message returned by the interpreter or compiler just don't make sense. Today I encountered an error message while I was coding up CodeIgniter today and the error message is :

Fatal error: Cannot use object of type stdClass as array

After reading up CodeIgniter user guide, apparently the error was caused by the wrong way of accessing result array returned by the $this->db->query() function.

To get rid of the error message, change the $row['username'] to $row->username

 foreach ($results->result() as $row){
 $username = $row['username'];
 }

change to

 foreach ($results->result() as $row) {
 $username = $row->username;
 }

Hope this tutorial can be useful to you when coding in CodeIgniter Framework

Reference :

http://www.codeigniter.com/user_guide/database/results.html