What are you looking for?

Menu icon
connect_error) { die("Connection failed: " . $connection->connect_error); } $url = $_SERVER['REQUEST_URI']; $path = parse_url($url, PHP_URL_PATH); $pathFragments = explode('/', $path); $person_id = end($pathFragments); $result = displayPerson($connection, $person_id); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $title = $row["title"]; $fullname = $row["fullname"]; $fulladdress = $row["fulladdress"]; $emailadd = $row["email"]; $email = $row["email"]; $ID = $row["personid"]; $phonehome = $row["home_tel"]; $phoneoffice = $row["work_tel"]; $phonemobile = $row["mobile_tel"]; $dpa = $row["dpastatusid"]; echo "

". $row["title"]. " ". $row["fullname"]. "

"; if ($dpa == 1) { if (isset($fulladdress)) { echo "

". "\"\"". $row["fulladdress"]. "

"; } if (isset($email)) { echo "

". "\"\" ". "". $row["email"]. "". "

"; } if (isset($phonehome)) { echo "

". "\"\"". $row["home_tel"]. "

"; } if (isset($phoneoffice)) { echo "

". "\"\"". $row["work_tel"]. "

"; } if (isset($phonemobile)) { echo "

". "\"\"". $row["mobile_tel"]. "

"; } } } } else { echo "No Information for this person"; } $resultPos = positionsHeld($connection, $person_id); echo "
". "
"; echo "

Positions held" ."

"; if ($resultPos->num_rows > 0) { while($row = $resultPos->fetch_assoc()) { $position = $row["position"]; $areaofwork = $row["areaofwork"]; $areaofworkid = $row["areaofworkid"]; $linktype = $row["linktype"]; $positionid = $row["positionid"]; if ($linktype == "deanery") { echo "

". $row["position"]. " - ". "". $row["areaofwork"]. "". "

"; } elseif ($linktype == "benefice") { echo "

". $row["position"]. " - ". "". $row["areaofwork"]. "". "

"; } elseif ($linktype == "nonpar") { echo "

". $row["position"]. " - ". "". $row["areaofwork"]. "". "

"; } elseif ($linktype == "parish") { echo "

". $row["position"]. " - ". "". $row["areaofwork"]. "". "

"; } elseif ($linktype == "archdeaconry") { echo "

". $row["position"]. " - ". "". $row["areaofwork"]. "". "

"; } elseif ($linktype == "church") { echo "

". $row["position"]. " - ". "". $row["areaofwork"]. "". "

"; } elseif ($linktype == "groupministry") { echo "

". $row["position"]. " - ". "". $row["areaofwork"]. "". "

"; } elseif ($linktype == "diocese") { echo "

". $row["position"]. " - ". "". $row["areaofwork"]. "". "

"; } else { echo "

". $row["position"] . "

"; } } } else { echo "No Information for this Person."; } echo "
"; mysqli_close($connection); ?>