📁 File Manager
🏠 /
/
home
/
u857492117
/
domains
/
mangaldaicollege.org
/
public_html
/
admission
/
admin
Dosya Düzenle: details_data.php
<?php include("connect.php"); // Fetch all joined student data (all columns) $query = " SELECT p.*, pd.*, ad.*, fs.* FROM prereg p LEFT JOIN personal_details pd ON p.guroll = pd.guroll AND p.collegeroll = pd.collegeroll LEFT JOIN academic_details ad ON p.guroll = ad.guroll AND p.collegeroll = ad.collegeroll INNER JOIN form_status fs -- changed from LEFT JOIN to INNER JOIN ON p.guroll = fs.guroll AND p.collegeroll = fs.collegeroll ORDER BY p.name ASC "; $result = mysqli_query($con, $query); ?> <!DOCTYPE html> <html> <head> <title>Student Details</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">Full Student Details</h3> <table id="studentTable" class="table table-striped table-bordered"> <thead class="table-dark"> <tr> <th>Sl. No.</th> <th>Name</th> <th>College Roll</th> <th>GU Roll</th> <th>Enroll</th> <th>GU Enroll</th> <th>Phone</th> <th>Email</th> <th>DOB</th> <th>Admission For</th> <th>Stream</th> <th>Major Status</th> <th>Subject 1</th> <th>Subject 2</th> <th>SEC</th> <th>Father</th> <th>Mother</th> <th>Guardian</th> <th>Gender</th> <th>Caste</th> <th>Address</th> <th>Form No</th> <th>Submission Date</th> <th>Form Status</th> <th>Form Remarks</th> <th>Reg Date</th> <th>Remarks</th> <th>Status</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['enroll']) ?></td> <td><?= htmlspecialchars($row['guenroll']) ?></td> <td><?= htmlspecialchars($row['phone']) ?></td> <td><?= htmlspecialchars($row['email']) ?></td> <td><?= htmlspecialchars($row['dob']) ?></td> <td><?= htmlspecialchars($row['admissionfor']) ?></td> <td><?= htmlspecialchars($row['stream']) ?></td> <td><?= htmlspecialchars($row['majorstatus']) ?></td> <td><?= htmlspecialchars($row['sub1']) ?></td> <td><?= htmlspecialchars($row['sub2']) ?></td> <td><?= htmlspecialchars($row['sec']) ?></td> <td><?= htmlspecialchars($row['fathername']) ?></td> <td><?= htmlspecialchars($row['mothername']) ?></td> <td><?= htmlspecialchars($row['guardian']) ?></td> <td><?= htmlspecialchars($row['gender']) ?></td> <td><?= htmlspecialchars($row['caste']) ?></td> <td><?= htmlspecialchars($row['address']) ?></td> <td><?= htmlspecialchars($row['registrationformno']) ?></td> <td><?= htmlspecialchars($row['submission_date']) ?></td> <td><?= htmlspecialchars($row['status']) ?></td> <td><?= htmlspecialchars($row['remarks']) ?></td> <td><?= htmlspecialchars($row['regdate']) ?></td> <td><?= htmlspecialchars($row['prereg_remarks'] ?? $row['remarks']) ?></td> <td><?= htmlspecialchars($row['prereg_status'] ?? $row['status']) ?></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']], columnDefs: [ { orderable: false, targets: 0 } ] }); // auto serial update table.on('order.dt search.dt', function () { let i = 1; table.cells(null, 0, { search: 'applied', order: 'applied' }) .every(function () { this.data(i++); }); }).draw(); }); </script> </body> </html>
💾 Kaydet
İptal