📁 File Manager
🏠 /
/
home
/
u857492117
/
domains
/
mangaldaicollege.org
/
public_html
/
admission
/
data
Dosya Düzenle: 35.php
<?php include("connect.php"); // Fetch distinct Subject 1 and Subject 2 for dropdown filters $sub1List = mysqli_query($con, "SELECT DISTINCT sub1 FROM academic_details WHERE sub1 IS NOT NULL AND sub1!=''"); $sub2List = mysqli_query($con, "SELECT DISTINCT sub2 FROM academic_details WHERE sub2 IS NOT NULL AND sub2!=''"); // Fetch distinct admissionfor (Year) for dropdown filter $admissionforList = mysqli_query($con, "SELECT DISTINCT admissionfor FROM prereg WHERE admissionfor IS NOT NULL AND admissionfor != '' ORDER BY admissionfor ASC"); // Fetch all joined student data $query = " SELECT prereg.name, prereg.admissionfor, prereg.collegeroll, prereg.guroll, prereg.phone, prereg.email, academic_details.sub1, academic_details.sub2, academic_details.sec, academic_details.majorstatus, academic_details.stream FROM prereg JOIN academic_details ON prereg.guroll = academic_details.guroll AND prereg.collegeroll = academic_details.collegeroll ORDER BY prereg.name ASC "; $result = mysqli_query($con, $query); ?> <!DOCTYPE html> <html> <head> <title>Student List</title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"> <link href="https://cdn.datatables.net/1.13.5/css/dataTables.bootstrap5.min.css" rel="stylesheet"> <link href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.bootstrap5.min.css" rel="stylesheet"> </head> <body class="bg-light p-4"> <div class="container shadow p-4 bg-white rounded"> <h3 class="mb-4 text-center">Student List ( BA/Bsc 2nd /3rd Year) </h3> <h3 class="mb-4 text-center">Data May be change( Admission running!!!) </h3> <!-- Filter Row --> <div class="row mb-3"> <div class="col-md-3"> <label class="form-label">Filter by Subject 1</label> <select id="filterSub1" class="form-select"> <option value="">All</option> <?php while($row = mysqli_fetch_assoc($sub1List)) { ?> <option value="<?php echo htmlspecialchars($row['sub1']); ?>"><?php echo htmlspecialchars($row['sub1']); ?></option> <?php } ?> </select> </div> <div class="col-md-3"> <label class="form-label">Filter by Subject 2</label> <select id="filterSub2" class="form-select"> <option value="">All</option> <?php while($row = mysqli_fetch_assoc($sub2List)) { ?> <option value="<?php echo htmlspecialchars($row['sub2']); ?>"><?php echo htmlspecialchars($row['sub2']); ?></option> <?php } ?> </select> </div> <div class="col-md-3"> <label class="form-label">Filter by Major Status</label> <select id="filterMajor" class="form-select"> <option value="">All</option> <option value="1 Major 1 Minor">1 Major 1 Minor</option> <option value="2 Minors">2 Minors</option> </select> </div> <div class="col-md-3"> <label class="form-label">Filter by Admission Year</label> <select id="filterAdmission" class="form-select"> <option value="">All</option> <?php while($row = mysqli_fetch_assoc($admissionforList)) { ?> <option value="<?php echo htmlspecialchars($row['admissionfor']); ?>"> <?php echo htmlspecialchars($row['admissionfor']); ?> </option> <?php } ?> </select> </div> </div> <!-- Table --> <table id="studentTable" class="table table-striped table-bordered"> <thead class="table-dark"> <tr> <th>Serial No.</th> <th>Student Name</th> <th>College Roll</th> <th>GU Roll</th> <th>Phone</th> <th>Email</th> <th>Year</th> <th>Subject 1</th> <th>Subject 2</th> <th>SEC</th> <th>Major Status</th> <th>Stream</th> </tr> </thead> <tbody> <?php $serial = 1; while($row = mysqli_fetch_assoc($result)) { ?> <tr> <td><?= $serial++ ?></td> <td><?= htmlspecialchars($row['name']) ?></td> <td><?= htmlspecialchars($row['collegeroll']) ?></td> <td><?= htmlspecialchars($row['guroll']) ?></td> <td><?= htmlspecialchars($row['phone']) ?></td> <td><?= htmlspecialchars($row['email']) ?></td> <td><?= htmlspecialchars($row['admissionfor']) ?></td> <td><?= htmlspecialchars($row['sub1']) ?></td> <td><?= htmlspecialchars($row['sub2']) ?></td> <td><?= htmlspecialchars($row['sec']) ?></td> <td><?= htmlspecialchars($row['majorstatus']) ?></td> <td><?= htmlspecialchars($row['stream']) ?></td> </tr> <?php } ?> </tbody> </table> </div> <!-- Scripts --> <script src="https://code.jquery.com/jquery-3.7.0.min.js"></script> <script src="https://cdn.datatables.net/1.13.5/js/jquery.dataTables.min.js"></script> <script src="https://cdn.datatables.net/1.13.5/js/dataTables.bootstrap5.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.bootstrap5.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script> <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js"></script> <script> $(document).ready(function() { var table = $('#studentTable').DataTable({ dom: 'Bfrtip', buttons: ['csv'], order: [[1, 'asc']], // Order by name by default columnDefs: [ { orderable: false, targets: 0 } // Disable sorting on Serial No. ] }); // Add serial numbers dynamically after sorting/searching table.on('order.dt search.dt', function () { let i = 1; table.cells(null, 0, { search: 'applied', order: 'applied' }) .every(function () { this.data(i++); }); }).draw(); // Filter by Subject 1 $('#filterSub1').on('change', function(){ table.column(7).search(this.value).draw(); }); // Filter by Subject 2 $('#filterSub2').on('change', function(){ table.column(8).search(this.value).draw(); }); // Filter by Major Status $('#filterMajor').on('change', function(){ table.column(10).search(this.value).draw(); // Note: majorstatus is 11th column (index 10) }); // Filter by Admission Year $('#filterAdmission').on('change', function(){ table.column(6).search(this.value).draw(); }); }); </script> </body> </html>
💾 Kaydet
İptal