Viewing file:  passout_students.php (2.47 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include 'admin/connect.php';
// Get all issued certificate enrollments
$query = "SELECT enrollment FROM certificate ORDER BY id DESC";
$result = mysqli_query($link, $query);
?>
<section id="clients" class="clients section">
<div data-aos="fade-up" data-aos-delay="100">
<div class="clients-slider swiper init-swiper">
<script type="application/json" class="swiper-config">
{
"loop": true,
"speed": 6000,
"autoplay": {
"delay": 1,
"disableOnInteraction": false
},
"centeredSlides": true,
"slideToClickedSlide": true,
"slidesPerView": "auto",
"spaceBetween": 40,
"breakpoints": {
"320": {
"slidesPerView": 2,
"spaceBetween": 20
},
"640": {
"slidesPerView": 3,
"spaceBetween": 20
},
"992": {
"slidesPerView": 4,
"spaceBetween": 30
},
"1200": {
"slidesPerView": 6,
"spaceBetween": 40
}
}
}
</script>
<div class="swiper-wrapper">
<?php
if ($result && mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$enrollment = $row['enrollment'];
// Get student details from admission
$q2 = "SELECT enrollment, name, fatherName, photo
FROM admission
WHERE enrollment='$enrollment' LIMIT 1";
$r2 = mysqli_query($link, $q2);
if ($r2 && mysqli_num_rows($r2) > 0) {
$student = mysqli_fetch_assoc($r2);
$photo = !empty($student['photo'])
? 'data/files/'.$student['photo']
: 'assets/img/default-student.png';
echo '<div class="swiper-slide">
<div class="client-logo text-center">
<img src="'.$photo.'" class="img-fluid mb-2" alt="'.$student['name'].' ('.$student['enrollment'].')">
<p class="fw-bold small mt-2">'.$student['name'].'</p>
</div>
</div>';
}
}
} else {
echo '<div class="swiper-slide"><div class="client-logo text-center">
<img src="assets/img/default-student.png" class="img-fluid mb-2" alt="No Data">
<p class="fw-bold small">No Data</p>
</div></div>';
}
?>
</div>
</section>
|