ClassID Missing!';
} if( empty( $subject_id ) ) {
$error .='SubjectID Missing!';
} if( empty( $exam_id ) ) {
$error .='ExamID Missing!';
}
if(empty( $error ) && (wpsp_IsMarkEntered( $class_id, $subject_id, $exam_id ) ) ) {
$extra_tbl = $wpdb->prefix."wpsp_mark_fields";
$student_table = $wpdb->prefix."wpsp_student";
// $extra_fields = $wpdb->get_results("select * from $extra_tbl where subject_id='".esc_sql($subject_id)."'");
$extra_fields = $wpdb->get_results($wpdb->prepare("SELECT * FROM $extra_tbl WHERE subject_id = %d",$subject_id));
$wpsp_marks = wpsp_GetMarks($class_id,$subject_id,$exam_id);
$wpsp_exmarks = wpsp_GetExMarks($subject_id,$exam_id);
if( isset($_POST['ClassID'] )) {
$class_id=sanitize_text_field($_POST['ClassID']);
$stl = [];
// $studentlists = $wpdb->get_results("select class_id, sid from $student_table");
$studentlists = $wpdb->get_results(
$wpdb->prepare("SELECT class_id, sid FROM $student_table")
);
foreach ($studentlists as $stu) {
if(is_numeric($stu->class_id) ){
if($stu->class_id == $class_id){
$stl[] = $stu->sid;
}
}
else{
$class_id_array = unserialize( $stu->class_id );
if(!empty($class_id_array)){
if(in_array($class_id, $class_id_array)){
$stl[] = $stu->sid;
}
}
}
}
}
$students_list = $extra_marks = array();
if (!empty($stl)) {
$stl = array_map('intval', $stl);
foreach ($stl as $id ) {
$id = esc_sql($id);
$q = $wpdb->prepare("SELECT s_rollno,wp_usr_id,s_fname,s_mname,s_lname FROM $student_table WHERE sid = %d",$id);
$class_students = $wpdb->get_results($q,ARRAY_A);
foreach($class_students as $cstud){
$students_list[$cstud['wp_usr_id']]=array('rollno'=>$cstud['s_rollno'],'name'=>$cstud['s_fname'].' '.$cstud['s_mname'].' '.$cstud['s_lname']);
}
}
}
foreach($wpsp_exmarks as $exmark){
$extra_marks[$exmark->student_id][$exmark->field_id]=$exmark->mark;
}
?>
Marks not yet entered!";
?>