查询只返回codeigniter中的一行 [英] query return only a row in codeigniter

问题描述

在我的模型中，我有以下查询：

In my model I have the follow query:

function myquerydata() {
   $data = array();
   $query = $this->db->query('select max(field1) as field11, max(field2) as field22, max(field3) as field33 from my_table');
   foreach ($query->result() as $row) {
        $row->field11;
        $row->field22;
        $row->field33;
    }
}

此查询只返回一行。

在我的控制器中，我有下面的代码：

In my controller I have the next code:

$this->load->model('my_model');
$fields=$data['rows']=$this->my_model->myquerydata();

我的问题是如何从控制器调用数据字段11，field22，field33。当我应用一个foreach出现错误：

My question is how can I call the data field11, field22, field33 from controller. When I apply a foreach appears error:

foreach ($fields as $row){
  echo $row->field11,
  echo $row->field22,
  echo $row->field33,
}

我的错误是什么？

推荐答案

$ b

Do this:

function myquerydata() {

    $data = array();
    $query = $this->db->query('select max(field1) as field11, max(field2) as field22, max(field3) as field33 from my_table');
    //return the result and call from controller
    return $query->result();
}

并将以下内容放入您的控制器

And place the following in your controller

$this->load->model('my_model');
$fields=$data['rows']=$this->my_model->myquerydata();
print_r($fields);

这篇关于查询只返回codeigniter中的一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！