php - Codeigniter "group_by"查询不起作用？

Question

我一直在努力让它发挥作用，但似乎无济于事。

问题是，数据没有在 View 中显示为组合框，它显示了这个错误；

A PHP Error was encountered Severity: Notice Message: Undefined property: stdClass::$Campus Filename: views/energy_search_campus.php Line Number: 28 " >c_name.

所以不知道问题出在哪里……在模型、 View 、 Controller 甚至数据库中。提前致谢。

型号:

function campus_finder()
{
    $this->db->group_by('campus');
    $this->db->order_by('faculty', 'asc');
    $query = $this->db->get('cpanel_energy');
    if($query->num_rows()>0) {
        foreach($query->result() as $row) {
            $services[$row->id] = $row;
        }
        return $services;
    }
}

查看:

<div class="finder">
    <div>
        <label>Campus</label>
    </div>
    <select
            id="campus"
            name="campus"
            class="form-control"
        >
            <option value="">----</option>
        <?php foreach($catalogue as $item): ?>
            <option value="<?php echo $item->Campus; ?>"
            <?php if($campus) echo ($item->campus==$campus)? 'selected' : ''; ?>
            ><?php echo $item->campus; ?></option>
        <?php endforeach; ?>
        </select>
</div>

Controller :

function campus_search()
{
    $submit = $this->input->post('send');
    $campus = $this->input->post('campus');
    $year = $this->input->post('year');
    if($submit=='goback')
    {
        redirect("energy/catalogue/");
    }
    else
    {
        $data['catalogue']  = $this->model_energy_consumption->campus_finder();
        $data['voucher']    = $this->model_energy_consumption->results_campus();
        $data['services']   = $this->modelo_energy_consumption->services_catalogue_campus();
        $data['campus'] = $campus;
        $data['year'] = $year;

数据库:

MAINTENANCE_JOB_ITEMS
|----|---------|---------|--------|
| id | account | faculty | campus |
|----|---------|---------|--------|
  1    898946    f_name    c_name

Answer 1

在模型中，您返回 $services ，但值保存在 $servicios 变量中