get_row("select a.*,b.c_name,CONCAT_WS(' ', a.s_fname, a.s_mname, a.s_lname ) AS full_name,d.user_email from $student_table a LEFT JOIN $class_table b ON a.class_id=b.cid LEFT JOIN $users_table d ON d.ID=a.wp_usr_id where a.wp_usr_id='".esc_sql($sid)."'");
$stinfo = $wpdb->get_results($wpdb->prepare("SELECT a.*,b.c_name,CONCAT_WS(' ', a.s_fname, a.s_mname, a.s_lname ) AS full_name,d.user_email FROM $student_table a LEFT JOIN $class_table b ON a.class_id=b.cid LEFT JOIN $users_table d ON d.ID=a.wp_usr_id WHERE a.wp_usr_id = %d",$sid));
if (is_numeric($stinfo->class_id)){
$classIDArray[] = $stinfo->class_id;
}else{
$classIDArray = unserialize($stinfo->class_id);
}
$classname_array = [];
$classIDArray_Sanitiz = array_map('intval',$classIDArray);
foreach ($classIDArray_Sanitiz as $id ) {
$id = esc_sql($id);
// $clasname = $wpdb->get_var("SELECT c_name FROM $class_table where cid='$id'");
$clasname = $wpdb->get_results($wpdb->prepare("SELECT c_name FROM $class_table WHERE cid = %d",$id));
$classname_array[] = $clasname;
}
if(!empty($stinfo)) {
?>
;?>)
full_name); ?>
| s_rollno); ?> | |
| s_gender); ?> | |
| s_dob)); ?> | |
| s_doj)); ?> | |
| s_paddress); ?> | |
| s_pcountry); ?> | |
| s_pzipcode); ?> | |
| user_email); ?> | |
| s_phone); ?> | |
| s_bloodgrp); ?> |