<?php include("../Header/Session.php"); ?>
<?php include("../Header/Connection.php"); ?>

<!DOCTYPE html>
<html lang="en">
<?php include ("../Header/head.php"); ?>
<body class="skin-default fixed-layout">

<!-- Main wrapper - style you can find in pages.scss -->
<div id="main-wrapper">    
<?php include ("../Header/header.php"); ?>
<?php include ("../Header/left_menu.php"); ?>
<?php include ("../Header/right_sidebar.php"); ?>
        
<!-- Page wrapper  -->
<div class="page-wrapper">
<!-- Container fluid  -->
<div class="container-fluid">
<!-- Bread crumb and right sidebar toggle -->
<!--?php include ("../Header/breadcumb.php"); ?-->
<br><br>
<!-- End Bread crumb and right sidebar toggle -->
    
<!-- Start Page Content -->
<!-- ============================================================== -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<h4 class="card-title">List Of Announcement</h4>
<div class="table-responsive m-t-40">
<form method="post" action="../Controller/Database_sql.php" enctype="multipart/form-data">
<table id="example23"
    class="display nowrap table table-hover table-striped table-bordered"
    cellspacing="0" width="100%">
    <thead>
        <tr>
            <th>Title</th>
            <th>Action</th>
        </tr>
    </thead>                                      
    <tbody>
        <?php
        $q = "SELECT *
        FROM announcement
        Where status = '1'                           
        order by id Desc";
        $result = $mysqli->query($q);
        if ($result ->num_rows > 0)
        {
            while($record = $result -> fetch_assoc())
            {    
			    $id = $record['id'];
                $announcement_title = $record['announcement_title'];
			    $status = $record['status'];
        ?>
        <tr>
            <td><?php echo $announcement_title; ?></td>
            <input type="hidden" class="form-control"  name="id" value="<?php echo $id; ?>">
            <td>
                <a href="update_announcement.php?id=<?php echo $id;?>" class="btn btn-success"><i class="fa fa-check"></i> Update</a>                  
                <a href="../Controller/Database_sql.php?form_name_Delete_Announcement=Delete_Announcement&announcement_id=<?php echo $id;?>" 
                class="btn btn-danger">
                <i class="fa fa-trash"></i>&nbsp; Delete</a>

            </td>
        </tr>
        <?php 
        }
        }
        ?>
    </tbody>
</table>
</form>                                 
</div>
</div>
</div>                      
</div>
</div>
<!-- ============================================================== -->
<!-- End PAge Content -->

</div>
<!-- End Container fluid  -->
</div>
<!-- End Page wrapper  -->

<!-- Footer Start-->
<?php include ("../Footer/footer.php"); ?>
<!-- Footer End-->

</div>
<!-- End Wrapper -->
<!-- All Jquery -->
    

<!-- All Jquery Start-->
<?php include ("../Header/all_jquery.php"); ?>
<!-- All Jquery End-->

</body>

</html>