How do i loop database in view with a specific table column value

Question

tb_stock:

+------------+--------------+-------------+------------+ | id_stock | name_stock | brand_id | price | +------------------------------------------------------+ | 1 | iPhone XS | 1 | 1299 | | 2 | galaxy s10 | 2 | 1000 | | 3 | galaxy s10+ | 2 | 1100 | | 4 | IWatch | 1 | 500 | +------------------------------------------------------+

From table above, i want to show only one brand in my checkbox loop. I have used foreach to get the value. But i got all of the brand in my checkbox. what i want is show only one brand and loop it.

controller:

public function index(){ $data['getStok'] = $this->M_input->getStok(); this->page->view('product', $data); }

model:

public function getStok(){ $query = $this->db->get('tb_stok'); return $query->result(); }

view:

<?php if(count($getStok)):?> <?php foreach ($getStok as $a):?> <div class="form-group"> <div class="col-sm-12"> <input type="checkbox" class="minimal" id="<?php echo $a->name_stok;?>" value=<?php echo $a->price;?>> <label><?php echo $a->name_stok;?></label> </div> </div> <?php endforeach;?> <?php else :?> <?php endif ;?>

I'm afraid It's unsure what the actual question is. Could you elaborate the what i want is show only one brand and loop it. means? — dev-cyprium
– dev-cyprium, Commented Mar 22, 2019 at 21:47
@dev-cyprium there's 2 brand_id in my table "1, 2", what i want is loop my table data and show only one of brand data that have id '1' or '2'. so, if i loop data where brand_id = 1, it will loop apple brand only. — codingan sampah
– codingan sampah, Commented Mar 23, 2019 at 7:26

krlv · Accepted Answer · 2019-03-22 21:48:31Z

If you need to show only one brand at a time, you can do it in several ways:

Filter only one brand in the view for loop. This is not the optimal way, because you move your business logic to the View level of MVC.
Filter a single brand in the model. This is a better way, because Model considered to be a proper place for business logic.

Here you can find more explanations about business logic in MVC

You can achieve the second approach with just a few changes in your model (and controller)

controller:

public function index() { // assuming you get the brand ID to display from GET request $brandId = $this->input->get('brand_id'); $data['getStok'] = $this->M_input->getStokByBrandId($brandId); this->page->view('product', $data); }

model:

public function getStokByBrandId($brandId) { $query = $this->db->where('brand_id', $brandId)->get('tb_stok'); return $query->result(); }

view:

no changes needed

Actually i have solved this problem. same as your model, i doing it in the same way. Thanks for your response. I'll mark your answer as accepted answer.

Collectives™ on Stack Overflow

How do i loop database in view with a specific table column value

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related