1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : capply.php
back
<?php
require('PHPMailer/mail.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();
}
function create($table,$data){
    global $conn;
    foreach($data as $field => $value){
        $fields[] = sprintf("`%s`",$field);
        $values[] = sprintf("'%s'",$value);
        $field_list = join(',',$fields);
        $value_list = join(',',$values);
    }

    $query = sprintf("INSERT INTO `%s`(%s)VALUES(%s)",$table,$field_list,$value_list);
    $stmt = $conn->prepare($query);
    $stmt->execute();

    return true;
}
if (isset($_POST['submit'])) {
    $haddress  = $_POST['haddress'];
    $caddress  = $_POST['caddress'];
    $saddress  = $_POST['saddress'];
    $fname  = $_POST['fname'];
    $oname  = $_POST['oname'];
    $reason  = '';
    $phone  = $_POST['phone'];
    $email  = $_POST['email'];
    $dob  = $_POST['dob'];
    $matric  = $_POST['matric'];
    $fromto  = $_POST['fromto'];
    $program  = $_POST['program'];
    $entry  = $_POST['entry'];
    $who  = $_POST['who'];
    $pfname  = $_POST['pfname'];
    $poname  = $_POST['ooname'];
    $phome  = $_POST['phome'];
    $pemail  = $_POST['pemail'];
    $pphone  = $_POST['pphone'];
    $pdob  = $_POST['pdob'];
    $pnation  = $_POST['pnation'];
    $utype  = $_POST['utype'];
    $sig = $_FILES['signature']['tmp_name'];
    $sig2 = $_FILES['upload']['tmp_name'];
    $random = rand(0001,9999);

    $temporary = explode("." , $_FILES [ "signature" ][ "name" ]);
    $file_extension = end ($temporary );
    $pic = $_FILES['signature']['name'];
    $picp = $_FILES['signature']['tmp_name'];
    $pics = $_FILES['signature']['size'];

    $temporary2 = explode("." , $_FILES [ "upload" ][ "name" ]);
    $file_extension2 = end ($temporary2 );
    $pic2 = $_FILES['upload']['name'];
    $picp2 = $_FILES['upload']['tmp_name'];
    $pics2 = $_FILES['upload']['size'];

    list($width,$height) = getimagesize($sig);
    
        if ($width > 100 || $height > 100) {
        $message = "Please Input an Image that is 5
        100X100px";
        }
        
    $rando = rand(00001,99999);
    $hash = sha1($pic);
    $hash = $hash.$rando;

    $ext1 = pathinfo($pic, PATHINFO_EXTENSION);
    $ext1 = strtolower($ext1);


    $upload_folder1 = "signature/".$hash.".".$ext1;
    $uploadpic = $hash.".".$ext1;

    $rando2 = rand(00001,99999);
    $hash2 = sha1($pic2);
    $hash2 = $hash2.$rando2;

    $ext2 = pathinfo($pic2, PATHINFO_EXTENSION);
    $ext2 = strtolower($ext2);


    $upload_folder2 = "uploads/".$hash.".".$ext2;
    $uploadpic2 = $hash.".".$ext2;

    $in = array('iden' => $random,
                'haddress' => $haddress,
                'caddress' => $caddress,
                'saddress' => $saddress,
                'sname' => $fname,
                'oname' => $oname,
                'reason' => $reason,
                'phone' => $phone,
                'email' => $email,
                'dob' => $dob,
                'matric' => $matric,
                'fromto' => $fromto,
                'program' => $program,
                'entry' => $entry,
                'who' => $who,
                'pfname' => $pfname,
                'poname' => $poname,
                'phome' => $phome,
                'pemail' => $pemail,
                'pphone' => $pphone,
                'pdob' => $pdob,
                'pnation' => $pnation,
                'utype' => $utype,
                'upload' => $uploadpic2,
                'signature'  => $uploadpic,

                );

    move_uploaded_file($picp, $upload_folder1);
    include('simpleimage.php');
    $signature = $upload_folder1;
    $image = new SimpleImage($signature);
	$image->resize(150, 100);
	$image->save($signature);			
    $signature = $upload_folder1;

    move_uploaded_file($picp2, $upload_folder2);
    $identification = $upload_folder2;
    $img = new SimpleImage($identification);
	$img->resize(200, 100);
	$img->save($identification);			
    $identification = $upload_folder2;

    create('crequest',$in);

    $to_email= 'records@dominicaninstitute.edu.ng';
    $to_email2= 'registrar@dominicaninstitute.edu.ng';
    $to_name='Registrar';
    $subject="Application for Certificate for $fname $oname";
    $body ="<html><body style='text-align:center;'>";
    $body.="Hello sir, an application for Certificate has been sent.. Download it <a href='http://result.dominicaninstitute.org/capply2.php?d=$random'><button>Here</button></a>";
    $body.="</body></html>";
       
    mail::send_mail($to_email,$to_name,$subject,$body);
    mail::send_mail($to_email2,$to_name,$subject,$body);

    $message = "You have successfully sent a mail to the registrar as reguards to your certificate click  <a href='http://result.dominicaninstitute.org/capply2.php?d=$random'><button class='btn btn-success'>Here</button></a> to download your copy of the letter";
    #$message = "You have successfully sent a mail to the registrar as reguards to your certificate click  <a href='http://localhost/di-result/capply2.php?d=$random'><button class='btn btn-success'>Here</button></a> to download your copy of the letter";

}

?>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-giJF6kkoqNQ00vy+HMDP7azOuL0xtbfIcaT9wjKHr8RbDVddVHyTfAAsrekwKmP1" crossorigin="anonymous">
    <link rel="stylesheet" href="./apply.css">
    <link rel="preconnect" href="https://fonts.gstatic.com">
    <link href="https://fonts.googleapis.com/css2?family=Poppins:ital,wght@0,100;0,200;0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,100;1,200;1,300;1,400;1,500;1,600;1,700;1,800;1,900&display=swap" rel="stylesheet">
    <title>Application for Certificate</title>
  </head>
  <body class="bg-light">
     <header class="text-center">
        <a href="http://dominicaninstitute.org/"><img src="./logo2.png" class="d-block mx-auto"></a>
        <h1 class="my-3 text-uppercase">Application for Certificate</h1>
       <hr class="bg-danger">
     </header>
     <main class="container shadow-lg pt-5" style="background-color: white;">
       <div class="alert-box">
        <?php
              if (isset($message)) {
            ?>
              <div class="alert alert-info alert-dismissible fade show" role="alert">
                <?=$message; ?>
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
              </div>
            <?php
            }
        ?>

       </div>
       <div>
         <p>Please fill the form carefully. And supply the information as required</p>
       </div>
        <form method="post" enctype="multipart/form-data">
          <fieldset class="mt-3">
              <div class="shadow-sm mb-3 py-2 px-2">
                <h2 class="">Biodata</h2>
              </div>
              <div class="row">
                  <div class="form-group col-md-4 mb-3">
                    <label for="fname" class="form-label">Surname</label>
                      <input type="text" name="fname" required class="form-control" id="fname" placeholder="Surname">
                    </div>
                  <div class="form-group col-md-4 mb-3">
                    <label for="oname" class="form-label">Other Names</label>
                    <input type="text" name="oname" required class="form-control" placeholder="Other names">
                  </div>
                  <div class="form-group col-md-4 mb-3">
                    <label for="haddress" class="form-label">House Address</label>
                    <input type="text" name="haddress" class="form-control" required placeholder="e.g NO 1, Zone 1">
                  </div>
              </div>
              
              <div class="row">
                <div class="form-group col-md-4 mb-3">
                  <label for="caddress"  class="form-label">City Address</label>
                  <input type="text" name="caddress" class="form-control" required placeholder="e.g city">     
                </div>
                <div class="form-group col-md-4 mb-3">
                  <label for="saddress" class="form-label">State/Country Address</label>
                  <input type="text" name="saddress" class="form-control" required placeholder="e.g State, Country">     
                </div>
                <div class="form-group col-md-4 mb-3">
                  <label for="phone" class="form-label">Phone Number</label>
                  <input type="text" class="form-control" name="phone" class="form-control" required placeholder="e.g+234...">         
                 </div>     
              </div>

              <div class="row">
                <div class="form-group col-md-4 mb-3">
                  <label class="form-label">Email</label>
                  <input type="text" name="email" class="form-control" required placeholder="abc@example.com">  
                </div>
                <div class="form-group col-md-4 mb-3">
                  <label class="form-label">Date of Birth</label>
                  <input type="date" name="dob" class="form-control" required placeholder="" min="1901-01-01" max="<?php echo date('Y-m-d');?>">
                </div>
                <div class="form-group col-md-4 mb-3">
                    <label class="form-label">Nationalty</label>
                    <input type="text" class="form-control" required placeholder="">      
                 </div>     
              </div>
          </fieldset>   
          
          <fieldset class="mt-3">
              <div class="shadow-sm mb-3 py-2 px-2">
                <h2 class="">Domincan Institute Data</h2>
              </div>

              <div class="row">
                <div class="form-group col-md-3 mb-3">
                  <label class="form-label">Matric No</label>
                  <input type="text" class="form-control" name="matric" required placeholder="e.g DI/123">
                </div>
                <div class="form-group col-md-3 mb-3">
                  <label class="form-label">Year of Entry</label>
                  <input class="form-control" type="text" name="entry" required placeholder="e.g 2018/2019">
                </div>
                <div class="form-group col-md-3 mb-3">
                  <label class="form-label">Year of Graduation </label>
                  <input type="text" class="form-control" name="fromto" required placeholder="e.g 2018/2019"> 
                 </div>
                 <div class="form-group col-md-3 mb-3">
                    <label class="form-label">Program</label>
                    <input type="text" class="form-control" name="program" required placeholder="e.g B.A. Philosophy" > 
                 </div>     
              </div>
          </fieldset>

          <fieldset class="mt-3">
              <div class="shadow-sm mb-3 py-2 px-2">
                <h2 class="">Authentication of Request</h2>
                <p class="text-danger font-weight-bolder">Please indicate below if applicant will not collect in person</p>
              </div>
              <div class="row">
                <div class="form-group col-md-4 mb-3">
                 <label class="form-label">Choose Below</label>
                    <select name="who" id="who" onchange="loadthis();" class="form-select form-control" aria-label="Default select example">
                    <option value="personal">Personal</option>
                    <option value="proxy">Proxy</option>
                    </select>
                </div>
              </div>
              <div id="proxyy">
                <div class="row">
                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">First Name (Proxy)</label>
                        <input type="text" class="form-control" name="pfname" placeholder="Full Name">
                    </div>

                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">Other Names (Proxy)</label>
                        <input type="text" class="form-control" name="ooname" placeholder="Other Names">
                    </div>

                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">House Address (Proxy)</label>
                        <input type="text"  class="form-control" name="phome" placeholder="e.g NO 1, Zone 1">
                    </div>
                </div>
                <div class="row">
                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">Email (Proxy)</label>
                        <input type="text" class="form-control" name="pemail" placeholder="abc@example.com"> 
                    </div>

                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">Phone Number (Proxy)</label>
                        <input type="text" class="form-control" name="pphone" placeholder="e.g+234...">
                    </div>

                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">Date of Birth (Proxy)</label>
                        <input type="date" class="form-control" name="pdob" placeholder="" min="1990-01-01" max="<?php echo date('Y-m-d');?>">
                    </div>

                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">Nationalty (Proxy)</label>
                        <input type="text" class="form-control" placeholder="" name="pnation">
                    </div>
                </div>

              </div>

              <div id="personall">
                <div class="row">
                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">Signature(side must be 100X100px) </label>
                        <input type="file" class="form-control" name="signature"  placeholder="e.g 2014-2018">
                    </div>

                    <div class="form-group col-md-4 mb-3">
                    <label class="form-label">Choose Mode of Identification</label>
                        <select name="utype" class="form-select">
                        <option value="Drivers License">Driver's Licence</option>
                        <option value="Voters Card">Voter's Card</option>
                        <option value="International Passport">International Passport</option>
                        <option value="DI Student ID Card">DI Student ID Card</option>
                        </select>
                    </div>

                    <div class="form-group col-md-4 mb-3">
                        <label class="form-label">Upload Identification  </label>
                        <input type="file" name="upload" class="form-control"  placeholder="e.g 2014-2018">
                    </div>
                </div>
              </div>
          </fieldset>  
          
          <fieldset class="mt-3">
            <button class="btn btn-lg btn-success px-5" type="submit" name="submit">Apply for Cerificate</button>
          </fieldset> 
        </form>
     </main>
    <!-- Optional JavaScript; choose one of the two! -->

    <!-- Option 1: Bootstrap Bundle with Popper -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.bundle.min.js" integrity="sha384-ygbV9kiqUc6oa4msXn9868pTtWMgiQaeYH7/t7LECLbyPA2x65Kgf80OJFdroafW" crossorigin="anonymous"></script>   
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.4/dist/umd/popper.min.js" integrity="sha384-q2kxQ16AaE6UbzuKqyBE9/u/KzioAlnx2maXQHiDX9d4/zp8Ok3f+M7DPm+Ib6IU" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.min.js" integrity="sha384-pQQkAEnwaBkjpqZ8RU1fF1AKtTcHJwFl3pblpTlHXybJjHpMYo79HY3hIi4NKxyj" crossorigin="anonymous"></script>
    
    <script type="text/javascript">
        window.onload = prot();

        function prot(){
            document.getElementById('personall').hidden = false;
            document.getElementById('proxyy').hidden = true;
        }

        function loadthis(){
            var whois = document.getElementById('who').value;

            if (whois == 'personal') {
            document.getElementById('proxyy').hidden = true;
            }else if (whois == 'proxy') {
            document.getElementById('proxyy').hidden = false;
            }else{
            document.getElementById('personall').hidden = false;
            document.getElementById('proxyy').hidden = true;
            }

        }
    </script>

    
  </body>
</html>