duancheng3342 2013-12-09 19:17
浏览 31

Codeigniter:从数组中追加的值

public function func1()
{
    $this->func();
    $result1 = $this->result;

    foreach ($result1 as $row) {
        $this->load->model('test_model');
        $this->db->select('name');
        $this->db->from('place');

        $string = '';

        $string = $row[state_name];

        $this->db->where('state'=,"$string");
        $query = $this->db->get();

        return $query->result_array();
    }

}

where $this->func(); is getting an array containing an array of strings of names and I am using each value as condition in where clause in func1(select). I'm using A foreach loop to get each string from resultset of func and later on I'm trying to select a name matched from where clause in func1 but I am getting below error

A Database Error Occurred
    Error Number: 1064
    SELECT `name` FROM (`place`) WHERE `state=` 'place1,place2, place3,place4';

all the values from foreach is getting appended to the same query , where in my case each iteration should have fetched only one value and executed the SELECT query and returned the result.

  • 写回答

1条回答 默认 最新

  • dthyxna3894 2013-12-10 08:36
    关注

    Could you try this:

    public function func1()
    {
        $this->func();
        $result1 = $this->result;
    
        $data = null; $i=0;
        foreach ($result1 as $row) {
            $this->load->model('test_model');
            $this->db->select('name');
            $this->db->from('place');
    
            $string = '';
    
            $string = $row['state_name'];
    
            $this->db->where('state'=,"$string");
            $query = $this->db->get();
    
            $query->result_array();
            $data[$i] = $query->result_array;
        }
      return $data;
    
    }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 微信小程序协议怎么写
  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看