Codeigniter - 如何访问 result_array()

Question

我的控制器中有一个方法如下：

function surcharge_load_data(){

    $data = $this->Surcharge_model->surcharge_load_data();   

    foreach($data->result_array() as $r) {

           echo $r->surcharge_id;

      }

 }

Surcharge_model 方法返回一个结果数组。这是我在模型中的方法：

function surcharge_load_data(){

    $this->db->order_by('surcharge_id', 'DESC');

    $query = $this->db->get('surcharges');

    return $query->result_array();

}

上述方法返回的数据如下所示：

[{"surcharge_id":"37","surcharge_curr":"EUR","surcharge_name":"MNM","surcharge_unit_id":"3","surcharge_value":"43","surcharge_category_id":"3","created_timestamp":"2019-06-03 06:18:18","updated_timestamp":"2019-09-01 08:19:18"},

{"surcharge_id":"36","surcharge_curr":"EUR","surcharge_name":"TOY","surcharge_unit_id":"3","surcharge_value":"433","surcharge_category_id":"3","created_timestamp":"2019-07-09 09:21:21","updated_timestamp":"2019-09-10 09:21:21"}]

几个问题如下：

(1) 整个数据封装在[]中。这是否意味着它返回了一个带有数组数组的大对象？

(2) 为什么会报错，Call to a member function result_array() on array？我认为 $data 是一个结果数组。请问我怎样才能访问它？

Answer 1

试试这个，result_array()这里不用用function surcharge_load_data(){    $data = $this->Surcharge_model->surcharge_load_data();       foreach($data as $r) {//changes           echo $r['surcharge_id'];      } }在这里，你正在使用，result_array()所以你需要使用每个对象，$r['surcharge_id']如果你使用，result()那么你需要使用$r->surcharge_id

Answer 2

从您的控制器中，您无法检索该result_array方法，因为它仅存在于您的模型中。因此，在您的控制器中，您可以从模型中读取答案，例如：function surcharge_load_data(){    $data = $this->Surcharge_model->surcharge_load_data();       foreach($data as $r) {            //just here you can retrieve your data           ...      } }您在控制器中收到$data的模型的结果（在返回之前$query->result_array()）在哪里