| Server IP : 199.79.63.27 / Your IP : 216.73.216.250 Web Server : Microsoft-IIS/10.0 System : Windows NT MD-PLESK-WEB5 10.0 build 20348 (Windows Server 2022) AMD64 User : IWPD_6698(lcitec7i) ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/INETPUB/VHOSTS/lcit.edu.in/lcitps.edu.in/ |
Upload File : |
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Transfer Certificates </title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
<?php include 'alllinks.php';?>
<style>
.imgr{
height: 232px;
object-fit: cover;
}
</style>
</head>
<body>
<?php include 'navbar.php';?>
<section>
<div class="crumbs-area">
<div class="container">
<div class="crumb-content">
<h4 class="crumb-title">Transfer Certificates</h4>
</div>
</div>
</div>
<!-- TC area start -->
<div class="container"><br>
<h4 style="text-align:center;"> Download Transfer Certificate(TC) </h4> <br>
<div class="row">
<form method="post" action="" style="max-width: 400px; margin: 0 auto;">
<div style="margin-bottom: 10px;">
<label for="admissionNo" style="display: block; font-weight: bold;">Enter Admission No:</label>
<input type="text" id="admissionNo" name="AdmissionNo" required style="width: 100%; padding: 8px; box-sizing: border-box;">
</div>
<button type="submit" name="search" style="padding: 8px 16px; background-color: #007BFF; color: white; border: none; border-radius: 4px; cursor: pointer;">
Search TC
</button>
<br>
</form>
<?php
if (isset($_POST['search'])) {
$admissionNo = $_POST['AdmissionNo'];
// Database connection
include 'db.php';
// Query to fetch TC file path and student name
$sql = "SELECT tc, Stud_name FROM transfercertificate WHERE AdmissionNo = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $admissionNo);
$stmt->execute();
$stmt->bind_result($tc, $studName);
if ($stmt->fetch()) {
$safeTc = htmlspecialchars($tc, ENT_QUOTES, 'UTF-8');
$safeName = htmlspecialchars($studName, ENT_QUOTES, 'UTF-8');
echo "<h4><a href='$safeTc' download>Click to Download TC of $safeName ($admissionNo)</a></h4>";
} else {
echo "<p style='color: red;'>No Transfer Certificate found for this Admission No.</p>";
}
$stmt->close();
$conn->close();
}
?>
</div><br><br>
</div>
<!-- TC area end -->
</section>
<!DOCTYPE html>
<!-- footer area start -->
<?php include 'footer.php';?>
<!-- footer area end -->
<!-- footer area end -->
<!-- jquery latest version -->
<script src="assets/js/vendor/jquery-2.2.4.min.js"></script>
<!-- bootstrap 4 js -->
<script src="assets/js/bootstrap.min.js"></script>
<!-- others plugins -->
<script src="assets/js/owl.carousel.min.js"></script>
<script src="assets/js/jquery.magnific-popup.min.js"></script>
<script src="assets/js/jquery.slicknav.min.js"></script>
<script src="assets/js/plugins.js"></script>
<script src="assets/js/scripts.js"></script>
</body>
</html>