Fatal error: Cannot use object of type CI_DB_mysql_result as array

Question

I have read 1, 2 and several other threads prior to post this issue but none of them solved my problem. I am totally new with PHP and got stuck in attempting to learn MVC with codeigniter. The function which causing error is

public function get_results() 
{ 
    $libraries = array("", "JQuery", "MooTools", "YUI Library", "Glow"); 
    $table_rows = ''; 

    for ($i = 1; $i < 5; $i++) 
    {
         $this->db->select('COUNT(choice) choices_count')->from('js_libraries')->where('choice',$i);
         $result = $this->db->get();
         $table_rows .= "<tr><td>" . $libraries[$i] . " Got:</td><td><b>" . $result[0] . "</b> votes</td></tr>"; 
         
    } 
 }

I have executed the query on phpmyadmin and it shows result (a single integer) but I am unable to make this CI_DB_mysql_result object work. I have tried all result(), result_array(), getResult() functions but it says undefined functions for this kind of object. How can I get result from CI_DB_mysql_result?

Add result_array method to get result as array. $result = $this->db->get()->result_array(); — Atal Prateek
– Atal Prateek, Commented Mar 12, 2021 at 11:33
I did this but it gave me Array to string conversion error on next line when getting results from $result[0] — aneela
– aneela, Commented Mar 12, 2021 at 11:50

Atal Prateek · Accepted Answer · 2021-03-12 12:00:25Z

1

Ok. Thats because result_array returns 2D array which contains multiple rows from table. In this case you want only one row so you can use either of the following:

row() method which returns result as object. $result = $this->db->get()->row(); Then $result->choices_count to get count value.
row_array() method which returns result as array. $result = $this->db->get()->row_array(); Then $result['choices_count'] to get count value.
unbuffered_row() method which returns result as object $result = $this->db->get()->unbuffered_row(); Then $result->choices_count to get count value.
unbuffered_row('array') method which returns result as array. $result = $this->db->get()->unbuffered_row('array'); Then $result['choices_count'] to get count value.

answered Mar 12, 2021 at 12:00

Atal Prateek

5413 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

Fatal error: Cannot use object of type CI_DB_mysql_result as array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related