在codeigniter中显示动态类别中的数据和数据库中的动态数据

Question

我有三类，像故事，电影故事，照片

我想显示数据类别明智的数据从数据库

1.故事*data1*data2*data3

2.电影故事*data1*data2*data3

控制器：

    function __construct(){
        parent::__construct();
          $this->load->model('home_model');
}

public function index()
{
    $data['header_menu'] = $this->home_model->get_header_menu();
    $data['category'] = $this->home_model->get_category();
    $data['home_cat'] = $this->home_model->get_cat_data();

    $this->load->view('home/header',$data);
    $this->load->view('home/homepage');
    $this->load->view('home/footer');
}

型号：

function __construct(){
    parent::__construct();

}

function get_header_menu(){
    $query = $this->db->get('header_menu');
    return $query->result_array();
}


function get_category(){
    $query = $this->db->get('category');
    return $query->result_array();
}


function get_cat_data(){

    $this->db->select('*');
    $this->db->from('category');
    $this->db->join('home_page','category.id = home_page.c_id','left');
    $this->db->where('category.id = home_page.c_id');

    $this->db->group_by('home_page.id');
    $query = $this->db->get();
    return $query->result_array();
}

查看：

 <div class="container">
<div class="row">


    <?php foreach($category as $cate) { ?>
    <div class="col-md-4">
        <div class="table-responsive">
            <table class="table table-bordered table-bordered">
                <tr>
                    <th class="success"><?php echo $cate['categories']?></th>
                </tr>
                <tr>
                    <td><?php foreach ($home_cat as $homecat){?>
                                            <a href="#"><?php echo $homecat['category_title']?></a>
                    <hr>
                                            <?php } ?></td>
                </tr>
            </table>
        </div>
    </div>

    <?php } ?>
    </div>

数据库：

创建表home_page：

创建表home_page（idint（11）not NULLAUTO_INCREMENT，p.idint（11）DEFAULT NULL，c_idint（11）DEFAULT NULL，category_titletext，category_url 文本，category_image文本，PRIMARYKEY（id））ENGINE=InnoDBAUTO_INCREMENT=14默认CHARSET=latin1

类别： id int（11）NO NULLcategories_name文本NULL




Answer 1

这不是一个确切的答案你要加强这一个

在每个Foreach循环中添加if条件来过滤类别，如下所示

<?php foreach($catagory as $cata) { ?>

<td><?php foreach ($home_cat as $homecat){

        if($cata['id']==$homecat['c_id'])
         {
         //here we filter the value categorywise 
        ?>
         <a href="#"><?php echo $homecat['catagory_title']; ?></a>

      <?php } ?></td>

    <?php   }

   } ?>