Codeigniter Array Display

Question

I want to display values of an array, but it only displays one value of the array rather than all values of the array.

Model:

function get_subject_position($exam_id , $class_id , $subject_id ) {

        $this->db->where('exam_id' , $exam_id);
        $this->db->where('class_id' , $class_id);
        $this->db->where('subject_id' , $subject_id);
        $this->db->select('mark_obtained');
        $this->db->order_by('mark_obtained DESC');
        $subject_position = $this->db->get('mark')->result_array();
        foreach($subject_position as $row) {

             return $row;     
        }
        }

View:

$subject_pos = $this->crud_model->get_subject_position($row2['exam_id'], $class_id, $row3['subject_id']);

<td style="text-align: center;"><?php echo $subject_pos['mark_obtained'];?></td>

JamesBlandford · Accepted Answer · 2016-04-30 07:56:52Z

1

You need to move the "foreach" loop into your view, because right now it's returning the first $row, and then stopping the foreach loop ("return" stops looping)

Example:

View

<?php
$subject_pos = $this->crud_model->get_subject_position($row2['exam_id'], $class_id, $row3['subject_id']);
foreach($subject_pos as $row) {
?>
<tr>
    <td style="text-align: center;"><?=$row['mark_obtained']?></td>
</tr>
<?php } ?>

Function

function get_subject_position($exam_id , $class_id , $subject_id ) {

    $this->db->where('exam_id' , $exam_id);
    $this->db->where('class_id' , $class_id);
    $this->db->where('subject_id' , $subject_id);
    $this->db->select('mark_obtained');
    $this->db->order_by('mark_obtained DESC');

    return $this->db->get('mark')->result_array(); // Get ALL rows

    }

edited Apr 30, 2016 at 7:56

answered Apr 30, 2016 at 7:41

JamesBlandford

1781 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ranjeet Singh Over a year ago

you does'n send the result array return statement should be like this return $this->db->get('mark')->result_array();

4Jean Over a year ago

Thanks so much am grateful

4Jean Over a year ago

I want to use array_search() to find position of score in each subject, its not working i will ask a new question

Collectives™ on Stack Overflow

Codeigniter Array Display

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related