致命错误:在Codeigniter中的非对象上调用成员函数result(） - Fatal error: Call to a member function result() on a non-object in Codeigniter

Fatal error: Call to a member function result() on a non-object in Codeigniter

致命错误：在第111行的D:''wamp''www''ocss''application''core''My_Model.php中的非对象上调用成员函数result（）

class Report extends MY_Controller{
    public function item_ladger()
    {
        $material = $this->Material_Model->get(); // when i call it here it works fine
        $inventory = $this->db->query("CALL inventory($id)")->result_array();
        $material = $this->Material_Model->get(); // when i call it here it Generate Fatal error: Call to a member function result() on a non-object in
    }
}

背后的原因是什么？

编辑

这是我的材料模型，它有表名和所有的表字段

class Material_Model extends MY_Model
{
    const DB_TABLE = 'material';
    const DB_TABLE_PK = 'material_id';
    public $material_id;
    public $material_name;
    public $size;
    public $rate;
}

这是我的my_Model，它有表名和获取所有结果的方法

class MY_Model extends CI_Model {
    const DB_TABLE = 'abstract';
    const DB_TABLE_PK = 'abstract';
    public function get($limit = 500, $offset = 0,$desc=true) {
    if ($limit) {
        if ($desc)
            $query = $this->db->order_by($this::DB_TABLE_PK, 'DESC')->get($this::DB_TABLE, $limit, $offset);
        else
            $query = $this->db->get($this::DB_TABLE, $limit, $offset);
    }
    else {
        $query = $this->db->get($this::DB_TABLE);
    }
    $ret_val = array();
    $class = get_class($this);
    foreach ($query->result() as $row) {
        $model = new $class;
        $model->populate($row);
        $ret_val[$row->{$this::DB_TABLE_PK}] = $model;
    }
    return $ret_val;
}

最后，我通过简单地调用mysql查询而不是存储过程来解决了我的问题

class Report extends MY_Controller{
    public function item_ladger()
    {
        $material = $this->Material_Model->get(); // when i call it here it works fine
        $inventory = $this->db->query("My Query To Database")->result_array();
        $material = $this->Material_Model->get(); // now when i call it here there is no error
    }
}

但当调用存储过程而不是查询

时，我混淆了我的错误

class Report extends MY_Controller{
    public function item_ladger()
    {
        $this->load->model("Material_Model"); # loding Model
        $inventory = $this->Material_Model->get_data(); # caling Model to do my code
        if ($inventory['cup']) { # retrivig data from retund array
            echo "I never ate Cup Cakes";
        }
    }
}

在模型中

public function get_data()
{
    $query = $this->db->get('cake'); # get data from table
    $result = $query->result_array(); # re-Assign as objective array
    return $result; # return data
}

代码点火器SELECT