AutoShell

dfhdfhhdfdfhdhfhfdhdfdhfdhfdfhhdfdfhdhfhdf AutoShell

?? Editing: addmission-form.php

<?php
session_start();
error_reporting(0);
include('includes/dbconnection.php');
if (strlen($_SESSION['uid']==0)) {
  header('location:logout.php');
  } else{
$uid = $_SESSION['uid'];
// Check if user has a record in tblfees
$checkFees = mysqli_query($con, "SELECT ID FROM tblfees WHERE UserID='$uid' LIMIT 1");
if (mysqli_num_rows($checkFees) == 0) {
    // No payment record => force them to make payment
    header("location:makepayment.php");
    exit();
}
 // Coding for form Submission  
if(isset($_POST['submit']))
  {
    $uid=$_SESSION['uid'];
    $coursename=$_POST['coursename'];
    $sessionname=$_POST['sessionname'];
    $campusname=$_POST['campusname'];
    $fathername=$_POST['fathername'];
    $mothername=$_POST['mothername'];
    $dob=$_POST['dob'];
    $nationality=$_POST['nationality'];
    $gender=$_POST['gender'];
    $category=$_POST['category'];
    $coradd=$_POST['coradd'];
    $peradd=$_POST['peradd'];
    $secboard=$_POST['10thboard'];
    $secyop=$_POST['10thpyear'];
    $secper=$_POST['10thpercentage'];
    $secstream=$_POST['10thstream'];
    $ssecboard=$_POST['12thboard'];
    $ssecyop=$_POST['12thpyear'];
    $ssecper=$_POST['12thpercentage'];
    $ssecstream=$_POST['12thstream'];
    $grauni=$_POST['graduation'];
    $grayop=$_POST['graduationpyeaer'];
    $graper=$_POST['graduationpercentage'];
    $grastream=$_POST['graduationstream'];
    $pguni=$_POST['postgraduation'];
    $pgyop=$_POST['pgpyear'];
    $pgper=$_POST['pgpercentage'];
    $pgstream=$_POST['pgstream'];
    $dec=$_POST['declaration'];
    $sign=$_POST['signature'];
    $upic=$_FILES["userpic"]["name"];
    $tc=$_FILES["tcimage"]["name"];
        $tenmarksheet=$_FILES["hscimage"]["name"];
        $twlevemaksheet=$_FILES["sscimage"]["name"];
        $gramarksheet=$_FILES["graimage"]["name"];
        $pgmarksheet=$_FILES["pgraimage"]["name"];
    
$extension = substr($upic,strlen($upic)-4,strlen($upic));
$extensiontc = substr($tc,strlen($tc)-4,strlen($tc));
$extensiontm = substr($tenmarksheet,strlen($tenmarksheet)-4,strlen($tenmarksheet));
$extensiontwm = substr($twlevemaksheet,strlen($twlevemaksheet)-4,strlen($twlevemaksheet));
// allowed extensions
$allowed_extensions = array(".jpg","jpeg",".png",".gif",".pdf",".PDF");

// Validation for allowed extensions .in_array() function searches an array for a specific value.
if(!in_array($extension,$allowed_extensions))
{
echo "<script>alert('Invalid format. Only jpg / jpeg/ png /gif format allowed');</script>";
}
else
{
// rename user pic
$userpic=md5($upic).$extension;

if($tc!=""){
$tc=md5($tc).$extensiontc;
} else { $tc="";}

if($tenmarksheet!=""){
$tm=md5($tenmarksheet).$extensiontm;
} else {$tm="";}

if($twlevemaksheet!=""){
$twm=md5($twlevemaksheet).$extensiontwm;
} else {$twm="";}

if($gramarksheet!=""){
$gra=md5($gramarksheet).$extensiongra;
} else { $gra="";}

if($pgmarksheet!=""){
$pgra=md5($pgmarksheet).$extensionpgra;
} else { $pgra="";}
move_uploaded_file($_FILES["tcimage"]["tmp_name"],"userdocs/".$tc);
     move_uploaded_file($_FILES["hscimage"]["tmp_name"],"userdocs/".$tm);
     move_uploaded_file($_FILES["sscimage"]["tmp_name"],"userdocs/".$twm);
     move_uploaded_file($_FILES["graimage"]["tmp_name"],"userdocs/".$gra);
     move_uploaded_file($_FILES["pgraimage"]["tmp_name"],"userdocs/".$pgra);
     move_uploaded_file($_FILES["userpic"]["tmp_name"],"userimages/".$userpic);
    $query=mysqli_query($con,"insert into tbladmapplications(UserId,CourseApplied,Session,campus,FatherName,MotherName,DOB,Nationality,Gender,Category,CorrespondenceAdd,PermanentAdd,SecondaryBoard,SecondaryBoardyop,SecondaryBoardper,SecondaryBoardstream,SSecondaryBoard,SSecondaryBoardyop,SSecondaryBoardper,SSecondaryBoardstream,GraUni,GraUniyop,GraUnidper,GraUnistream,PGUni,PGUniyop,PGUniper,PGUnistream,Signature,UserPic,TransferCertificate,TenMarksheeet,TwelveMarksheet,GraduationCertificate,PostgraduationCertificate) value('$uid','$coursename','$sessionname','$campusname','$fathername','$mothername','$dob','$nationality','$gender','$category','$coradd','$peradd','$secboard','$secyop','$secper','$secstream','$ssecboard','$ssecyop','$ssecper','$ssecstream','$grauni','$grayop','$graper','$grastream','$pguni','$pgyop','$pgper','$pgstream','$sign','$userpic','$tc','$tm','$twm','$gra','$pgra')");
    if ($query) {
    
    echo '<script>alert("Data has been added successfully.")</script>';
    echo "<script>window.location.href ='addmission-form.php'</script>";
  }
  else
    {
     echo '<script>alert("Something Went Wrong. Check your details.")</script>';
         echo "<script>window.location.href ='addmission-form.php'</script>";
    }
}
}
  ?>
<!DOCTYPE html>
<html class="loading" lang="en" data-textdirection="ltr">
<head>

<title>RCM Tent- Making Addmission Portal|| Addmission Form</title>
  <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Quicksand:300,400,500,700"
  rel="stylesheet">
  <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
  <link href="https://maxcdn.icons8.com/fonts/line-awesome/1.1/css/line-awesome.min.css"
  rel="stylesheet">

// Reset all file input fields and required attributes
      document.getElementById('tcimage').required = false;
      document.getElementById('hscimage').required = false;
     // document.getElementById('hscimage').required = false;

// Show or hide the file inputs based on the selected highest certificate
      if (highestCert === 'SSCE') {
        document.getElementById('tcimage').required = true;
      } else if (highestCert === 'NCE') {
        document.getElementById('tcimage').required = true;
        document.getElementById('hscimage').required = true;
      } else if (highestCert === 'Degree') {
        document.getElementById('tcimage').required = true;
        document.getElementById('hscimage').required = true;
      } else if (highestCert == 'Master Degree') {
        document.getElementById('tcimage').required = true;
        document.getElementById('hscimage').required = true;
      } else if (highestCert == 'P.H.D') {
        document.getElementById('tcimage').required = true;
        document.getElementById('hscimage').required = true;
      }
    }
  </script>
</head>
<body class="vertical-layout vertical-menu-modern 2-columns   menu-expanded fixed-navbar"
data-open="click" data-menu="vertical-menu-modern" data-col="2-columns">
<?php include('includes/header.php');?>
<?php include('includes/leftbar.php');?>
  <div class="app-content content">
    <div class="content-wrapper">
      <div class="content-header row">
        <div class="content-header-left col-md-6 col-12 mb-2 breadcrumb-new">
          <h3 class="content-header-title mb-0 d-inline-block">
           Tent-Making Online Application Form
          </h3>
          <div class="row breadcrumbs-top d-inline-block">
            <div class="breadcrumb-wrapper col-12">
              <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a>
                </li>
            
                </li>
                <li class="breadcrumb-item active">Application
                </li>
              </ol>
            </div>
          </div>
        </div>
   
      </div>
      <div class="content-body">
  
<?php 
$stuid=$_SESSION['uid'];
$query=mysqli_query($con,"select tbladmapplications.*,tbluser.*,tbladmapplications.ID as appid  from tbladmapplications 
  join tbluser on tbluser.ID=tbladmapplications.UserId where  UserId=$stuid");
$rw=mysqli_num_rows($query);
if($rw>0)
{
while($row=mysqli_fetch_array($query)){
?>
<p style="font-size:16px; color:red" align="center">Your Addmission Form already submitted. <br> (Note: If you edit your Addmission Form, Make sure to confirm your information and click on "Update" button)</p>
  <div  id="exampl">     
<div class="container my-4">
  <div class="form-card p-3 bg-white">
    <div class="text-center">
      <img src="https://rcm.edu.ng/tmportal/logo.png" width="100" height="80" class="mb-3">
      <h5 class="text-center">THE REDEEMED COLLEGE OF MISSIONS (Tent-Making)</h5>
      <h6 class="text-center">PreRegistration Form</h6>
    </div>

<div class="swipe-indicator">
      <span>Swipe the table to see more content on mobile →</span>
    </div>

<div class="scrollable-table table-responsive mb-3">
      <table class="table table-striped table-bordered">
        <tr>
          <th>Applicant Name</th>
          <td><?php echo $row['FirstName']." ".$row['Middlename']." ".$row['LastName'];?></td>
          <th>Registration Date</th>
          <td><?php echo $row['CourseApplieddate'];?></td>
        </tr>
        <tr>
          <th>Program Applied</th>
          <td><?php echo $row['CourseApplied'];?></td>
          <th>Student Pic</th>
          <td><img src="userimages/<?php echo $row['UserPic'];?>" class="img-fluid" width="200" height="150"></td>
        </tr>
        <tr>
          <th>Matric No</th>
          <td><?php echo $row['MatricNo'];?></td>
          
        </tr>
        <tr>
          <th>Session</th>
          <td><?php echo $row['Session'];?></td>
          <th>Campus</th>
          <td><?php echo $row['Campus'];?></td>
        </tr>
        <tr>
          <th>State</th>
          <td><?php echo $row['StateProvince'];?></td>
          <th>Province</th>
          <td><?php echo $row['Province'];?></td>
        </tr>
        <tr>
          <th>DOB</th>
          <td><?php echo $row['DOB'];?></td>
          <th>Nationality</th>
          <td><?php echo $row['Nationality'];?></td>
        </tr>
        <tr>
          <th>Gender</th>
          <td><?php echo $row['Gender'];?></td>
          <th>Program Category</th>
          <td><?php echo $row['Category'];?></td>
        </tr>
        <tr>
          <th>Applicant Address</th>
          <td><?php echo $row['CorrespondenceAdd'];?></td>
          <th>Province H/Q Address</th>
          <td><?php echo $row['PermanentAdd'];?></td>
        </tr>
        <tr>
          <th>SSCE</th>
          <td>
            <?php if($row['TransferCertificate']==""){ ?>
              NA
            <?php } else{ ?>
              <a href="userdocs/<?php echo $row['TransferCertificate'];?>" target="_blank">View File</a>
            <?php } ?>
          </td>
          <th>Higher Institution</th>
          <td>
            <?php if($row['TenMarksheeet']==""){ ?>
              NA
            <?php } else{ ?>
              <a href="userdocs/<?php echo $row['TenMarksheeet'];?>" target="_blank">View File</a>
            <?php } ?>
          </td>
        </tr>
        <tr>
          <th>RCCG Certificate</th>
          <td>
            <?php if($row['TwelveMarksheet']==""){ ?>
              NA
            <?php } else{ ?>
              <a href="userdocs/<?php echo $row['TwelveMarksheet'];?>" target="_blank">View File</a>
            <?php } ?>
          </td>
          <th>Other Certificate</th>
          <td>
            <?php if($row['GraduationCertificate']==""){ ?>
              NA
            <?php } else{ ?>
              <a href="userdocs/<?php echo $row['GraduationCertificate'];?>" target="_blank">View File</a>
            <?php } ?>
          </td>
        </tr>
        <tr>
          <th>Supported Document</th>
          <td>
            <?php if($row['PostgraduationCertificate']==""){ ?>
              NA
            <?php } else{ ?>
              <a href="userdocs/<?php echo $row['PostgraduationCertificate'];?>" target="_blank">View File</a>
            <?php } ?>
          </td>
        </tr>
      </table>
    </div>

<div class="scrollable-table table-responsive mb-3">
      <table class="table table-striped table-bordered">
        <tr>
          <th>#</th>
          <th>Institution</th>
          <th>Qualification</th>
          <th>Year</th>
        </tr>
        <tr>
          <th>Secondary School</th>
          <td><?php echo $row['SecondaryBoard'];?></td>
          <td><?php echo $row['SecondaryBoardyop'];?></td>
          <td><?php echo $row['SecondaryBoardper'];?></td>
        </tr>
        <tr>
          <th>Higher Institution</th>
          <td><?php echo $row['SSecondaryBoard'];?></td>
          <td><?php echo $row['SSecondaryBoardyop'];?></td>
          <td><?php echo $row['SSecondaryBoardper'];?></td>
        </tr>
        <tr>
          <th>Seminary Institution</th>
          <td><?php echo $row['GraUni'];?></td>
          <td><?php echo $row['GraUniyop'];?></td>
          <td><?php echo $row['GraUnidper'];?></td>
        </tr>
        <tr>
          <th>Other Institution</th>
          <td><?php echo $row['PGUni'];?></td>
          <td><?php echo $row['PGUniyop'];?></td>
          <td><?php echo $row['PGUniper'];?></td>
        </tr>
      </table>
    </div>

<?php if($row['AdminStatus'] != ""): ?>
      <div class="scrollable-table table-responsive mb-3">
        <table class="table table-striped table-bordered">
          <tr>
            <th>Admin Remark</th>
            <td><?php echo $row['AdminRemark'];?></td>
          </tr>
          <tr>
            <th>Admin Status</th>
            <td>
              <?php 
                if($row['AdminStatus'] == "Selected"){
                  echo "Selected";
                } else if($row['AdminStatus'] == "Rejected"){
                  echo "Rejected";
                } else {
                  echo "Admin remark is pending";
                }
              ?>
            </td>
          </tr>
          <tr>
            <th>Admin Remark Date</th>
            <td><?php echo $row['AdminRemarkDate'];?></td>
          </tr>
        </table>
      </div>
    <?php endif; ?>

<div class="scrollable-table table-responsive">
      <table class="table table-striped table-bordered">
        <tr>
          <th colspan="2">
            <font color="red">Declaration: </font>I hereby state that the facts mentioned above are true to the best of my knowledge and belief.<br />
            (<?php echo $row['Signature'];?>)
          </th>
        </tr>
      </table>
    </div>
  </div>
</div>

</div>
<div style="float:right;">
  <button class="btn btn-primary" style="cursor: pointer;"  OnClick="CallPrint(this.value)" >Print</button></div>
<?php

if ($row['AdminStatus']=="" || $row['AdminStatus']=="Rejected"){
?>
<p style="text-align: center;font-size: 20px;"><a href="edit-appform.php?editid=<?php echo $row['appid'];?>">Edit Details</a></p>
<?php }} } else { ?>
<form name="submit" method="post" enctype="multipart/form-data">

<section class="formatter" id="formatter">
          <div class="row">
            <div class="col-12">
              <div class="card">
                <div class="card-header">
                  <h4 class="card-title">THE REDEEMED COLLEGE OF MISSIONS (Tent-Making)<br><br>PreRegistration Form</h4>

<div class="container">
  
  <div class="row">
    <div class="col-md-6 col-sm-12">
      <fieldset>
        <h5>Program Applied</h5>
        <div class="form-group">
          <select name='coursename' id="coursename" class="form-control" required>
            <option value="">Program Applied</option>
            <?php $query=mysqli_query($con,"select * from tblcourse");
              while($row=mysqli_fetch_array($query))
              {
            ?>    
            <option value="<?php echo $row['CourseName'];?>"><?php echo $row['CourseName'];?></option>
            <?php } ?>  
          </select>
        </div>
      </fieldset>
    </div>

<div class="col-md-6 col-sm-12">
      <fieldset>
        <h5>Student Pic</h5>
        <div class="form-group">
          <input class="form-control" id="userpic" name="userpic" type="file" required>
        </div>
      </fieldset>
    </div>
  </div>

<div class="row">
    <div class="col-md-4 col-sm-12">
      <fieldset>
        <h5>Session</h5>
        <div class="form-group">
          <select name='sessionname' id="sessionname" class="form-control" required>
            <option value="">Session</option>
            <?php $query=mysqli_query($con,"select * from session");
              while($row=mysqli_fetch_array($query))
              {
            ?>    
            <option value="<?php echo $row['Session'];?>"><?php echo $row['Session'];?></option>
            <?php } ?>  
          </select>
        </div>
      </fieldset>
    </div>
    <div class="col-md-4 col-sm-12">
      <fieldset>
        <h5>Date Of Birth</h5>
        <div class="form-group">
          <input class="form-control" id="dob" name="dob" type="date" required>
        </div>
      </fieldset>
    </div>
    <div class="col-md-4 col-sm-12">
      <fieldset>
        <h5>Nationality</h5>
        <div class="form-group">
          <input class="form-control" id="nationality" name="nationality" type="text" required>
        </div>
      </fieldset>
    </div>
  </div>

<div class="row">
    <div class="col-md-4 col-sm-12">
      <fieldset>
        <h5>Gender</h5>
        <div class="form-group">
          <select class="form-control" id="gender" name="gender" required>
            <option value="">Select</option>
            <option value="Male">Male</option>
            <option value="Female">Female</option>
          </select>
        </div>
      </fieldset>
    </div>
    <div class="col-md-4 col-sm-12">
      <fieldset>
        <h5>Program Category</h5>
        <div class="form-group">
          <select class="form-control" id="category" name="category" required>
            <option value="">Select Category</option>
            <option value="Part-Time">Part-Time</option>
            <option value="Full-Time">Full-Time</option>
            <option value="Sandwich">Sandwich</option>
          </select>
        </div>
      </fieldset>
    </div>
    <div class="col-md-12">
      <fieldset>
        <h5>Applicant Address</h5>
        <div class="form-group">
          <textarea class="form-control" id="coradd" name="coradd" rows="4" required></textarea>
        </div>
      </fieldset>
    </div>
    <div class="col-md-12">
      <fieldset>
        <h5>Provincial H/Q Address</h5>
        <div class="form-group">
          <textarea class="form-control" id="peradd" name="peradd" rows="4" required></textarea>
        </div>
      </fieldset>
    </div>
  </div>

<div class="container my-4">
  <h4 class="card-title">Academic Qualification</h4>
  <hr />

<div class="form-group">
    <label for="highestCert">Select your highest qualification:</label>
    <select class="form-control" id="highestCert" name="highestCert" onchange="handleCertificateSelection()">
      <option value="">-- Select Qualification --</option>
      <option value="SSCE">SSCE</option>
      <option value="NCE">NCE</option>
      <option value="Degree">Degree</option>
      <option value="Master Degree">Master Degree</option>
      <option value="P.H.D">P.H.D</option>
    </select>
  </div>
  
  <div class="col-12">
    <div class="form-group">
      <label for="10thboard">Secondary School</label>
      <input class="form-control" id="10thboard" name="10thboard" placeholder="School" type="text">
    </div>
    <div class="form-group">
      <label for="10thpyear">Qualification</label>
      <input class="form-control" id="10thpyear" name="10thpyear" placeholder="Qualification" type="text">
    </div>
    <div class="form-group">
      <label for="10thpercentage">Year</label>
      <input class="form-control" id="10thpercentage" name="10thpercentage" placeholder="Year" type="text">
    </div>
  </div>

<div class="col-12">
    <div class="form-group">
      <label for="12thboard">Higher Institution</label>
      <input class="form-control" id="12thboard" name="12thboard" placeholder="School" type="text">
    </div>
    <div class="form-group">
      <label for="12thpyear">Qualification</label>
      <input class="form-control" id="12thpyear" name="12thpyear" placeholder="Qualification" type="text">
    </div>
    <div class="form-group">
      <label for="12thpercentage">Year</label>
      <input class="form-control" id="12thpercentage" name="12thpercentage" placeholder="Year" type="text">
    </div>
  </div>

<div class="col-12">
    <div class="form-group">
      <label for="graduation">Seminary Institution</label>
      <input class="form-control" id="graduation" name="graduation" placeholder="School" type="text">
    </div>
    <div class="form-group">
      <label for="graduationpyeaer">Qualification</label>
      <input class="form-control" id="graduationpyeaer" name="graduationpyeaer" placeholder="Qualification" type="text">
    </div>
    <div class="form-group">
      <label for="graduationpercentage">Year</label>
      <input class="form-control" id="graduationpercentage" name="graduationpercentage" placeholder="Year" type="text">
    </div>
  </div>

<div class="col-12">
    <div class="form-group">
      <label for="postgraduation">Other Institution</label>
      <input class="form-control" id="postgraduation" name="postgraduation" placeholder="School" type="text">
    </div>
    <div class="form-group">
      <label for="pgpyear">Qualification</label>
      <input class="form-control" id="pgpyear" name="pgpyear" placeholder="Qualification" type="text">
    </div>
    <div class="form-group">
      <label for="pgpercentage">Year</label>
      <input class="form-control" id="pgpercentage" name="pgpercentage" placeholder="Year" type="text">
    </div>
  </div>
</div>

<div class="row">
    
    <div class="col-md-6 col-sm-12">
      <fieldset>
        <h5>SSCE</h5>
        <div class="form-group">
          <input class="form-control" id="tcimage" name="tcimage" type="file">
        </div>
      </fieldset>
    </div>

<div class="col-md-6 col-sm-12">
      <fieldset>
        <h5>Higher Institution</h5>
        <div class="form-group">
          <input class="form-control" id="hscimage" name="hscimage" type="file">
        </div>
      </fieldset>
    </div>
 
    <div class="col-md-6 col-sm-12">
      <fieldset>
        <h5>Member of RCCG? Certificate obtain (if any)</h5>
        <div class="form-group">
          <input class="form-control" id="sscimage" name="sscimage" type="file">
        </div>
      </fieldset>
    </div>
    <div class="col-md-6 col-sm-12">
      <fieldset>
        <h5>Other Certificate (if any)</h5>
        <div class="form-group">
          <input class="form-control" id="pgraimage" name="pgraimage" type="file">
        </div>
      </fieldset>
    </div>
  </div>

<div class="row">
    <div class="col-12">
      <h4 class="card-title"><b>Declaration</b></h4>
      <hr />
      <h5><b>I hereby state that the facts mentioned above are true to the best of my knowledge and belief.</b></h5>
    </div>
  </div>
</div>

<div class="row"> 
<div class="col-xl-4 col-lg-12">
<fieldset>
 <input class="form-control white_bg" id="signature" name="signature" placeholder="Signature"  type="text"> 
 </fieldset>  
</div>
</div>
<div class="row" style="margin-top: 2%">
<div class="col-xl-6 col-lg-12">
<button type="submit" name="submit" class="btn btn-info btn-min-width mr-1 mb-1">Submit</button>
</div>
</div>
 </div>
                </div>
              </div>
            </div>
          </div>
        </section>
        <?php } ?>
        
      </form>  
      </div>
    </div>
  </div>
<?php include('includes/footer.php');?>
 
       <script>
function CallPrint(strid) {
var prtContent = document.getElementById("exampl");
var WinPrint = window.open('', '', 'left=0,top=0,width=800,height=900,toolbar=0,scrollbars=0,status=0');
WinPrint.document.write(prtContent.innerHTML);
WinPrint.document.close();
WinPrint.focus();
WinPrint.print();
}

</script>

<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.5.3/dist/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>

</body>
</html>
<?php  } ?>

Path:

home / rcmewpjy / public_html / tmportal / user /

?? Editing: addmission-form.php

Path:

?? Upload