<?php  
//Check for sessions and allow session data retreival and use
if(!isset($_SESSION)) {
session_start();
}

include_once('fnect.php');// connect db
//require_once('errors.php'); // get errors
//require_once('success.php'); // return success messages

$act = $_GET['fpe'];
	
	/***** Take care of special Photograph issues for some page *****/
	$abus = array('history','objectives','vision-mission','core-values','management','profile','pictures','schools','experience','publications','awards','qualification');
	//foreach ($abus as $value) {print $value;} //using foreach loop to run an array
	if ($act == $abus[0]) 		$act = 'Rector';
	elseif ($act == $abus[1]) 	$act = 'Rector';
	elseif ($act == $abus[2]) 	$act = 'Rector';
	elseif ($act == $abus[3]) 	$act = 'Rector';
	elseif ($act == $abus[4]) 	$act = 'Rector';
	elseif ($act == $abus[5] or $act == $abus[6]) 	$act = 'Rector';
	elseif ($act == $abus[7]) 	$act = 'Rector';
	elseif ($act == $abus[8]) 	$act = 'Rector';
	elseif ($act == $abus[9]) 	$act = 'Rector';
	elseif ($act == $abus[10]) 	$act = 'Rector';
	elseif ($act == $abus[11]) 	$act = 'Rector';
	elseif (!in_array($act,$abus)) 	$act = $_GET['fpe'];
	/***** End the special issues *****/

/********************** CHECK DB **********************************/
/*$show = mysqli_query($fpecon, "SELECT Post FROM Staff_Basic_Profile where Post = '$act'");
if(!$show)	$act = 'Rector';
*///else{
	
/********** Attend to Profile issues **************/ 
if($act == 'Rector'){
$profile = "SELECT Title, StaffNo, Surname, OtherNames, Post, Qualification, Grade FROM Staff_Basic_Profile where Post = '$act'";
}
else{
$profile = "SELECT Title, StaffNo, Surname, OtherNames, Post, Qualification, Grade FROM Staff_Basic_Profile where Post LIKE '%$act%'";
}
$fpedb = mysqli_query( $fpecon, $profile) or die(mysqli_errno()); // Remember to work out the error page for names on db
/*if (!$fpedb){
	 $act = 'Rector';
	 $profile = "SELECT id, Title, StaffNo, Surname, OtherNames, iEmail, pEmail, Phone, Post, Grade, Department, Nationality, EduHist, ProBrief FROM Staff_Basic_Profile where Post = '$act'";
	$fpedb = mysqli_query( $fpecon, $profile);
}
*/// 
while ($row = mysqli_fetch_array($fpedb))
	{
		$staffid = stripslashes($row["StaffNo"]);
		$staffpost = stripslashes($row['Post']);
		$stafftitle = stripslashes($row['Title']);
		$staffsur = stripslashes($row['Surname']);
		$staffon = stripslashes($row['OtherNames']);
		$staffqua = stripslashes($row['Qualification']);
		$stafflevel = stripslashes($row['Grade']);
	}
	$oname = explode(" ",$staffon);
	$initial = $oname[1][0];
	$raypost = explode(" ",$staffpost);
/********** Attend to Image Issues *************/
$pflimg = "SELECT Filename, Location FROM staff_profile_images where StaffNo = '$staffid'";
$imgdb = mysqli_query( $fpecon, $pflimg) or die(mysqli_errno());
while ($row = mysqli_fetch_array($imgdb))
	{
		$emag = stripslashes($row['Location']);
		$fmag = stripslashes($row['Filename']);
	}

?>