dongzi0857 2014-08-03 08:51
浏览 139
已采纳

Codeigniter选择distinct并传递变量列表

Just want to SELECT DISTINCT country FROM table WHERE user_id=$user_id, pass the country list from model to controller and then pass the JSON representation of the country list but as I am a newbie in Codeigniter I am not sure if wrote the query correctly and if I return the list or a single value. Could you please check my code.

Model:

public function did_get_country_list($user_id) {

        $this->db->distinct('country');
        $this->db->where('user_id',$user_id);
        $query = $this->db->get('table');

        if ($query->num_rows() >= 1) {
         foreach ($query->result() as $row)
        {
            $country = $row->country;
        }
        return $country;
        }
        else{
         return false;
        }       
    }   

Controller:

$country = $this->model_users->did_get_country_plans($user_id);

echo json_encode($country);
  • 写回答

1条回答 默认 最新

  • doudang9147 2014-08-03 08:57
    关注

    Your code looks almost ok to me, but I think you should change 2 lines:

    1) Remove the check for num_rows before the actual query.

    2) To return an array of countries, add [] at the end of $country to push the new values.

    So, instead of this snippet:

        if ($query->num_rows() >= 1) {
         foreach ($query->result() as $row)
        {
            $country = $row->country;
        }
        return $country;
        }
        else{
         return false;
        }
    

    You would have:

        $country = false;
        foreach ($query->result() as $row)
        {
            $country[] = $row->country;
        }
        return $country;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗