D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
capply.php
back
Copy
<?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>