doudizhi947129 2015-02-26 02:17
浏览 59
已采纳

Codeigniter中的数组到字符串转换错误。 result_array()和array_unique()

I just what to turn the result array from my query (which is only has one column) to a unique array so it doesnt have repeated elements.

I don't know what else to do, I've tried everything, what am I doing wrong?

Model:

public function get_info()
    {
        $this->db->select('column');
        $this->db->from('table');
        $query=$this->db->get()->result_array();

        $out=array_unique($query);
        return $out;

    }

Controller:

public function index()
{
    $this->load->model('the_model');
    $data['stuff']=$this->the_model->get_info();
    $this->load->view('the_view',$data);
}

View:

       <?php 
          foreach($stuff as $i)
         {
          echo "$i['column']}";
         }
        ?>

The error I get is this:

A PHP Error was encountered 
Severity: Notice 
Message: Array to string conversion 
Filename: models/the_model.php
  • 写回答

1条回答 默认 最新

  • dongtan9518 2015-02-27 15:29
    关注

    Add a DISTINCT in the query so the result doesn't have repeated values.

    public function get_info()
    {
        $this->db->select('column');
        $this->db->distinct();
        $this->db->from('table');
        $query=$this->db->get()->result_array();
    
        $out=array_unique($query);
        return $out;
    
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集