php - 查询改进: foreach

Question

我有以下模型函数，我想知道如何改进它，并在需要时拉出所需的 $row ，这样我就不会收到 PHP 错误。

我如何提取所需的数据:

    $data['companyName'] = $this->core_model->companyDetails('coreCompanyName');

错误:

Undefined property: stdClass::$coreContactName
Undefined property: stdClass::$coreContactEmail

型号:

function companyDetails()
{
    $this->db->select('coreCompanyName, coreContactName, coreContactEmail');

    $this->db->from('core');

    $whereData = array('coreCompanyName' => $companyName, 'coreContactName' => $companyContactName, 'coreContactEmail' => $companyContactEmail);

    $this->db->where($whereData);

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

    $result = '';

    if ($query->num_rows() > 0)
    {

        foreach ($query->result() as $row)
        {
            $result .= $row->coreCompanyName;
            $result .= $row->coreContactName;
            $result .= $row->coreContactEmail;
        }
    }
    return $result;
}

Answer 1

应该是这样的

$this->db->select('coreCompanyName, coreContactName, coreContactEmail');

不是

$this->db->select('coreCompanyName','coreContactName','coreContactEmail');

参见引用http://codeigniter.com/user_guide/database/active_record.html#select

要限制特定的记录集，请使用 where() 函数。例如

$this->db->where('companyId', $companyId);