if(isset($_POST[verify])){
	include(../connect.php);
	$idnumber=$_POST[id];
		if(empty($idnumber)){
		echo <p class="alert alert-warning text-center error">Please enter trainee IDnumber</p>;
	}
		else{
		$trainee=SELECT trainee.frname,trainee.level,occupation.occname FROM trainee,occupation WHERE trainee.idnumber=? && trainee.occupationid=occupation.occid;
		$stmt=$link->prepare($trainee);
		$stmt->bind_param(s$idnumber);
		$stmt->execute();
		$tr_result=$stmt->get_result();
		$tr_count=$tr_result->num_rows;
			if($tr_count==1){
			$fetch=$tr_result->fetch_assoc();
			$tr_name=$fetch[frname];
			$level=$fetch[level];
			$occupation=$fetch[occname];
			$select=SELECT * FROM result WHERE idnumber=?;
			$stmt=$link->prepare($select);
			$stmt->bind_param(s$idnumber);
			$stmt->execute();
			$result=$stmt->get_result();
			$count=$result->num_rows;
				if($count>0){
				$select_certificate=SELECT * FROM certificates WHERE idnumber=?;
				$stmt=$link->prepare($select_certificate);
				$stmt->bind_param(s$idnumber);
				$stmt->execute();
				$cert_result=$stmt->get_result();
				$count_cert=$cert_result->num_rows;
					if($count_cert>0){
					$fetch_cgpa=$cert_result->fetch_assoc();
					$cgpa=$fetch_cgpa[cgpa];
					$date=$fetch_cgpa[date];