1#@!#!123s

: / home / epksuofuukz9 / www / admin /
Filename : manage_course.php
back
<?php include("includes/header.php"); ?>
<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>Courses</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 active"><?= isset($_GET['page']) ? ucfirst($_GET['page']):'Add';?> Course</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
    <!-- Main content -->
 <!-- Main content -->
 
 <?php 
 
   function get_content($id){
             $sql="SELECT * FROM course_header_content where course_id='".$id."'";
             $query=query($sql);
    return row_count($query);
   }
 
 ?>
    <section class="content">
      <div class="container-fluid">
        <div class="row">
        <?php if(isset($_GET['page']) && $_GET['page']=='edit'){
             
             $sql="SELECT * FROM course_header_content where id='".$_GET['id']."'";
             $query=query($sql);
          	 $edit = fetch($query);
        
        ?>
         <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-primary">
              <div class="card-header" style="background:#040202;">
                <h3 class="card-title"><?= isset($_GET['page']) ? ucfirst($_GET['page']):'Add';?> Course</h3>
              </div>
              <form method="POST" action="php/function.php?action=update_course&id=<?= $edit['id'];?>" enctype="multipart/form-data" novalidate="" id="form">
                <div class="card-body">
                  <div class="form-group">
                    <label for="exampleInputEmail1">Menu / Sub Menu </label>
                    <select class="form-control select_menu" name="type_menu"  required="">
                      <option value="menu" <?= $edit['type_menu'] =='menu' ? 'selected':''; ?>>Menu</option>
                      <option value="submenu" <?= $edit['type_menu'] =='submenu' ? 'selected':''; ?>>Sub Menu</option>
                       
                    </select>
                  </div>
                  <div class="form-group submenuhide" <?= $edit['type_menu'] =='menu' ? 'style="display: none"':''; ?>>
                    <label for="exampleInputEmail1">Course Name</label>&nbsp;&nbsp;<span class="Errcourse Err"></span>
                    <select class="form-control sub_menu" name="<?= $edit['type_menu'] =='submenu' ? 'course_id"':''; ?>" required="">
                      <option value="">Select Course</option>
                       <?php $get_all="SELECT * FROM courses ORDER BY course_id DESC";
            				  $run_all=query($get_all);
            				 
            				 while($row_all=fetch($run_all)){?>
            				    <option value="<?= $row_all['course_id']; ?>" <?= $edit['course_id'] ==$row_all['course_id'] ? 'selected':''; ?>><?= $row_all['course_name']; ?></option>
            					
            				<?php } ?>
                    </select>
                  </div>
                  <div class="form-group menuhide" <?= $edit['type_menu'] =='submenu' ? 'style="display: none"':''; ?>>
                    <label for="exampleInputEmail1">Course Name</label>&nbsp;&nbsp;<span class="Errcourse Err"></span>
                    <select class="form-control menu" name="<?= $edit['type_menu'] =='menu' ? 'course_id"':''; ?>" required="">
                      <option value="">Select Course</option>
                       <?php $get_all="SELECT * FROM menu_course ORDER BY menu_course_id DESC";
            				  $run_all=query($get_all);
            				 
            				 while($row_all=fetch($run_all)){?>
            				    <option value="<?= $row_all['menu_course_id']; ?>" <?= $edit['course_id'] ==$row_all['menu_course_id'] ? 'selected':''; ?>><?= $row_all['menu_course_course_name']; ?></option>
            					
            				<?php } ?>
                    </select>
                  </div>
                 
                  <div class="form-group">
                    <label for="exampleInputEmail1">Offer</label>&nbsp;&nbsp;<span class="Erroffer Err"></span>
                    <input type="text" class="form-control" name="offer" value="<?= $edit['offer'];?>" required >
                  </div>
                  <div class="form-group">
                    <label for="exampleInputPassword1">Rating Value</label>&nbsp;&nbsp;<span class="Errrating_value Err"></span>
                    <input type="number" max="1000" class="form-control" name="rating_value" value="<?= $edit['rating_value'];?>" required>
                  </div>
				          
                  <div class="form-group">
                    <label for="exampleInputEmail1">Rating Point</label>&nbsp;&nbsp;<span class="Errrating_point Err"></span>
                    <input type="number" max="5" class="form-control" name="rating_point" value="<?= $edit['rating_point'];?>" required>
                  </div>
                 
                  <div class="form-group">
                    <label for="exampleInputPassword1">Description</label>&nbsp;&nbsp;<span class="Errcontents Err"></span>
					   <textarea rows="5" name="contents" class="form-control" id="mytextarea"  required><?= $edit['description'];?></textarea>
                  </div>
                 
                </div>
                <div class="card-footer">
                  <button type="submit"  class="btn btn-primary" style="background:#040202">Update</button>
                </div>
              </form>
            </div>
            <!-- /.card -->
          </div>
     <?php }elseif(isset($_GET['page']) && $_GET['page']=='view'){?>
             <div class="col-12">
                  <div class="card">
                    <div class="card-header">
                      <h3 class="card-title">View Course</h3>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body table-responsive table-wrapper-scroll-y my-custom-scrollbar">
                      <table id="example1" class="table table-bordered table-striped">
                      </table>
                       
                    </div>
                </div>
            </div>
             <?php }else{?>
             <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-primary">
              <div class="card-header" style="background:#040202;">
                <h3 class="card-title"><?= isset($_GET['page']) ? ucfirst($_GET['page']):'Add';?> Course</h3>
              </div>
              <form method="POST" action="php/function.php?action=add_course" enctype="multipart/form-data" novalidate="" id="form">
                <div class="card-body">
                  <div class="form-group">
                    <label for="exampleInputEmail1">Menu / Sub Menu </label>
                    <select class="form-control select_menu" name="type_menu"  required="">
                      <option value="menu">Menu</option>
                      <option value="submenu">Sub Menu</option>
                       
                    </select>
                  </div>
                  <div class="form-group submenuhide" style="display: none;">
                    <label for="exampleInputEmail1">Course Name</label>&nbsp;&nbsp;<span class="Errcourse Err"></span>
                    <select class="form-control sub_menu" name="course_id" required="">
                      <option value="">Select Course</option>
                       <?php $get_all="SELECT * FROM courses ORDER BY course_id DESC";
            				  $run_all=query($get_all);
            				 
            				 while($row_all=fetch($run_all)){
            				 if(get_content($row_all['course_id']) < 1){
            				 
            				 ?>
            				    <option value="<?= $row_all['course_id']; ?>"><?= $row_all['course_name']; ?></option>
            					
            				<?php } } ?>
                    </select>
                  </div>
                  <div class="form-group menuhide">
                    <label for="exampleInputEmail1">Course Name</label>&nbsp;&nbsp;<span class="Errcourse Err"></span>
                    <select class="form-control menu" name="course_id" required="">
                      <option value="">Select Course</option>
                       <?php $get_all="SELECT * FROM menu_course ORDER BY menu_course_id DESC";
            				  $run_all=query($get_all);
            				 
            				 while($row_all=fetch($run_all)){
            				 if(get_content($row_all['menu_course_id']) < 1){
            				 
            				 ?>
            				    <option value="<?= $row_all['menu_course_id']; ?>"><?= $row_all['menu_course_course_name']; ?></option>
            					
            				<?php } } ?>
                    </select>
                  </div>
                 
                  <div class="form-group">
                    <label for="exampleInputEmail1">Offer</label>&nbsp;&nbsp;<span class="Erroffer Err"></span>
                    <input type="text" class="form-control" name="offer" placeholder="Offer" required>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputPassword1">Rating Value</label>&nbsp;&nbsp;<span class="Errrating_value Err"></span>
                    <input type="number" max="1000" class="form-control" name="rating_value" placeholder="Rating Value" required>
                  </div>
				          
                  <div class="form-group">
                    <label for="exampleInputEmail1">Rating Point</label>&nbsp;&nbsp;<span class="Errrating_point Err"></span>
                    <input type="number" max="5" class="form-control" name="rating_point" placeholder="Rating Point" required>
                  </div>
                 
                  <div class="form-group">
                    <label for="exampleInputPassword1">Description</label>&nbsp;&nbsp;<span class="Errcontents Err"></span>
					   <textarea rows="5" name="contents" class="form-control" id="mytextarea" placeholder="" required></textarea>
                  </div>
                 
                </div>
                <div class="card-footer">
                  <button type="submit"  class="btn btn-primary" style="background:#040202">Submit</button>
                </div>
              </form>
            </div>
            <!-- /.card -->
          </div>
          <?php }?>
          <!--/.col (left) -->
        </div>
        <!-- /.row -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.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"); ?>
<?php include("includes/scripts.php"); ?>

<script src="https://cdn.tiny.cloud/1/504fazmsky7z6fs0vo2n3o3vss57qqti45243huu6yszba67/tinymce/5/tinymce.min.js" referrerpolicy="origin"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-sweetalert/1.0.1/sweetalert.css" integrity="sha512-f8gN/IhfI+0E9Fc/LKtjVq4ywfhYAVeMGKsECzDUHcFJ5teVwvKTqizm+5a84FINhfrgdvjX8hEJbem2io1iTA==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-sweetalert/1.0.1/sweetalert.min.js" integrity="sha512-MqEDqB7me8klOYxXXQlB4LaNf9V9S0+sG1i8LtPOYmHqICuEZ9ZLbyV3qIfADg2UJcLyCm4fawNiFvnYbcBJ1w==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>


  <script>
     $("#form").submit(function(event) {
          event.preventDefault();
          formdata = new FormData($(this)[0]);
          $('.Err').text('');
          $.ajax({
              url: $(this).attr('action'),
              contentType: false,
              processData: false,
              dataType: "json",
              data: formdata,
              type: 'POST',
              success: function(response)
               {
               
                  if(response.success == true){
                     swal("Success",response.message , "success");
                     $('#form')[0].reset();
                  }else if(response.success == false){
                    $.each(response.errors,function(key,value){
                      $('.Err'+key).css('color','red').text(value);
                    });
                  }
              },
  
          });
      });
      <?php if(isset($_GET['page'])=='view'){?>
        
             
             
     $(document).ready(function(){
             $.ajax({
                  url: "php/function.php?action=get_data",
                  dataType: "json",
                  type: 'GET',
                  success: function(response){
                       $('table').html(response.html);
                     
                  },
      
              });
            });
     <?php }?>
     
      $(document).on('change','.select_menu',function(){
          var value = $(this).val();
          if(value == 'submenu'){
              $('.submenuhide').show();
              $('.menuhide').find('.menu').removeAttr('name');
              $('.submenuhide').find('.sub_menu').attr('name','course_id');
              
              $('.menuhide').hide();
          }else if(value == 'menu'){
              $('.menuhide').show();
              $('.submenuhide').hide();
              $('.submenuhide').find('.sub_menu').removeAttr('name');
              $('.menuhide').find('.menu').attr('name','course_id');
          }
    });
    
     $(document).on('click','.del',function(){
            var elm = $(this);
            var row_id = elm.closest('tr').attr('row-id');
            if (confirm(" Are you sure You won't to Delete! ")) {
              $.ajax({
                    type:"GET",
                    url: "php/function.php?action=delete_course&id="+row_id,
                     dataType: "json",
                    success: function (response) {
                      if(response.success == true){
                        swal('Deleted!','Your file has been Deleted.', 'success');
                        elm.closest('tr').remove();
                       
                      }
                    }        
                });
            }
           
        });
 </script>
</body>
</html>