Viewing file:  update_registraion.php (8.31 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html>
<html lang="en">
<?php include 'head.php';?>
<style>
table {
border-collapse: collapse;
width: 100%;
margin-top: 20px;
}
table, th, td {
border: 1px solid #ddd;
}
th, td {
padding: 8px;
text-align: left;
}
th {
background-color: #f2f2f2;
font-weight: bold;
}
.custom-image {
width: 100px;
height: 100px;
}
</style>
<body>
<!-- ======= Header ======= -->
<?php include 'menubar.php';?>
<?php include 'sidebar.php';?>
<main id="main" class="main">
<?php
include 'connect.php';
$sql = "SELECT * FROM admission order by ID DESC";
$result = $conn->query($sql);
?>
<?php
include 'connect.php';
$sql = "SELECT * FROM admission ORDER BY ID DESC";
$result = $conn->query($sql);
?>
<!DOCTYPE html>
<html>
<head>
<title>View Student Registration</title>
<style>
body {
font-family: Arial, sans-serif;
padding: 20px;
background: #f9f9f9;
}
h1 {
color: #004080;
text-align: center;
margin-bottom: 20px;
}
.search-box {
text-align: center;
margin-bottom: 20px;
}
.search-box input {
padding: 10px;
width: 60%;
font-size: 16px;
border: 1px solid #ccc;
border-radius: 4px;
}
table {
width: 100%;
border-collapse: collapse;
background: white;
box-shadow: 0 0 10px rgba(0,0,0,0.05);
}
th, td {
padding: 10px;
text-align: center;
border: 1px solid #ddd;
}
th {
background-color: #004080;
color: white;
}
tr:hover {
background-color: #f1f9ff;
}
.custom-image {
width: 60px;
height: 60px;
object-fit: cover;
border-radius: 5px;
border: 1px solid #aaa;
}
.pagination {
margin-top: 20px;
text-align: center;
}
.pagination button {
padding: 8px 16px;
margin: 0 5px;
border: none;
background-color: #004080;
color: white;
cursor: pointer;
border-radius: 4px;
}
.pagination button:disabled {
background-color: #aaa;
cursor: not-allowed;
}
@media screen and (max-width: 768px) {
table, thead, tbody, th, td, tr {
display: block;
}
thead {
display: none;
}
tr {
margin-bottom: 15px;
border: 1px solid #ccc;
padding: 10px;
background: white;
}
td {
text-align: left;
padding-left: 50%;
position: relative;
}
td::before {
position: absolute;
left: 10px;
font-weight: bold;
}
td:nth-child(1)::before { content: "ID"; }
td:nth-child(2)::before { content: "Registration"; }
td:nth-child(3)::before { content: "Fees Update"; }
td:nth-child(4)::before { content: "Photo"; }
td:nth-child(5)::before { content: "Name"; }
td:nth-child(6)::before { content: "Enrollment"; }
td:nth-child(7)::before { content: "Father"; }
td:nth-child(8)::before { content: "Mother"; }
td:nth-child(9)::before { content: "DOB"; }
td:nth-child(10)::before { content: "Address"; }
td:nth-child(11)::before { content: "Mobile"; }
td:nth-child(12)::before { content: "Secondary Mobile"; }
td:nth-child(13)::before { content: "Aadhar"; }
td:nth-child(14)::before { content: "Reg Date"; }
td:nth-child(15)::before { content: "Reg Month"; }
td:nth-child(16)::before { content: "Reg Year"; }
td:nth-child(17)::before { content: "Fees Amount"; }
td:nth-child(18)::before { content: "Deposit Date"; }
td:nth-child(19)::before { content: "Fees Mode"; }
td:nth-child(20)::before { content: "Edit"; }
}
</style>
</head>
<body>
<h1>View Student Registration</h1>
<div class="search-box">
<input type="text" id="searchInput" onkeyup="filterTable()" placeholder="Search students by any field...">
</div>
<table id="studentTable">
<thead>
<tr>
<th>ID</th>
<th>EDIT</th>
<th>Fees Update</th>
<th>Photo</th>
<th>Name</th>
<th>Enrollment</th>
<th>Father</th>
<th>Mother</th>
<th>DOB</th>
<th>Address</th>
<th>Mobile</th>
<th>Mobile 2</th>
<th>Aadhar</th>
<th>Reg Date</th>
<th>Month</th>
<th>Year</th>
<th>Fees</th>
<th>Deposit Date</th>
<th>Fees Mode</th>
</tr>
</thead>
<tbody>
<?php
$serial = 1;
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$id = $row['ID'];
$photo = "https://itce.co.in/data/files/" . $row['photo'];
echo "<tr>";
echo "<td>{$serial}</td>";
echo "<td><a href='edit_student.php?ID=$id'>Edit</a></td>";
echo "<td>{$row["student_id"]}<br><a href='updatefees_from_id.php?ID={$row["enrollment"]}'>Fees Update</a></td>";
echo "<td><img src='{$photo}' alt='{$row["name"]}' class='custom-image'></td>";
echo "<td>{$row["name"]}</td>";
echo "<td>{$row["enrollment"]}</td>";
echo "<td>{$row["fatherName"]}</td>";
echo "<td>{$row["motherName"]}</td>";
echo "<td>{$row["dob"]}</td>";
echo "<td>{$row["address"]}</td>";
echo "<td>{$row["mobile"]}</td>";
echo "<td>{$row["mobile2"]}</td>";
echo "<td>{$row["aadhar"]}</td>";
echo "<td>{$row["reg_date"]}</td>";
echo "<td>{$row["reg_month"]}</td>";
echo "<td>{$row["reg_year"]}</td>";
echo "<td>{$row["fees_amount"]}</td>";
echo "<td>{$row["fees_deposit_date"]}</td>";
echo "<td>{$row["fees_mode"]}</td>";
echo "</tr>";
$serial++;
}
} else {
echo "<tr><td colspan='20'>No student data available</td></tr>";
}
?>
</tbody>
</table>
<div class="pagination">
<button onclick="prevPage()" id="btnPrev">Previous</button>
<span id="pageInfo"></span>
<button onclick="nextPage()" id="btnNext">Next</button>
</div>
<script>
const rowsPerPage = 10;
let currentPage = 1;
let filteredRows = [];
function getAllRows() {
return Array.from(document.querySelectorAll("#studentTable tbody tr"));
}
function filterTable() {
const filter = document.getElementById("searchInput").value.toLowerCase();
const allRows = getAllRows();
filteredRows = allRows.filter(row => row.innerText.toLowerCase().includes(filter));
allRows.forEach(row => row.style.display = "none");
displayPage(1);
}
function displayPage(page) {
const totalPages = Math.ceil(filteredRows.length / rowsPerPage);
const start = (page - 1) * rowsPerPage;
const end = start + rowsPerPage;
getAllRows().forEach(row => row.style.display = "none");
filteredRows.slice(start, end).forEach(row => row.style.display = "");
document.getElementById("pageInfo").innerText = `Page ${page} of ${totalPages || 1}`;
document.getElementById("btnPrev").disabled = page <= 1;
document.getElementById("btnNext").disabled = page >= totalPages;
currentPage = page;
}
function nextPage() {
if (currentPage < Math.ceil(filteredRows.length / rowsPerPage)) {
displayPage(currentPage + 1);
}
}
function prevPage() {
if (currentPage > 1) {
displayPage(currentPage - 1);
}
}
window.onload = () => {
filteredRows = getAllRows();
displayPage(1);
};
</script>
</body>
</html>
</main><!-- End #main -->
<?php include 'footer.php';?>
</body>
</html>
|