我与我的php(CI bootstrap(作业代码相处,我将解释它的(简化(详细信息:
- 有一个名为"大学"one_answers"学生"one_answers"教师"表的DB
- "学生"表中有" Acculty_id"
- 在" Acculty_profile"视图中,有一份"入学学生"的列表
这是我的MVC代码:
模型
function get_data($table)
{
return $this->db->get($table);
}
控制器
public function faculty_profile($id)
{
$where = array('faculty_id' => $id);
$data['faculty'] = $this->db->query("select * from faculty f, students s where f.faculty_id=s.faculty_id and f.faculty_id='$id'")->result();
$this->load->view('faculty_profile', $data);
}
视图(简化(
<?php foreach($faculty as $f) { ?>
<tr>
<td><?php echo $f->faculty_name?></td>
</tr>
<tr>
<td><?php echo $f->head_of_faculty?></td>
</tr>
<tr>
<td>
<b>Students enrolled in this faculty</b>
<?php echo $f->students_name?>
</td>
</tr>
<?php } ?>
(简化的(结果在下面(我在同一教师中注册了2行(:
------
Information Technology //faculty_name
Mr. Henry //head_of_faculty
Students enrolled in this faculty
Adam
------
------
Information Technology //faculty_name
Mr. Henry //head_of_faculty
Students enrolled in this faculty
Brian
------
下面是我想要的:
------
Information Technology //faculty_name
Mr. Henry //head_of_faculty
Students enrolled in this faculty
Adam
Brian
------
问题是,我必须在哪里修补才能获得所需的结果?
哦,我已经尝试将2 for 2 for hise(ES(放在上面:
<?php foreach($faculty as $f) { ?>
<tr>
<td><?php echo $f->faculty_name?></td>
</tr>
<tr>
<td><?php echo $f->head_of_faculty?></td>
</tr>
<?php foreach($faculty as $f) { ?>
<tr>
<td>
<b>Students enrolled in this faculty</b>
<?php echo $f->students_name?>
</td>
</tr>
<?php } ?>
<?php } ?>
这是结果:
------
Information Technology //faculty_name
Mr. Henry //head_of_faculty
Students enrolled in this faculty
Adam
Brian
------
------
Information Technology //faculty_name
Mr. Henry //head_of_faculty
Students enrolled in this faculty
Adam
Brian
------
预先感谢,任何帮助始终将不胜感激
您提到了该视图" catulty_profile"仅显示学生参加该教师的信息。这意味着它将仅显示1个教师。因此,您不需要循环$教师。更改下面的控制器代码。
$data['faculty'] = $this->db->query("select * from faculty f where f.faculty_id='$id'")->result();
$data['faculty']['students'] = $this->db->query("select * from students s where s.faculty_id='$id'")->result();
$this->load->view('faculty_profile', $data);
更改您的视图如下
<tr>
<td><?php echo $faculty->faculty_name?></td>
</tr>
<tr>
<td><?php echo $faculty->head_of_faculty?></td>
</tr>
<tr><td>Students enrolled in this faculty</td></tr>
<?php foreach($faculty['students'] as $student ) { ?>
<tr>
<td>
<?php echo $student->students_name?>
</td>
</tr>
<?php } ?>