当我在谷歌自动完成中选择巴基斯坦拉合尔时;它应该自动选择 'Lahore' 仅用于类似的查询

Question

在模型中

function get_search_fuel_prices($fuel_city){
$this->db->select('*');
$this->db->from('fuel_price');
$this->db->like('fuel_city',$fuel_city);
return $this->db->get()->result();
}

Answer 1

//split the location by comma
$arr = explode(",",$fuel_city);
//then
$this->db->like('fuel_city',$arr[0]);