Viewing file:  cerificateverify.php (7.55 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<title>ITCE (INFYSYS TECHNOLOGIES COMPUTER EDUCATION )</title>
<meta name="description" content="">
<meta name="keywords" content="">
<!-- Favicons -->
<link href="assets/img/favicon.png" rel="icon">
<link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">
<!-- Fonts -->
<link href="https://fonts.googleapis.com" rel="preconnect">
<link href="https://fonts.gstatic.com" rel="preconnect" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Roboto:ital,wght@0,100;0,300;0,400;0,500;0,700;0,900;1,100;1,300;1,400;1,500;1,700;1,900&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&family=Raleway: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">
<!-- Vendor CSS Files -->
<link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
<link href="assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
<link href="assets/vendor/aos/aos.css" rel="stylesheet">
<link href="assets/vendor/swiper/swiper-bundle.min.css" rel="stylesheet">
<link href="assets/vendor/glightbox/css/glightbox.min.css" rel="stylesheet">
<!-- Main CSS File -->
<link href="assets/css/main.css" rel="stylesheet">
<!-- =======================================================
* Template Name: eBusiness
* Template URL: https://bootstrapmade.com/ebusiness-bootstrap-corporate-template/
* Updated: Jun 23 2025 with Bootstrap v5.3.6
* Author: BootstrapMade.com
* License: https://bootstrapmade.com/license/
======================================================== -->
</head>
<body class="index-page">
<?php include 'header.php'; ?>
<main class="main">
<div class="container">
<div class="row justify-content-center">
<div class="col-lg-10 col-md-12">
<div class="itce-container itce-facilities-container text-center">
<div class="container">
<div class="row justify-content-center">
<div class="col-lg-10 col-md-12">
<div class="itce-container itce-facilities-container text-center">
<h3>Student Certificate Verification</h3>
<form action="" method="get" class="mb-4">
<label for="q" class="fw-bold">Enter Certificate No:</label>
<input type="text" name="q" id="q" class="form-control d-inline-block w-auto"
value="<?= htmlspecialchars($_GET['q'] ?? '') ?>">
<button type="submit" name="Submit" class="btn btn-primary">Search</button>
</form>
<?php
error_reporting(0);
include 'branch2/connect.php';
$cert_no = trim($_GET['q'] ?? '');
if ($cert_no) {
// Fetch certificate data
$sql = "SELECT * FROM certificate WHERE CertificateNo = '$cert_no' ORDER BY ID DESC LIMIT 1";
$result = mysqli_query($link, $sql);
if ($result && mysqli_num_rows($result) > 0) {
$cert = mysqli_fetch_assoc($result);
// Fetch admission data using enrollment
$enrollment = $cert['enrollment'];
$student = null;
if ($enrollment) {
$sql2 = "SELECT enrollment, name, fatherName, motherName, dob, photo
FROM admission
WHERE enrollment = '$enrollment' LIMIT 1";
$result2 = mysqli_query($link, $sql2);
if ($result2 && mysqli_num_rows($result2) > 0) {
$student = mysqli_fetch_assoc($result2);
}
}
// If grade not stored, calculate
$grade = $cert['grade'];
if (!$grade) {
$totalMarks = 0;
$obtainedMarks = 0;
for ($i = 1; $i <= 10; $i++) {
$totalMarks += $cert["pn{$i}_total_marks"] ?? 0;
$obtainedMarks += $cert["pn{$i}_obtained_marks"] ?? 0;
}
$percentage = $totalMarks ? round(($obtainedMarks / $totalMarks) * 100) : 0;
if ($percentage >= 80) $grade = 'A+';
elseif ($percentage >= 60) $grade = 'A';
elseif ($percentage >= 45) $grade = 'B';
else $grade = 'FAIL';
}
// Photo (from admission table if available, else from certificate)
$photoFile = $student['photo'] ?? $cert['photo'];
$photoUrl = 'http://itce.co.in/data/files/' . str_replace(' ', '%20', $photoFile);
?>
<h5 class="mb-3">
Certificate No: <span class="text-primary"><?= htmlspecialchars($cert['CertificateNo']) ?></span>
</h5>
<table class="table table-bordered w-75 mx-auto text-start mt-3">
<tr>
<th>Enrollment No</th>
<td><?= htmlspecialchars($cert['enrollment']) ?></td>
</tr>
<tr>
<th>Name</th>
<td><?= htmlspecialchars($student['name'] ?? $cert['Name']) ?></td>
<td rowspan="6" class="text-center">
<img src="<?= $photoUrl ?>" alt="Student Photo" width="100" height="146" class="border">
</td>
</tr>
<tr>
<th>Father</th>
<td><?= htmlspecialchars($student['fatherName'] ?? $cert['father_name']) ?></td>
</tr>
<tr>
<th>DOB</th>
<td>
<?php
if (!empty($student['dob'])) {
echo date("d-m-Y", strtotime($student['dob'])); // Indian format
} else {
echo "-";
}
?>
</td>
</tr>
<tr>
<th>Course</th>
<td><?= htmlspecialchars($cert['Course']) ?></td>
</tr>
<tr>
<th>Duration</th>
<td><?= htmlspecialchars($cert['months']) ?> months
(<?= htmlspecialchars($cert['start_date']) ?> - <?= htmlspecialchars($cert['end_date']) ?>)
</td>
</tr>
<tr>
<th>Certificate Issue Date</th>
<td><?= htmlspecialchars($cert['certifcate_issue_date']) ?></td>
</tr>
<tr>
<th>Grade</th>
<td colspan="2"><?= htmlspecialchars($grade) ?></td>
</tr>
<tr>
<th>Branch</th>
<td colspan="2"><?= htmlspecialchars($cert['branch']) ?></td>
</tr>
</table>
<?php
} else {
echo "<div class='alert alert-danger mt-3'>No certificate found with number: $cert_no</div>";
}
} elseif (isset($_GET['Submit'])) {
echo "<div class='alert alert-info mt-3'>Please enter a certificate number.</div>";
}
mysqli_close($link);
?>
</main>
<?php include 'footer.php'; ?>
<!-- Scroll Top -->
<a href="#" id="scroll-top" class="scroll-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>
<!-- Preloader -->
<div id="preloader"></div>
<!-- Vendor JS Files -->
<script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/vendor/php-email-form/validate.js"></script>
<script src="assets/vendor/aos/aos.js"></script>
<script src="assets/vendor/purecounter/purecounter_vanilla.js"></script>
<script src="assets/vendor/swiper/swiper-bundle.min.js"></script>
<script src="assets/vendor/glightbox/js/glightbox.min.js"></script>
<script src="assets/vendor/imagesloaded/imagesloaded.pkgd.min.js"></script>
<script src="assets/vendor/isotope-layout/isotope.pkgd.min.js"></script>
<!-- Main JS File -->
<script src="assets/js/main.js"></script>
</body>
</html>
|