iComsium
<?php 
include("include/config.php");
include("include/checklog.php");
?>

<?php include("include/header.php");  ?>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
<?php include("include/sidebar.php");  ?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark">All Message Setting </h1>
          </div><!-- /.col -->
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active"><a href="logout.php">Logout</a></li>
            </ol>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <!-- Small boxes (Stat box) -->
        
        <!-- /.row -->
        <!-- Main row -->
        <div class="row">
          <div class="col-12">
            <div class="card">
              <div class="card-header">
                <h3 class="card-title"> Message Settings </h3>

                <!--<div class="card-tools">
                  <div class="input-group input-group-sm" style="width: 150px;">
                    <input type="text" name="table_search" class="form-control float-right" placeholder="Search">      

                    <div class="input-group-append">
                      <button type="submit" class="btn btn-default"><i class="fas fa-search"></i></button>
                    </div>
                  </div>
                </div>-->
              </div>
              <!-- /.card-header -->
              <div class="card-body table-responsive p-0">
                <table class="table table-hover text-nowrap">
                  <thead>
                    <tr>
                      <th>Title</th>	
                      <th>Users/Group</th> 
					  <th>Start Date</th> 
                      <th>Time</th> 
                      <th>Status</th>
                      <th>Message</th>    					  
                      <th>Edit</th>
					  <th>Delete</th>
					  
                      
                    </tr>
                  </thead>
                  <tbody>
				    <?php 
					$sql="select *from message6 order by id desc ";
					$result=mysqli_query($conn,$sql);
					while($row=mysqli_fetch_assoc($result))
					{
					 if($row["usertype"]==1)
                     {						 
					  $sql2="SELECT *FROM `register_user` where username='".$row["user"]."'    ";	
					  $result2=mysqli_query($conn,$sql2);
					  $row2=mysqli_fetch_assoc($result2);
					  $user=$row2["name"];
					 }
                     else
                     {
                      $sql2="SELECT *FROM `message_group` where id='".$row["user"]."'    ";	
					  $result2=mysqli_query($conn,$sql2);
					  $row2=mysqli_fetch_assoc($result2);
					  $user=$row2["title"];
					 }				 
					?>
				  
                    <tr>
                      
					  <td><?php echo $row["title"]; ?></td>                           					  
                      <td><?php echo $user ?></td> 
					  <td><?php echo $row["start_date"]; ?></td> 
					  <td><?php echo $row["time"]; ?></td> 
					  <td><?php if($row["status"]==1) echo "On"; else echo "Off"; ?></td>
					  <td><?php echo $row["msg"]; ?></td>					                                              
					  <td><button type="button" class="btn btn-primary" onclick="window.location.href='edit-msg-setting.php?id=<?php echo base64_encode($row["id"]); ?>'" >Edit</button></td>        
					  <td><button type="button" class="btn btn-primary" onclick="window.location.href='delete-msg-setting.php?id=<?php echo base64_encode($row["id"]); ?>'" >Delete</button></td> 
                    
					</tr>
					
					<?php } ?>
					
                    
                  </tbody>
                </table>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
        </div>
        <!-- /.row (main row) -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  <footer class="main-footer">
    <strong>Copyright &copy; 2022 Admin Panel.</strong>
    All rights reserved.
    <div class="float-right d-none d-sm-inline-block">
       
    </div>
  </footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->

<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- jQuery UI 1.11.4 -->
<script src="plugins/jquery-ui/jquery-ui.min.js"></script>
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<script>
  $.widget.bridge('uibutton', $.ui.button)
</script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- ChartJS -->
<script src="plugins/chart.js/Chart.min.js"></script>
<!-- Sparkline -->
<script src="plugins/sparklines/sparkline.js"></script>
<!-- JQVMap -->
<script src="plugins/jqvmap/jquery.vmap.min.js"></script>
<script src="plugins/jqvmap/maps/jquery.vmap.usa.js"></script>
<!-- jQuery Knob Chart -->
<script src="plugins/jquery-knob/jquery.knob.min.js"></script>
<!-- daterangepicker -->
<script src="plugins/moment/moment.min.js"></script>
<script src="plugins/daterangepicker/daterangepicker.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Summernote -->
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<!-- overlayScrollbars -->
<script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -->
<script src="dist/js/pages/dashboard.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
</body>
</html>