global $dal; 
$tblUsers = $dal->Table("portal_cfg");
$sqlp = "SELECT * FROM `portal_cfg`";
$rsp = CustomQuery($sqlp);
while ($datap = db_fetch_array($rsp))
{
$fileArray = my_json_decode($datap["inst_logo"]);
$inst_logo = $fileArray[0]["name"];
$inst_name = $datap["institution_name"];
$inst_addr = $datap["address"];
$inst_contact = $datap["mobile_no"];
$inst_email = $datap["email_id"];
$inst_web = $datap["web"];
$fileArray = my_json_decode($datap["sign1"]);
$inst_sign1 = $fileArray[0]["name"];
$fileArray = my_json_decode($datap["sign2"]);
$inst_sign2 = $fileArray[0]["name"];
}

global $dal;
$tblUsers = $dal->Table("student_info");
$sql = "SELECT * FROM `student_info` WHERE `reg_no`='$stu'";
$rsp = CustomQuery($sql);
while ($data = db_fetch_array($rsp))
{
$fileArray = my_json_decode($data["snap"]);
$stu_snap = $fileArray[0]["name"];
$stu_name = $data["name"];
$stu_fname = $data["father_name"];
$stu_mname = $data["mother_name"];
$stu_contact = $data["contact_mobile"];
$stu_cemail = $data["contact_email"]; 
$stu_bg = $data["blood_group"]; 
$stu_reg_no = $data["reg_no"];
$stu_adm_no = $data["admission_no"];
$stu_gender = $data["gender"];
$stu_gencap = "His / Her";
$stu_gensma = "his / her";
$stu_surname = "Sri. / Kum. ";
$stu_sodo = "S/o / D/o ";
if($stu_gender == "Male") 
{
$stu_gencap = "His"; 
$stu_gensma = "his";
$stu_surname = "Sri.";
$stu_sodo = "S/o";
}
if($stu_gender == "Female") 
{
$stu_gencap = "Her";
$stu_gensma = "her";
$stu_surname = "Kum.";
$stu_sodo = "D/o";
}
$stu_parent = $data["contact_name"];
$stu_addr = $data["address"];
$stu_dobn = date_format(date_create($data["dob"]),"d-m-Y");
$stu_dobm = date_format(date_create($data["dob"]),"d-M-Y");
$stu_dobf = date_format(date_create($data["dob"]),"d-F-Y");
$birth_date = $data["dob"];
$new_birth_date = explode('-', $birth_date);
$year = $new_birth_date[0];
$month = $new_birth_date[1];
$day  = $new_birth_date[2];
$birth_day=numberTowords($day);
$birth_year=numberTowords($year);
$monthNum = $month;
$dateObj = DateTime::createFromFormat('!m', $monthNum);//Convert the number into month name
$monthName = strtoupper($dateObj->format('F'));
$stu_dobinw = $birth_day." ".$monthName." ".$birth_year;
$stu_fcont = $data["father_mobile"];
$stu_mcont = $data["mother_mobile"];
$stu_mob = $data["contact_no"];
$stu_bioid = $data["bio_id"];
$stu_special = $data["special_need"];
$stu_sts = $data["sts_no"];
$stu_mt = $data["mother_tongue"];
$stu_rel= $data["religion"];
$stu_caste = $data["caste"];
$stu_cast_cat = $data["caste_category"];
$stu_scst = "No";
if($stu_cast_cat == "SC") {$stu_scst = "Yes";}
if($stu_cast_cat == "ST") {$stu_scst = "Yes";}
$stu_aadhar = $data["aadhar_no"];
$stu_birtp = $data["birth_place"];
$stu_birtt = $data["birth_taluk"];
$stu_birtd = $data["birth_district"];
$stu_birts = $data["birth_state"];
$stu_nat = $data["nationality"];
$stu_instregno = $data["inst_reg_no"];
$stu_city = $data["city"];
$stu_taq = $data["taluk"];
$stu_dist = $data["district"];
$stu_state = $data["state"];
$stu_country = $data["country"];
$stu_admn = date_format(date_create($data["admission_date"]),"d-m-Y");
$stu_admm = date_format(date_create($data["admission_date"]),"d-M-Y");
$stu_admf = date_format(date_create($data["admission_date"]),"d-F-Y");
}
global $dal;
$tblUsers = $dal->Table("students_mapping");
$sql = "SELECT * FROM `students_mapping` WHERE `student`='$stu' ORDER BY `sm_id` ASC limit 1";
$rsp = CustomQuery($sql);
$data = db_fetch_array($rsp);
$ini_ay = $data["academic_year"];
$ini_sec = $data["section"];
$ini_roll = $data["class_roll_no"];
global $dal;
$tblUsers = $dal->Table("sections_master");
$sql = "SELECT * FROM `sections_master` WHERE `section`='$ini_sec'";
$rsp = CustomQuery($sql);
$data = db_fetch_array($rsp);
$ini_div = $data["division"];
global $dal;
$tblUsers = $dal->Table("students_mapping");
$sql = "SELECT * FROM `students_mapping` WHERE `student`='$stu' ORDER BY `sm_id` DESC limit 1";
$rsp = CustomQuery($sql);
$data = db_fetch_array($rsp);
$last_ay = $data["academic_year"];
$last_sec = $data["section"];
$last_roll = $data["class_roll_no"];
global $dal;
$tblUsers = $dal->Table("sections_master");
$sql = "SELECT * FROM `sections_master` WHERE `section`='$last_sec'";
$rsp = CustomQuery($sql);
$data = db_fetch_array($rsp);
$last_div = $data["division"];