<?php
include_once('../includes/db_connect.php');
$conn=$con;
if (isset($_POST['serial'])) {
    $serial = $conn->real_escape_string($_POST['serial']);

    // $sql = "SELECT student_name, award, course, cert_key, admission_year 
    //         FROM certificates WHERE cert_key = '$serial' LIMIT 1";
    
    $sql = "SELECT paststudents.name AS student_name, courses.type AS award, courses.title AS course, paststudents.admno AS cert_key, paststudents.joindate AS admission_year FROM paststudents,courses WHERE paststudents.admno = '$serial' AND paststudents.courseid=courses.id LIMIT 1";
            
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        $admyr=date('d M Y',strtotime($row['admission_year']));

        echo "
        <div class='card shadow-sm p-3'>
          <h5 class='text-center mb-3 text-primary'>Certificate Details</h5>

          <div class='info-box mb-2'>
            <i class='bi bi-person-fill icon'></i>
            <div>
              <strong>Student Name:</strong><br>
              <span>{$row['student_name']}</span>
            </div>
          </div>

          <div class='info-box mb-2'>
            <i class='bi bi-award-fill icon'></i>
            <div>
              <strong>Academic Award:</strong><br>
              <span>{$row['award']}</span>
            </div>
          </div>

          <div class='info-box mb-2'>
            <i class='bi bi-mortarboard-fill icon'></i>
            <div>
              <strong>Course:</strong><br>
              <span>{$row['course']}</span>
            </div>
          </div>

          <div class='info-box key-box mb-2'>
            <i class='bi bi-key-fill icon'></i>
            <div>
              <strong>Certificate Key:</strong><br>
              <span>{$row['cert_key']}</span>
            </div>
          </div>

          <div class='info-box mb-2'>
            <i class='bi bi-calendar-fill icon'></i>
            <div>
              <strong>Date of Admission:</strong><br>
              <span>{$admyr}</span>
            </div>
          </div>
        </div>
        ";
    } else {
        echo "<div class='alert alert-danger'>Invalid certificate number. Please try again.</div>";
    }
}
?>