📁 File Manager
🏠 /
/
home
/
u857492117
/
domains
/
mangaldaicollege.org
/
public_html
/
itep
/
adminitep
Dosya Düzenle: index.php
<?php session_start(); include 'connect.php'; if(!isset($_SESSION['admin'])){ header("location:admin_login.php"); exit(); } ?> <?php $total_query = mysqli_query($con,"SELECT COUNT(*) as total FROM itep_notice"); $total_data = mysqli_fetch_assoc($total_query); $academic_query = mysqli_query($con,"SELECT COUNT(*) as total FROM itep_notice WHERE notice_type='Academic Notice'"); $academic_data = mysqli_fetch_assoc($academic_query); $official_query = mysqli_query($con,"SELECT COUNT(*) as total FROM itep_notice WHERE notice_type='Official Order'"); $official_data = mysqli_fetch_assoc($official_query); ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Admin Panel</title> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css"> <style> body{ background:#f4f6fb; font-family:Arial; } /* Sidebar */ .sidebar{ height:100vh; background:#1a237e; color:white; position:fixed; width:230px; padding-top:20px; } .sidebar h4{ text-align:center; margin-bottom:30px; } .sidebar a{ display:block; color:white; padding:12px 20px; text-decoration:none; } .sidebar a:hover{ background:#3949ab; } /* Main */ .main{ margin-left:230px; padding:30px; } .card{ border-radius:10px; box-shadow:0 3px 10px rgba(0,0,0,0.1); } </style> </head> <body> <!-- Sidebar --> <div class="sidebar"> <h4>Admin Panel</h4> <a href="#">Dashboard</a> <a href="#" onclick="openAddNotice()">Add Notice</a> <a href="#">Manage Notices</a> <a href="#">Upload Documents</a> <a href="#">Users</a> <a href="#">Settings</a> <a href="logout.php" style="background:#dc3545;">Logout</a> </div> <!-- Main Content --> <div class="main"> <h3>Dashboard</h3> <div class="row"> <div class="col-md-4"> <div class="card p-3"> <h5>Total Notices</h5> <h2><?php echo $total_data['total']; ?></h2> </div> </div> <div class="col-md-4"> <div class="card p-3"> <h5>Academic Notices</h5> <h2><?php echo $academic_data['total']; ?></h2> </div> </div> <div class="col-md-4"> <div class="card p-3"> <h5>Official Orders</h5> <h2><?php echo $official_data['total']; ?></h2> </div> </div> </div> <!-- Add Notice Form --> <div id="noticeForm" style="display:none; margin-top:30px;"> <div class="card p-4"> <h4>Add Notice</h4> <form action="save_notice.php" method="POST" enctype="multipart/form-data"> <div class="mb-3"> <label>Notice Title</label> <input type="text" name="title" class="form-control" required> </div> <div class="mb-3"> <label>Topic</label> <input type="text" name="topic" class="form-control"> </div> <div class="mb-3"> <label>Notice Type</label> <select name="notice_type" class="form-control"> <option value="Academic Notice">Academic Notice</option> <option value="Official Order">Official Order</option> </select> </div> <div class="mb-3"> <label>Upload Document</label> <input type="file" name="document" class="form-control"> </div> <div class="mb-3"> <label>Link</label> <input type="text" name="link" class="form-control"> </div> <div class="mb-3"> <label>Date</label> <input type="date" name="notice_date" class="form-control"> </div> <button class="btn btn-primary">Submit Notice</button> </form> <hr> <h5>Existing Notices</h5> <?php $limit = 10; $page = isset($_GET['page']) ? $_GET['page'] : 1; $start = ($page - 1) * $limit; $query = mysqli_query($con,"SELECT * FROM itep_notice ORDER BY notice_date DESC LIMIT $start,$limit"); ?> <table class="table table-bordered mt-3"> <tr> <th>ID</th> <th>Title</th> <th>Type</th> <th>Date</th> <th>Action</th> </tr> <?php while($row = mysqli_fetch_assoc($query)){ echo "<tr> <td>".$row['id']."</td> <td>".$row['title']."</td> <td>".$row['notice_type']."</td> <td>".$row['notice_date']."</td> <td> <a href='delete_notice.php?id=".$row['id']."' class='btn btn-danger btn-sm' onclick=\"return confirm('Delete this notice?')\">Delete</a> </td> </tr>"; } ?> </table> <?php $total_result = mysqli_query($con,"SELECT COUNT(*) AS total FROM itep_notice"); $total_row = mysqli_fetch_assoc($total_result); $total_pages = ceil($total_row['total'] / $limit); ?> <nav> <ul class="pagination"> <?php for($i=1;$i<=$total_pages;$i++){ echo "<li class='page-item'> <a class='page-link' href='?page=$i'>$i</a> </li>"; } ?> </ul> </nav> </div> </div> </div> <script> function openAddNotice(){ document.getElementById("noticeForm").style.display="block"; } </script> </body> </html>
💾 Kaydet
İptal