Codeigniter简单foreach循环不工作

如果您使用的是Codeigniter，为什么不使用Codeigniter的MVC呢？你不应该在View.php上查询，而应该在Model.php 上查询

型号：

 public function MODELFUNC()
    {
    $homeigw = $CI->db->query("SELECT * FROM data INNER JOIN trunk_info ON trunk_id =     trunc_group WHERE trunk_type = 'igw'");
     if ($homeigw->num_rows() > 0 )
        {
    $result = $homeigw->result();
        }
    return $result;
    }

控制器：

public function CONTFUCN()
{
$data['varData'] = $this->MODEL->MODELFUNC();
$this->load->view(<ViewName>, $data);
}

视图：

<?php <tr><th>ID</th></tr>
foreach($varData in varDat)
{
echo "<td>" . $varDat->id ."</td>";
}
?>

在视图页面$中，可能无法正常工作

试试这个

$CI= &get_instance();
<?php  $homeigw = $CI->db->query("SELECT * FROM data INNER JOIN trunk_info ON trunk_id = trunc_group WHERE trunk_type = 'igw'");
        foreach($homeigw->result() as $igww){
                    echo $igww->id;
          }

首先检查查询是否返回结果。要检查这一点，你可以把条件像：

if($homeigw->num_rows() >0) {
    foreach($homeigw->result() as $igww){
          echo $igww->id;
    }
} else { 
   echo 'empty result set';
}

首次使用

print_r（$homeigw）；出口

检查结果，然后相应地使用foreach循环。

<?php
class plan_model extends CI_Model {
    public function __construct()
    {
        $this->load->database();
    }
    public function getevents()
    {
        $json = array();
        $query =$this->db->query("(select a.id,REPLACE(a.interest,'@',',') AS title,a.start,a.end,a.allDay,a.className,a.color from ta_plan a ) union (select b.id,substr(c.name,1,15) AS title,b.start,b.end,b.allDay,b.className,b.color from ta_trips b join ta_city c on b.city_id=c.id order by b.id)");
        echo json_encode($query->result_array());
    }
    public function getplandetails($id)
    {
        $query =$this->db->query("SELECT id,city_id,creator_id,plan_desc,standard_activity_id,meeting_address,capacity,start,end,start_time,end_time,title,interest FROM ta_plan where id ='".$id."' ");
        return $query->row_array();   
    }
    public function getactivitydetails($id)
    {
        $query =$this->db->query("SELECT id,interest,city_id,start FROM ta_plan where creator_id ='".$id."' ");
        return $query->result_array();   
    }
    public function gettripdetails($id)
    {
        $query =$this->db->query("SELECT hotel,hotel_address,city_id,start,end FROM ta_trips where traveller_id ='".$id."' ");
        return $query->result_array();   
    }
    public function getprofiledetails($id)
    {
        $query =$this->db->query("SELECT email_id,public_email,facebook_id,public_facebook_id,photo,public_photo,desk_photo,name,public_name,nationality,public_nationality,gender,public_gender,dob,public_dob,marital_status,public_marital_status,home_location,public_home_location,traveller_type,public_traveller_type,traveller_profession,public_traveller_profession,traveller_interest,public_traveller_interest FROM ta_user_profile where id ='".$id."' ");
        return $query->row_array();   
    }
    public function gethoteletails($id)
    {
        $query =$this->db->query("SELECT id,name,email_id,location,address,phone,description,facebook_id,photo FROM ta_hotel_profile where id ='".$id."' ");
        return $query->row_array();   
    }
    public function getactivitysearch($start,$end)
    {
        if($start!='' && $end!='')
        {
            $query =$this->db->query("select b.creator_id,a.name as username,a.gender,a.home_location,a.dob,a.desk_photo,a.photo,a.email_id,b.id,b.interest,c.name as cityname,b.start from ta_user_profile a join ta_plan b on a.id=b.creator_id join ta_city c on b.city_id=c.id where b.start >='".$start."' and b.end <='".$end."' ");
        }
        else if($start!='' && $end=='')
        {
            $query =$this->db->query("select b.creator_id,a.name as username,a.gender,a.home_location,a.dob,a.desk_photo,a.photo,a.email_id,b.id,b.interest,c.name as cityname,b.start from ta_user_profile a join ta_plan b on a.id=b.creator_id join ta_city c on b.city_id=c.id where b.start <='".$start."' and b.end >='".$start."' ");
        }
        else if($start=='' && $end!='')
        {
            $query =$this->db->query("select b.creator_id,a.name as username,a.gender,a.home_location,a.dob,a.desk_photo,a.photo,a.email_id,b.id,b.interest,c.name as cityname,b.start from ta_user_profile a join ta_plan b on a.id=b.creator_id join ta_city c on b.city_id=c.id where b.start <='".$end."' and b.end >='".$end."' ");
        }
       return $query->result_array();
    }
    public function get_activity_list($start)
    {
       $query =$this->db->query("SELECT id,city_id,creator_id,plan_desc,standard_activity_id,meeting_address,capacity,start,end,start_time,end_time,title FROM ta_plan where start <='".$start."' and end >='".$start."' ");
       return $query->result_array();
    }
    public function autocomplete_city($val)
    {
        $query =$this->db->query('select id,country,state,name from ta_city where name LIKE "%'.$val.'%"');
    return $query->result();        
    }
    public function get_hotel_list($val)
    {
        $query =$this->db->query('select id,name from ta_hotel_profile where location LIKE "%'.$val.'%"');
    return $query->result_array();        
    }

    public function get_standard_list($val)
    {
        $query =$this->db->query('select id,title,description,picture from ta_standard_activity where destination_name LIKE "%'.$val.'%"');
    return $query->result_array();        
    }
    public function get_hotel_addr($val)
    {
        $query =$this->db->query("select id,name,address from ta_hotel_profile where id='".$val."' ");
    return $query->result_array();        
    }
    public function getcityname($val)
    {
        $query =$this->db->query("select name from ta_city where id='".$val."' ");
    return $query->row_array();     
    }
    public function getusername($val)
    {
        $query =$this->db->query("select name,id from ta_user_profile where id='".$val."' ");
    return $query->row_array();   
    }
    public function get_std_desc($val)
    {
        $query =$this->db->query("select id,description,picture,title from ta_standard_activity where id='".$val."' ");
    return $query->result_array();        
    }

    public function savetrip($city,$hotelid,$hotel,$hoteladdr,$start,$end,$start_time,$end_time,$id)
    {
            $insert_data = array(
            'city_id' => $city,
            'hotel_id' => $hotelid,
            'hotel' => $hotel,
            'hotel_address' => $hotel_addr,
            'start' => $start,
            'end' => $end,
            'start_time'=>$start_time,
            'end_time'=>$end_time,
            'traveller_id'=>$id
            );
            $this->db->insert('ta_trips', $insert_data);
            return $this->db->insert_id();
    }
    public function save_temp_hotel($hotel,$hoteladdr,$id)
    {
            $insert_data = array(
            'hotel_name' => $hotel,
            'hotel_address' => $hoteladdr,
            'hotel_id'=>$id
            );
            $this->db->insert('ta_hotel_temp', $insert_data);
    }
    public function saveactivity($cityid,$stdid,$chk_interest,$title,$description,$start,$end,$start_time,$end_time,$capacity,$flag,$address,$meeting_loc,$id)
    {
            $insert_data = array(
            'city_id' => $cityid,
            'standard_activity_id' => $stdid,
                        'interest' => $chk_interest,
            'title' => $title,
            'plan_desc' => $description,
            'start' => $start,
            'end' => $end,
            'start_time'=>$start_time,
            'end_time'=>$end_time,
                        'capacity' => $capacity,
            'approval_flag' => $flag,
                        'meeting_address' =>$address,
            'meeting_coordinates'=>$meeting_loc,
            'creator_id'=>$id
            );
            return $this->db->insert('ta_plan', $insert_data);
    }
}
?>

class plan_model extends CI_Model {
    public function __construct()
    {
        $this->load->database();
    }
    public function getevents()
    {
        $json = array();
        $query =$this->db->query("(select a.id,REPLACE(a.interest,'@',',') AS title,a.start,a.end,a.allDay,a.className,a.color from ta_plan a ) union (select b.id,substr(c.name,1,15) AS title,b.start,b.end,b.allDay,b.className,b.color from ta_trips b join ta_city c on b.city_id=c.id order by b.id)");
        echo json_encode($query->result_array());
    }
}