在视图中显示数据时遇到问题。我需要在视图中显示teacher's remark
。
我把它放在我的控制器<pre>';print_r($data);die
中,$data ['exam_result']输出老师的评语。
控制器:
public function view($id)
{
$data['exam_result'] = $this->examgroupstudent_model->searchStudentExams($student['student_session_id'], true, true);
$this->load->view('layout/header', $data);
$this->load->view('student/studentShow', $data);
$this->load->view('layout/footer', $data);
}
产品型号:
public function searchStudentExams($student_session_id, $is_active = false, $is_publish = false) {
$inner_sql = "";
if ($is_active) {
$inner_sql = "and exam_group_class_batch_exams.is_active=1 ";
}
if ($is_publish) {
$inner_sql .= "and exam_group_class_batch_exams.is_publish=1 ";
}
$sql = "SELECT exam_group_class_batch_exam_students.*,exam_group_class_batch_exams.exam_group_id,exam_group_class_batch_exams.exam,exam_group_class_batch_exams.date_from,exam_group_class_batch_exams.date_to,exam_group_class_batch_exams.description,exam_groups.name,exam_groups.exam_type FROM `exam_group_class_batch_exam_students` INNER JOIN exam_group_class_batch_exams on exam_group_class_batch_exams.id=exam_group_class_batch_exam_students.exam_group_class_batch_exam_id INNER JOIN exam_groups on exam_groups.id=exam_group_class_batch_exams.exam_group_id WHERE student_session_id=" . $this->db->escape($student_session_id) . $inner_sql . " ORDER BY id asc";
$query = $this->db->query($sql);
$student_exam = $query->result();
if (!empty($student_exam)) {
foreach ($student_exam as $student_exam_key => $student_exam_value) {
$student_exam_value->exam_result = $this->examresult_model->getStudentExamResults($student_exam_value->exam_group_class_batch_exam_id, $student_exam_value->exam_group_id, $student_exam_value->id, $student_exam_value->student_id);
}
}
return $student_exam;
}
查看方式:
Teacher's Remark: <?php echo $student->teacher_remark; ?>;
1条答案
按热度按时间kdfy810k1#
这就是我在我看来