Styjun

I'm trying to implement the concept of dictionary which i use in c# in order to collect multiple records based on multiple id's. But i hardly find any such thing in codeigniter framework. What I have is a Course table and another table naming course_prices. Now each course has multiple prices. And I'm trying to display using bootstrap according having course name as title of header accordion and list of prices on the content div.

As i couldn't find the concept of dictionary here, i tried with writing join query but that wouldn't help. The details of courses are repeated.

Below is my code

$this->load->model('Courses_model', 'Courses');

 $model = $this->Courses;

 $records = $model->setAlias('c')
 ->find()
 ->select('c.*,cp.Id as PriceId')
 ->join('course_price AS cp', 'c.id = cp.CourseId')
 ->get()
 ->result_array();

And this is the view

<?php if(empty($courses)) print_r("no class available"); else{ print_r($courses); foreach ($courses as $k => $course) ?>

 <div class="panel panel-default">
 <div class="panel-heading" role="tab" id="heading<?=$k?>">
 <h4 class="panel-title">
 <a class="" role="button" data-toggle="collapse" data-parent="#accordion9" href="#collapse<?=$k?>" aria-expanded="true" aria-controls="collapseOne9">
 <?= $course->name ?>
 </a>
 </h4>
 </div>
 <div id="collapse<?=$k?>" class="panel-collapse collapse" role="tabpanel" aria-labelledby="heading<?=$k?>">
 <div class="panel-body">

 <?php foreach ($course->course_price as $key => $price) ?>
 <div class="custom-controls-stacked">
 <div class="custom-control custom-radio">
 <input name="class" id="class_1<?= $k ?>" type="radio" class="custom-control-input" value="<?= $price->PriceId; ?>" required> 
 <label for="class_<?= $k ?>" class="custom-control-label">Drop In Price <?= $course->price ?></label>
 </div>
 </div>

 </div>
 </div>
 </div>
 <?php ?>