prefix."wpsp_student"; $users_table = $wpdb->prefix."users"; $class_id=''; if( isset($_POST['ClassID'] ) && $_POST['ClassID'] != 'all' ) { $class_id=intval($_POST['ClassID']); $stl = []; // $parentlist = $wpdb->get_results("select class_id, sid from $student_table WHERE parent_wp_usr_id!='0'"); $parentlist = $wpdb->get_results($wpdb->prepare("SELECT class_id, sid FROM $student_table WHERE parent_wp_usr_id != %d",0)); foreach ($parentlist 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(is_array($class_id_array)){ if(in_array($class_id, $class_id_array)){ $stl[] = $stu->sid; } } } } }else if(!isset($_POST['ClassID']) || $_POST['ClassID'] == 'all' ){ if($current_user_role =='administrator'){ // $studentlists = $wpdb->get_results("select sid from $student_table WHERE parent_wp_usr_id!='0'"); $studentlists = $wpdb->get_results($wpdb->prepare("SELECT sid FROM $student_table WHERE parent_wp_usr_id != %d",0)); foreach ($studentlists as $stu) { $stl[] = $stu->sid; } }else if($current_user_role =='teacher'){ // print_r($sel_class); $stl = []; foreach ($sel_class as $key => $value) { //$studentlists = $wpdb->get_results("select class_id, sid from $student_table WHERE parent_wp_usr_id!='0'"); $studentlists = $wpdb->get_results($wpdb->prepare("SELECT class_id, sid FROM $student_table WHERE parent_wp_usr_id != %d",0)); foreach ($studentlists as $stu) { if(is_numeric($stu->class_id) ){ if($stu->class_id == $value->cid){ $stl[] = $stu->sid; } }else{ $class_id_array = unserialize( $stu->class_id ); if(is_array($class_id_array)){ if(in_array($value->cid, $class_id_array)){ $stl[] = $stu->sid; } } } } } } } $parent_ids=array(); foreach($stl as $plist){ $parent_ids[]= $wpdb->get_row("SELECT DISTINCT u.user_email, CONCAT_WS(' ', p_fname, p_mname, p_lname ) AS full_name, p.s_fname,p.s_lname, p.wp_usr_id, p.parent_wp_usr_id from $student_table p LEFT JOIN $users_table u ON u.ID = p.parent_wp_usr_id WHERE p.sid = $plist "); } foreach($parent_ids as $key=>$pinfo){ ?>

full_name);?>	s_fname." ".$pinfo->s_lname); ?>	user_email);?>