📁 File Manager

Dosya Düzenle: view_all_notices.php

<?php
include("connect.php");
$Did = $_GET['Did'] ?? 0; // or use session
?>

<?php
include 'connect.php';

$deptName = $_GET['Did'];
//$deptName = "Assamese";
$sql = "select * from dept where Did = '$deptName'";
		$q = mysqli_query($con,$sql);
		if ($r = mysqli_fetch_array($q))
		{
		 $about = $r['Details'];
			
		 $name=$r['DepName'];
		$Did=$r['Did'];	
		}
?>
<html lang="zxx" class="no-js">
	<head>
		
		<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
		
		<link rel="icon" href="img/favicon.ico" type="image/gif" sizes="16x16">
  <link rel="shortcut icon" href="img/favicon.ico" type="image/x-icon">
  <link rel="icon" href="img/favicon.ico" type="image/x-icon">
   <title>মঙলদৈ মহাবিদ্যালয় </title>
		
		<meta name="description" content="">
		
		<meta name="keywords" content="">
		
		<meta charset="UTF-8">

<link href="assetsDept/img/favicon.png" rel="icon">
  <link href="assetsDept/img/apple-touch-icon.png" rel="apple-touch-icon">

<link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Raleway:300,300i,400,400i,500,500i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">

<link href="assetsDept/vendor/animate.css/animate.min.css" rel="stylesheet">
  <link href="assetsDept/vendor/aos/aos.css" rel="stylesheet">
  <link href="assetsDept/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <link href="assetsDept/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
  <link href="assetsDept/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
  <link href="assetsDept/vendor/glightbox/css/glightbox.min.css" rel="stylesheet">
  <link href="assetsDept/vendor/remixicon/remixicon.css" rel="stylesheet">
  <link href="assetsDept/vendor/swiper/swiper-bundle.min.css" rel="stylesheet">

<link href="assetsDept/css/style.css" rel="stylesheet">
		
	
		
<link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.2.0/css/bootstrap.min.css" rel="stylesheet">
		<link href="https://cdn.datatables.net/1.13.4/css/dataTables.bootstrap5.min.css" rel="stylesheet">

$(document).ready(function () {
	$('#example').DataTable();
});

</script>
		
		
		<style>
			#google_translate_element select {
    background-color: #f6edfd;
    color: #121689;
    border: 2px solid;
    border-radius: 16px;
    padding: 9px 31px;
}
			.goog-te-gadget .goog-te-combo {
				margin: 4px 0;
			}
			#google_translate_element .goog-te-gadget {
    color: transparent;
}
			
			.footer-area {
    background-color: #04091e;
			}
			
			
			
			.section-gap {
    padding: 120px 0;
}
			.footer-area h4{
			color:white;	
			}
			.footer-area ul li a{
			color:white;	
			}
			
			a:link{
				
			text-decoration: none;	
			}
		</style>
		
		
</head>

<body>

<header id="header" class="fixed-top d-flex align-items-center  header-transparent ">
    <div class="container d-flex align-items-center justify-content-between">

<nav id="navbar" class="navbar">
        <ul>
          <li><a class="nav-link scrollto active" href="index.php">Home</a></li>
          <li><a class="nav-link scrollto" href="#about">Results</a></li>
          <li><a class="nav-link scrollto" href="#Facilities">Facilities</a></li>
         
         
          <li><a class="nav-link scrollto" href="#contact">Contact</a></li>
        </ul>
        <i class="bi bi-list mobile-nav-toggle"></i>
      </nav>

</div>
  </header>

<section id="hero" class="d-flex flex-column justify-content-end align-items-center">
    <div id="heroCarousel" data-bs-interval="5000" class="container carousel carousel-fade" data-bs-ride="carousel">

<div class="carousel-item active">
        <div class="carousel-container">
          <h2 class="animate__animated animate__fadeInDown"><?php  $a=htmlspecialchars($deptName);
			  echo "$name";
   ?> Department <br> Notices
			  
			  </h2>
          <p class="animate__animated fanimate__adeInUp"> </p>
          <a href="deptProfile.php?id=<?php echo $name; ?>" class="btn-get-started animate__animated animate__fadeInUp scrollto" decoration="none">Back To Department,</a>
        </div>
      </div>

</div>

</section>

<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">

<link rel="stylesheet" href="https://cdn.datatables.net/1.13.4/css/dataTables.bootstrap5.min.css">

<section id="about" class="about py-4">
  <div class="container">
    <h2 class="mb-4">All Departmental Notices</h2>

<div class="table-responsive">
      <table id="noticeTable" class="table table-striped table-bordered">
        <thead class="table-dark">
          <tr>
            <th>Sl. No.</th>
            <th>Notice</th>
            <th>Date</th>
          </tr>
        </thead>
        <tbody>
          <?php
          $query = "SELECT * FROM dept_notice WHERE Did=$Did ORDER BY date DESC";
          $result = mysqli_query($con, $query);
          $sl = 1;
          while ($row = mysqli_fetch_assoc($result)) {
              echo "<tr>";
              echo "<td>{$sl}</td>";
              echo "<td><a href='deptadminpanel/{$row['link']}' target='_blank'>{$row['notice']}</a></td>";
              echo "<td>{$row['date']}</td>";
              echo "</tr>";
              $sl++;
          }
          ?>
        </tbody>
      </table>
    </div>
  </div>
</section>

<script src="https://code.jquery.com/jquery-3.7.0.min.js"></script>

<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>

<script src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.13.4/js/dataTables.bootstrap5.min.js"></script>

<script>
  $(document).ready(function () {
    $('#noticeTable').DataTable({
      "order": [[2, "desc"]]  // Default sort by Date (3rd column) descending
    });
  });
</script>

</main>

<footer class="footer-area section-gap">
				<div class="container">
					<div class="row">
						<div class="col-lg-2 col-md-6 col-sm-6">
							<div class="single-footer-widget">
								<h4>E-Resources2</h4>
								<ul>
									<li><a href="#">E-Journals</a></li>
									<li><a href="#">E-books</a></li>
									<li><a href="#">Google Books</a></li>
									<li><a href="#">Accademic Journals</a></li>
									<li><a href="#">N-list of INFLIBNET</a></li>
								</ul>								
							</div>
						</div>
						<div class="col-lg-2 col-md-6 col-sm-6">
							<div class="single-footer-widget">
								<h4>Quick links</h4>
								<ul>
									<li><a href="#">Gauhati University</a></li>
									<li><a href="#">Assam Plants</a></li>
									<li><a href="#">UGC</a></li>
									<li><a href="#">DHE</a></li>
									<li><a href="#">ACTA</a></li>
									<li><a href="#">NAAC</a></li>
								</ul>								
							</div>
						</div>
						<div class="col-lg-2 col-md-6 col-sm-6">
							<div class="single-footer-widget">
								<h4>Features</h4>
								<ul>
									<li><a href="#">KKH State Open University</a></li>
									<li><a href="#">E-Content Development Centre</a></li>
									<li><a href="#">Star College</a></li>
									<li><a href="#">NCC</a></li>
									<li><a href="#">NSS</a></li>
								</ul>								
							</div>
						</div>
						<div class="col-lg-2 col-md-6 col-sm-6">
							<div class="single-footer-widget">
								<h4>Resources</h4>
								<ul>
									<li><a href="#">Syllabus</a></li>
									<li><a href="#">Question Paper</a></li>
									<li><a href="#">Library</a></li>
									
								</ul>								
							</div>
						</div>																		
						<div class="col-lg-4  col-md-6 col-sm-6">
							<div class="single-footer-widget">
								<h4>Get Notification</h4>
								<p>Stay update with our latest Notification</p>
								<div class="" id="mc_embed_signup">
									 <form target="_blank" action="https://spondonit.us12.list-manage.com/subscribe/post?u=1462626880ade1ac87bd9c93a&amp;id=92a4423d01" method="get">
									  <div class="input-group">
									    <input type="text" class="form-control" name="EMAIL" placeholder="Enter Email Address" onfocus="this.placeholder = ''" onblur="this.placeholder = 'Enter Email Address '" required="" type="email">
									    <div class="input-group-btn">
									      <button class="btn btn-default" type="submit">
									        <span class="lnr lnr-arrow-right"></span>
									      </button>    
									    </div>
									    	<div class="info"></div>  
									  </div>
									</form> 
								</div>
							</div>
						</div>											
					</div>
					<div class="footer-bottom row align-items-center justify-content-between">
						<p class="footer-text m-0 col-lg-6 col-md-12">
Copyright &copy;<script>document.write(new Date().getFullYear());</script> All rights reserved | CSIT Team, Mangaldai College</a>
</p>
						<div class="col-lg-6 col-sm-12 footer-social">
							
							<div id='google_translate_element'></div>

<script src="assetsDept/vendor/aos/aos.js"></script>
  <script src="assetsDept/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assetsDept/vendor/glightbox/js/glightbox.min.js"></script>
  <script src="assetsDept/vendor/isotope-layout/isotope.pkgd.min.js"></script>
  <script src="assetsDept/vendor/swiper/swiper-bundle.min.js"></script>
  <script src="assetsDept/vendor/php-email-form/validate.js"></script>

<script src="assetsDept/js/main.js"></script>

</body>

</html>

İptal