1#@!#!123s

: / home / epksuofuukz9 / www / admin /
Filename : view_menu_section.php
back
<?php include("includes/header.php"); ?>
<?php $the_id=$_GET['view'];?>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
  <!-- Navbar -->
  <?php include("includes/top_nav.php");?>
  <!-- /.navbar -->
  <!-- Main Sidebar Container -->
  <?php include("includes/side_nav.php");?>
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Menu Section</h1>
          </div>
		  <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="dashboard.php" style="color:#111;">Dashboard</a></li>
              <li class="breadcrumb-item"><a href="view_all_menu.php" style="color:#111;">View Menu Courses</a></li>
              <li class="breadcrumb-item"><a href="edit_menu_posts.php?edit=<?php echo $the_id; ?>" style="color:#111;">Edit Menu Courses</a></li>
              <li class="breadcrumb-item active">Add Menu Section</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
	<!-- Main content -->

 <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <!-- left column -->
          <div class="col-md-6">
            <!-- general form elements -->
            <div class="card card-primary">
              <div class="card-header" style="background:#040202;">
                <h3 class="card-title">Add New Menu Section</h3>
              </div>
              <!-- /.card-header -->
              <!-- form start -->
              <form role="form" method="POST" action="">
                <div class="card-body">
                  <div class="form-group">
                    <label for="exampleInputEmail1">Section Name</label>
                    <input type="text" class="form-control" name="section_name" id="exampleInputEmail1" placeholder="Section Name" required>
                  </div>
                </div>
                <!-- /.card-body -->
                <div class="card-footer">
                  <button type="submit" name="add" class="btn btn-primary" style="background:#040202">Submit</button>
                </div>
              </form>
            </div>
            <!-- /.card -->
          </div>
          <!--/.col (left) -->
		  <!-- left column -->
          <div class="col-md-6">
            <!-- general form elements -->
            <div class="card">
            <div class="card-header">
              <h3 class="card-title">View Menu Section</h3>
            </div>
            <!-- /.card-header -->
            <div class="card-body table-responsive">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>S.N.</th>
                  <th>Section Name</th>
                  <th>Action</th>
                </tr>
                </thead>
                <tbody>
				<?php
				$i=0;
				$get="SELECT * FROM menu_main_section WHERE `menu_main_section_course_id`='$the_id'";
				$run=query($get);
				while($row=fetch($run))
				{
          $section_id=$row['menu_main_section_id'];
					$section_name=$row['menu_main_section_name'];
					$i++;
				?>
                <tr>
                  <td><?php echo $i; ?></td>
                  <td><?php echo $section_name; ?></td>
				  <td>
				  <button type="button" class="btn btn-block btn-secondary btn-sm" data-toggle="modal" data-target="#modal-default<?php echo $section_id; ?>">
                Edit
              </button>
			  <div class="modal fade" id="modal-default<?php echo $section_id; ?>" style="display: none;" aria-hidden="true">
        <div class="modal-dialog">
          <div class="modal-content">
            <div class="modal-header">
              <h4 class="modal-title">Edit Menu Section</h4>
            </div>
			<form method="POST" action="" >
                
            <div class="modal-body">
              <div class="form-group">
                    <label for="exampleInputEmail1">Section Name</label>
                    <input type="text" class="form-control" name="section_name" id="exampleInputEmail1" value="<?php echo $section_name; ?>" placeholder="Section Name" required>
					<input type="hidden" name="section_id" value="<?php echo $section_id; ?>">
              </div>
            </div>
            <div class="modal-footer justify-content-between">
              <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
              <button type="submit" name="submit" class="btn btn-primary">Save changes</button>
            </div>
			</form>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div>
				  <a href="view_menu_section.php?delete=<?php echo $section_id; ?>&view=<?php echo $the_id; ?>"><button type="button" class="btn btn-block btn-danger btn-sm" onclick="return confirm('Are you sure you want to delete it?');">Delete</button></a></td>
                </tr>
				<?php
				}
	  ?>
				</tbody>
                <tfoot>
                <tr>
                  <th>S.N.</th>
                  <th>Section Name</th>
                  <th>Action</th>
                </tr>
                </tfoot>
              </table>
            </div>
            <!-- /.card-body -->
          </div>
            <!-- /.card -->
          </div>
          <!--/.col (left) -->
        </div>
        <!-- /.row -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
    <!-- /.content -->
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  <?php include("includes/footer.php");?>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<?php include("includes/scripts.php"); ?>
<script>
  $(function () {
    $("#example1").DataTable();
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
    });
  });
</script>
<?php 

if(isset($_GET['delete']))
{
  $the_delete=$_GET['delete'];
  $the_id=$_GET['view'];
	$delete="DELETE FROM menu_main_section WHERE `menu_main_section_id`='$the_delete'";
	$run_delete=query($delete);
	confirm($run_delete);
	if($run_delete)
	{
		echo "<script>alert('Menu Section has been deleted');</script>";
		echo "<script>window.open('view_menu_section.php?view=$the_id','_self');</script>";
	}
}
if(isset($_POST['submit']))
{
  $section_name=$_POST['section_name'];
  $section_id=$_POST['section_id'];
  $update="UPDATE `menu_main_section` SET `menu_main_section_name`='$section_name' WHERE `menu_main_section_id`='$section_id'";
  $run=query($update);
  if($run)
  {
  echo "<script>alert('Section has been updated');</script>";
    echo "<script>window.open('view_menu_section.php?view=$the_id','_self');</script>";   
  }
}
if(isset($_POST['add']))
{
  $section_name=$_POST['section_name'];
  $the_id;
  $insert="INSERT INTO `menu_main_section`(`menu_main_section_course_id`, `menu_main_section_name`) VALUES ('$the_id','$section_name')";
  $run=query($insert);
  if($run)
  {
    echo "<script>alert('New Section has been added');</script>";
    echo "<script>window.open('view_menu_section.php?view=$the_id','_self');</script>"; 
  } 
}
?>
</body>
</html>