循环遍历表以显示register_id =的所有图像？ 在codeigniter

Question

i've been working on a project for a while now using CodeIgniter. I want to display all images of same $register_id from the database with a foreach loop on the view.php.

Controller:

public function view($register_id = NULL){

    $data['image'] = $this->image_model->get_all_images($register_id);

    if(empty($data['image'])){
        show_404();
    }

    $data['title'] = $data['image']['register_id'];

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

Model

public function get_all_images($register_id = FALSE){
        $query = $this->db->get_where('images', array('register_id' => $register_id));
            return $query->row_array();
    }

view.php

<?php foreach ($image as $img) : ?>
<div class="col-md-3">
    <h3><?php echo $image['title']; ?></h3>
    <div class="img-box">
        <img class="post-thumb" src="<?php echo site_url(); ?>assets/images/portfolios/<?php echo $image['register_id'];?>/<?php echo $image['url']; ?>">
    </a></div>

Shows same image 14 times..

query works perfectly on phpmyadmin & shows diff. images..

Answer 1

change your forloop variable. and its value variable too. may be solve.

 <?php foreach ($image as $value){?>
 <div class="col-md-3">
    <h3><?php echo $value['title']; ?></h3>
    <div class="img-box">
        <img class="post-thumb" src="<?php echo site_url(); ?>assets/images/portfolios/<?php echo $value['register_id'];?>/<?php echo $value['url']; ?>">
    </a>
  </div>