1#@!#!123s

: / home / epksuofuukz9 / www / admin /
Filename : add_section.php
back
<?php $the_id=$_GET['add']; ?>
<?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>Section</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#" style="color:#111;">Dashboard</a></li>
              <li class="breadcrumb-item"><a href="view_posts.php" style="color:#111;">Course</a></li>
              <li class="breadcrumb-item active">Add 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-12">
            <!-- general form elements -->
            <div class="card card-primary">
              <div class="card-header" style="background:#040202;">
                <h3 class="card-title">Add Section</h3>
              </div>
              <!-- /.card-header -->
              <!-- form start -->
              <form role="form" method="POST" action="" enctype="multipart/form-data">
                <div class="card-body">
                  <div class="form-group">
                    <label for="exampleInputEmail1">Section Name</label>
                    <select class="form-control" name="section_name" id="exampleInputEmail1" required>
                      <option value="">Select Section Name</option>
                      <?php
                      $get_d_section="SELECT DISTINCT(section_name) FROM section WHERE `course_id`='$the_id'";
                      $run_d_section=query($get_d_section);
                      while($row_d_section=fetch($run_d_section))
                        {
                            $section_name=$row_d_section['section_name'];
                      ?>
                      <option value="<?php echo $section_name; ?>"><?php echo $section_name; ?></option>
                      <?php
                    }
                      ?>
                    </select>
                  </div>
                </div>
                <!-- /.card-body -->
              <div class="form-group">
                    <label for="exampleInputEmail1">Lesson Name</label>
                    <input type="text" name="lessonname" required class="form-control" placeholder="Enter Lesson Name Here">                   
                  </div>
                <div class="form-group">
                    <label for="exampleInputEmail1">Description </label>
                    <textarea class="form-control" name="description" id="exampleInputEmail1" placeholder="Enter Description Here" required></textarea>
                  </div>
              <div class="card-footer">
                  <button type="submit" name="submit" class="btn btn-primary" style="background:#040202">Submit</button>
                </div>
              </form>
            </div>
            <!-- /.card -->
          </div>
          <!--/.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"); ?>
</body>
</html>

<?php

if(isset($_POST['submit']))
{
  $the_id=$_GET['add'];
  $section_name=$_POST['section_name'];
  $lessonname=$_POST['lessonname'];
  $description=$_POST['description'];

 $insert="INSERT INTO `section`(`course_id`, `section_name`, `section_lesson`, `section_description`) VALUES ('$the_id','$section_name','$lessonname','$description')";
 $run=query($insert);
  if($insert)
  {
    echo "<script>alert('Section has been Added');</script>";
    echo "<script>window.open('add_section.php?add=$the_id','_self');</script>";
  }
}


?>