How to display data from multiple tables in View using codeigniter

Question

Student table

Result table

MY Question: Student table join result table ,but same student name display multiple, so My question I have same student display once

Model:

public function select(){
$this->db->select('*');
$this->db->from('result');
 $this->db->join('student', 'result.student_id=student.student_id');
 return $this->db->get()->result_array();
}

Controller:

public function index(){
  $data = array(
            'page_title' => 'Result',
            'page_name' => 'result/result',
            'result'=>  $this->result_model->select()
        );
$this->load->view('admin/template', $data);
}

View

 <?php foreach ($result as $key => $value): ?>
                <tr>
                    <td><?php echo $value['first_name']; ?></td>
 <td><?php echo $value['mark']; ?></td>
</tr>
<?php endforeach;?>

You use Group By Clause. $this->db->group_by('student.student_id'); — Mayank Vadiya
– Mayank Vadiya, Commented Jul 7, 2016 at 6:30

NikuNj Rathod · Accepted Answer · 2016-07-07 07:26:30Z

3

You can use Group By for display your record as one time

Add This code in your model:

Model:

<?php

Class Result_model extends CI_Model {

    public function __construct() {
        // Call the CI_Model constructor
        parent::__construct();
    }
    public function select(){
         $this->db->select('*');
         $this->db->from('result');
         $this->db->join('student', 'result.student_id=student.student_id');
         $this->db->group_by('student.student_id');
         return $this->db->get()->result_array();
    }
}

edited Jul 7, 2016 at 7:26

NikuNj Rathod

1,6381 gold badge19 silver badges29 bronze badges

answered Jul 7, 2016 at 6:33

Mayank Vadiya

1,4512 gold badges19 silver badges32 bronze badges

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

1 Comment

kishankakadiya Over a year ago

@Nikunj Rathod I have create sudent marksheet and above result table in all columns join multiple table but student name,exam name,section name,standard id,subject name all columns duplicate, And I have to create view Below: student name, maths,physics,chemestry below result display kishan kakadiya,30,40,50

user5746321 · Accepted Answer · 2016-07-11 11:57:46Z

0

try this model code.

public function select(){
$this->db->select('*');
 $this->db->join('student as st', 'st.student_id= re.student_id');
 return $this->db->get('result as re')->result_array();
}

answered Jul 11, 2016 at 11:57

user5746321

3 Comments

kishankakadiya Over a year ago

result table in all columns join and display markshit ,but duplicate records return why?

kishankakadiya Over a year ago

Marksheet View Below:

kishankakadiya Over a year ago

student Name,subject 1,subject 2,...sunject n

Collectives™ on Stack Overflow

How to display data from multiple tables in View using codeigniter

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related