代码点火器错误，如果“；未找到结果”；或者没有”；输入被输入”；；其他方法都很好 - Codeigniter error if "no result found" or no "input was entered"; Else works fine

Codeigniter error if "no result found" or no "input was entered"; Else works fine

我正处于学习阶段，正在尝试开发这个搜索结果应用程序。如果找到了结果，一切都很好，但如果没有输入或没有结果，则显示这两个错误；

消息：未定义的偏移量：0

消息：正在尝试获取非对象的属性

这就是发生错误的地方search_model.php

function get_city_id_by_input($keyword){
    $this->db->select('id');
    $this->db->from('vbc_city');
    $this->db->where('v_city_name', $keyword);
    $query = $this->db->get();
    $query_result = $query->result();
    $row = $query_result[0];
    return $row->id;
}

控制器：

$keyword = $this->input->post('search[1]');
$city_id = $this->search_model->get_city_id_by_input($keyword);
$data['results'] = $this->search_model->get_search_results($city_id);
$this->load->view('search', $data);

像这样尝试

在模型中

function get_city_id_by_input($keyword){
    $this->db->select('id');
    $this->db->from('vbc_city');
    $this->db->where('v_city_name', $keyword);
    $query = $this->db->get();
    $query_result = $query->result_array(); # Changed
    if (empty($query_result)) {
        return FALSE;
    }
    elseif (count($query_result) > 1) {
        return 0;
    }
    else{
        $rowId = $query_result[0]['id']; # Changed
        return $rowId; # Changed    
    }
}

在控制器中

$keyword = $this->input->post('search[1]');
if (empty($keyword)) {
    echo "Input is Empty";
}
else{
    $city_id = $this->search_model->get_city_id_by_input($keyword);
    $result = $this->search_model->get_search_results($city_id);
    if ($result == FALSE) {
        echo "No Data Found";
    }
    elseif ($result == 0) {
        echo "Multiple of records founds";
    }
    else{
        $data['results'] = $result
        $this->load->view('search', $data);
    }
}