Codeigniter调用非对象上的成员函数num_rows（）

Question

Function in model file:

function get_user_by_email($email)
{
    //$this->consumer->where('email=', strtolower($email));
    //$query = $this->consumer->get($this->table_name); 

    $query = $this->db->query('CALL get_user_by_email("'.strtolower($email).'")');
    echo $query->num_rows();
}

This function returns error Call to a member function num_rows() on a non-object in whereas the other functions in the same file returns the row count. Also tried the active record query. But the query also returns the same error.

I tried using result(), result_array() also. But everything gives me error.

Thanks

Answer 1

I used $this->db->reconnect(); to reconnect to the database before calling the store procedure. This resolved the issue