mysql - 在非对象上调用成员函数 result_array()

Question

请帮忙，我不知道这是我的模型出了什么问题

    public function searchstudents(){
    $establishment_name = $this->input->post('name');
    $address = $this->input->post('address');
    $establishment_name2 = "Nicole's Apartment";


        $query = $this->db->query("SELECT u.id as id, u.first_name as firstname, u.middle_name as                  middlename, u.last_name as lastname, e.name as establishmentname FROM users u, beds b, room r, establishment e WHERE  r.establishment_id = e.id AND u.id = b.student_id  AND b.room_id = r.room_id AND e.name = '$establishment_name2' ");

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

    return $query->result_array(); 

}

当我删除 AND e.name = '$election_name2' 时，它可以工作，但是当我包含它时，它会导致调用非对象上的成员函数 result_array() 。我在 mysql 中尝试了查询，它可以工作，但在 codeigniter 中不起作用。

Answer 1

这是一个蜱虫问题:

$establishment_name2 = "Nicole's Apartment";

变成:

e.name = 'Nicole's Apartment' 

在您的查询中

使用addslashes()或者像Mudshark所说的那样转义