<?php

if($type_id==1)
{
	$sql_get_app=mysqli_query($conn_1, "select * FROM students_prence WHERE id ='$student_id' ");


									if($sql_get_app){
										$sql_get_app_row=mysqli_num_rows($sql_get_app);
											if($sql_get_app_row >0){
												while($row=mysqli_fetch_assoc($sql_get_app)){
													$faculty_id=$row['type_id'];
													$department_id=$row['department_id'];
													$programme_id=$row['programme_id'];
													$application_number=$row['application_number'];
													$matric_number=$row['number'];
													$country_id=$row['country_id'];
													$state_id=$row['state_id'];
													$lga_id=$row['lga_id'];
													$first_name=$row['first_name'];
													$middle_name=$row['other_names'];
													$phone_no=$row['phone_no'];
													$gender=$row['gender'];
													$religion=$row['religion'];
													$nationality=$row['nationality'];
													$day=$row['day'];
													$month=$row['month'];
													$year=$row['year'];
													$marital_status=$row['marital_status'];
													$email=$row['email'];
													$place_of_birth=$row['place_of_birth'];
													$address=$row['address'];
													$permanent_address=$row['permanent_address'];
													$image=$row['image'];
													$H_status=$row['H_status'];
													$blood_type=$row['blood_type'];
													$level=$row['level'];
													$disability=$row['disability'];
													$medi=$row['medi'];
													$guardian_name=$row['guardian_name'];
													$guardian_tel=$row['guardian_tel'];
													$guardian_address=$row['guardian_address'];
													$guardian_relationship=$row['guardian_relationship'];
												}
											}
									}
}else if($type_id==2)
{
	$sql_get_app=mysqli_query($conn_1, "select * FROM students_nce WHERE id ='$student_id' ");


									if($sql_get_app){
										$sql_get_app_row=mysqli_num_rows($sql_get_app);
											if($sql_get_app_row >0){
												while($row=mysqli_fetch_assoc($sql_get_app)){
													$faculty_id=$row['type_id'];
													$department_id=$row['department_id'];
													$programme_id=$row['programme_id'];
													$application_number=$row['application_number'];
													$matric_number=$row['number'];
													$country_id=$row['country_id'];
													$state_id=$row['state_id'];
													$lga_id=$row['lga_id'];
													$first_name=$row['first_name'];
													$middle_name=$row['other_names'];
													$phone_no=$row['phone_no'];
													$gender=$row['gender'];
													$religion=$row['religion'];
													$nationality=$row['nationality'];
													$day=$row['day'];
													$month=$row['month'];
													$year=$row['year'];
													$marital_status=$row['marital_status'];
													$email=$row['email'];
													$place_of_birth=$row['place_of_birth'];
													$address=$row['address'];
													$permanent_address=$row['permanent_address'];
													$image=$row['image'];
													$H_status=$row['H_status'];
													$blood_type=$row['blood_type'];
													$level=$row['level'];
													$disability=$row['disability'];
													$medi=$row['medi'];
													$guardian_name=$row['guardian_name'];
													$guardian_tel=$row['guardian_tel'];
													$guardian_address=$row['guardian_address'];
													$guardian_relationship=$row['guardian_relationship'];
												}
											}
									}
}else if($type_id==3)
{
	$sql_get_app=mysqli_query($conn_2, "select * FROM students_nce WHERE id ='$student_id' ");


									if($sql_get_app){
										$sql_get_app_row=mysqli_num_rows($sql_get_app);
											if($sql_get_app_row >0){
												while($row=mysqli_fetch_assoc($sql_get_app)){
													$faculty_id=$row['type_id'];
													$department_id=$row['department_id'];
													$programme_id=$row['programme_id'];
													$application_number=$row['application_number'];
													$matric_number=$row['number'];
													$country_id=$row['country_id'];
													$state_id=$row['state_id'];
													$lga_id=$row['lga_id'];
													$first_name=$row['first_name'];
													$middle_name=$row['other_names'];
													$phone_no=$row['phone_no'];
													$gender=$row['gender'];
													$religion=$row['religion'];
													$nationality=$row['nationality'];
													$day=$row['day'];
													$month=$row['month'];
													$year=$row['year'];
													$marital_status=$row['marital_status'];
													$email=$row['email'];
													$place_of_birth=$row['place_of_birth'];
													$address=$row['address'];
													$permanent_address=$row['permanent_address'];
													$image=$row['image'];
													$H_status=$row['H_status'];
													$blood_type=$row['blood_type'];
													$level=$row['level'];
													$disability=$row['disability'];
													$medi=$row['medi'];
													$guardian_name=$row['guardian_name'];
													$guardian_tel=$row['guardian_tel'];
													$guardian_address=$row['guardian_address'];
													$guardian_relationship=$row['guardian_relationship'];
												}
											}
									}
}else if($type_id==4)
{
	$sql_get_app=mysqli_query($conn_2, "select * FROM students_udus WHERE id ='$student_id' ");


									if($sql_get_app){
										$sql_get_app_row=mysqli_num_rows($sql_get_app);
											if($sql_get_app_row >0){
												while($row=mysqli_fetch_assoc($sql_get_app)){
													$faculty_id=$row['type_id'];
													$department_id=$row['department_id'];
													$programme_id=$row['programme_id'];
													$application_number=$row['application_number'];
													$matric_number=$row['number'];
													$country_id=$row['country_id'];
													$state_id=$row['state_id'];
													$lga_id=$row['lga_id'];
													$first_name=$row['first_name'];
													$middle_name=$row['other_names'];
													$phone_no=$row['phone_no'];
													$gender=$row['gender'];
													$religion=$row['religion'];
													$nationality=$row['nationality'];
													$day=$row['day'];
													$month=$row['month'];
													$year=$row['year'];
													$marital_status=$row['marital_status'];
													$email=$row['email'];
													$place_of_birth=$row['place_of_birth'];
													$address=$row['address'];
													$permanent_address=$row['permanent_address'];
													$image=$row['image'];
													$H_status=$row['H_status'];
													$blood_type=$row['blood_type'];
													$level=$row['level'];
													$disability=$row['disability'];
													$medi=$row['medi'];
													$guardian_name=$row['guardian_name'];
													$guardian_tel=$row['guardian_tel'];
													$guardian_address=$row['guardian_address'];
													$guardian_relationship=$row['guardian_relationship'];
												}
											}
									}
}else if($type_id==5)
{
	$sql_get_app=mysqli_query($conn_1, "select * FROM summer_students WHERE id ='$student_id' ");


									if($sql_get_app){
										$sql_get_app_row=mysqli_num_rows($sql_get_app);
											if($sql_get_app_row >0){
												while($row=mysqli_fetch_assoc($sql_get_app)){
													$faculty_id=$row['type_id'];
													$department_id=$row['department_id'];
													$programme_id=$row['programme_id'];
													$application_number=$row['application_number'];
													$matric_number=$row['number'];
													$country_id=$row['country_id'];
													$state_id=$row['state_id'];
													$lga_id=$row['lga_id'];
													$first_name=$row['first_name'];
													$middle_name=$row['other_names'];
													$phone_no=$row['phone_no'];
													$gender=$row['gender'];
													$religion=$row['religion'];
													$nationality=$row['nationality'];
													$day=$row['day'];
													$month=$row['month'];
													$year=$row['year'];
													$marital_status=$row['marital_status'];
													$email=$row['email'];
													$place_of_birth=$row['place_of_birth'];
													$address=$row['address'];
													$permanent_address=$row['permanent_address'];
													$image=$row['image'];
													$H_status=$row['H_status'];
													$blood_type=$row['blood_type'];
													$level=$row['level'];
													$disability=$row['disability'];
													$medi=$row['medi'];
													$guardian_name=$row['guardian_name'];
													$guardian_tel=$row['guardian_tel'];
													$guardian_address=$row['guardian_address'];
													$guardian_relationship=$row['guardian_relationship'];
												}
											}
									}
}else if($type_id==6)
{
	$sql_get_app=mysqli_query($conn_1, "select * FROM lvsp_students WHERE id ='$student_id' ");


									if($sql_get_app){
										$sql_get_app_row=mysqli_num_rows($sql_get_app);
											if($sql_get_app_row >0){
												while($row=mysqli_fetch_assoc($sql_get_app)){
													$faculty_id=$row['type_id'];
													$department_id=$row['department_id'];
													$programme_id=$row['programme_id'];
													$application_number=$row['application_number'];
													$matric_number=$row['number'];
													$country_id=$row['country_id'];
													$state_id=$row['state_id'];
													$lga_id=$row['lga_id'];
													$first_name=$row['first_name'];
													$middle_name=$row['other_names'];
													$phone_no=$row['phone_no'];
													$gender=$row['gender'];
													$religion=$row['religion'];
													$nationality=$row['nationality'];
													$day=$row['day'];
													$month=$row['month'];
													$year=$row['year'];
													$marital_status=$row['marital_status'];
													$email=$row['email'];
													$place_of_birth=$row['place_of_birth'];
													$address=$row['address'];
													$permanent_address=$row['permanent_address'];
													$image=$row['image'];
													$H_status=$row['H_status'];
													$blood_type=$row['blood_type'];
													$level=$row['level'];
													$disability=$row['disability'];
													$medi=$row['medi'];
													$guardian_name=$row['guardian_name'];
													$guardian_tel=$row['guardian_tel'];
													$guardian_address=$row['guardian_address'];
													$guardian_relationship=$row['guardian_relationship'];
												}
											}
									}
}




?>
