1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : capply2.php
back
<?php
try{
  $conn = new PDO("mysql:host=localhost;dbname=diafrica_result","diafrica_result","07036543898Ola.");
  #$conn = new PDO("mysql:host=localhost;dbname=diafrica_result","root","");
  $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 crequest 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;
  $who = $value->who;
  $pfname = $value->pfname;
  $poname = $value->poname;
  $phome = $value->phome;
  $pemail = $value->pemail;
  $pphone = $value->pphone;
  $pdob = $value->pdob;
  $pnation = $value->pnation;
  $utype = $value->utype;
  $upload = $value->upload;
  $signature = $value->signature;

  if ($who == 'personal') {
    $usewho = 'Personally';
    $usename = '';
    $useadd = '';
    $useemail = '';
    $usephone = '';
    $usedob = '';
    $usenation = '';
  }else{
    $usewho = 'By Proxy';
    $usename = 'Name:';
    $useadd = 'Home Address:';
    $useemail = 'Email:';
    $usephone = 'Phone No:';
    $usedob = 'Date of Birth:';
    $usenation = 'Nationalty:';
  }
header("Content-Type: application/doc");
header("Content-Disposition: attachment; filename=$fname $oname Certificate.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 CERTIFICATE</th></tr><tr><td colspan='11'>I <b style='text-transform: capitalize;'>$oname $fname</b> write to request for the release of my Certificate. 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>Authentication of Request:</b></td><td colspan='6'>Will be collected: $usewho,<br> $usename $pfname $poname<br> $useadd $phome<br> $useemail $pemail <br>$usephone $pphone<br> $usedob $pdob<br> $usenation $pnation<br> Authentication Document Type: $utype <br> <img src='http://result.dominicaninstitute.org/uploads/$upload' width='10px'> </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>";
#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 CERTIFICATE</th></tr><tr><td colspan='11'>I <b style='text-transform: capitalize;'>$oname $fname</b> write to request for the release of my Certificate. 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>Authentication of Request:</b></td><td colspan='6'>Will be collected: $usewho,<br> $usename $pfname $poname<br> $useadd $phome<br> $useemail $pemail <br>$usephone $pphone<br> $usedob $pdob<br> $usenation $pnation<br> Authentication Document Type: $utype <br> <img src='http://localhost/di-result/uploads/$upload' width='10px'> </td></tr><tr><td colspan='6'>Yours faithfully,<br><img src='http://localhost/di-result/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>";

      }
  }
}
?>