1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : apply2.php
back
<?php
try{
	$conn = new PDO("mysql:host=localhost;dbname=diafrica_result","diafrica_result","07036543898Ola.");
	$conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
}catch(PDOException $e){
	echo $e->getMessage();
}

if (isset($_GET['d'])) {
	$datas = $_GET['d'];

	 $select = $conn->query("SELECT * FROM trequest WHERE iden = '$datas' LIMIT 1");
    $fetch = $select->fetchAll(PDO::FETCH_OBJ);
    $count = $select->rowCount();
    if ($count > 0) {
      foreach ($fetch as $value) {
    $haddress = $value->haddress;
	$caddress = $value->caddress;
	$saddress = $value->saddress;
	$fname = $value->sname;
	$oname = $value->oname;
	$reason = $value->reason;
	$phone = $value->phone;
	$email = $value->email;
	$dob = $value->dob;
	$matric = $value->matric;
	$fromto = $value->fromto;
	$program = $value->program;
	$entry = $value->entry;
	$office = $value->office;
	$school = $value->school;
	$semail = $value->semail;
	$scc = $value->scc;
	$signature = $value->signature;
header("Content-Type: application/doc");
header("Content-Disposition: attachment; filename=$fname $oname.doc");

echo"<table width='100%' cellpadding='10' cellspacing='10'><tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td colspan='3'>$haddress,<br>$caddress,<br>$saddress,</td></tr><tr><td colspan='3'>The Registrar,<br> Dominican Institute,<br>Samonda, Ibadan,<br> Oyo State.<br><br><br>Dear Registrar<br></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><th colspan='11' valign=''>APPLICATION FOR ACADEMIC TRANSCRIPT</th></tr><tr><td colspan='11'>I <b style='text-transform: capitalize;'>$oname $fname</b> write to request for the release of my academic transcript. I am making this request in pursuit of Admission to $reason | <br><br> <b>The Following are my pertinent details:</b></td></tr><tr><td colspan='6' valign='top'><b>Bio Data</b></td><td colspan='6'>Name: $fname $oname<br> Phone: $phone<br> Email: $email<br> Date of Birth: $dob<br> Current Address: $haddress, $caddress, $saddress</td></tr><tr><td colspan='6' valign='top'><b>School Details for Undergraduate Studies</b></td><td colspan='6'>Matric No: $matric<br> Program: $program<br> Year of Entry: $entry <br>Year of Graduation: $fromto</td></tr><tr><td colspan='6' valign='top'><b>Please Kindly Send Transcript to:</b></td><td colspan='6'>$office,<br> $school,<br> $semail,<br> $scc</td></tr><tr><td colspan='6'>Yours faithfully,<br><img src='http://result.dominicaninstitute.org/signature/$signature' width='10px'> <br>$fname $oname</td><td colspan='6'></td></tr><tr><th colspan='11'>Printed from DI Website<br><b>Dominican Institute</b></th></tr></table>";

      }
  }
}
?>