1#@!#!123s

: / home / epksuofuukz9 / www / admin /
Filename : edit_basic_course.php
back
<?php
  $the_id=$_GET['basic'];
?>
<?php include("includes/header.php"); ?>
<?php
        $get_all="SELECT * FROM courses WHERE course_id='$the_id'";
        $run_all=query($get_all);
        $row_all=fetch($run_all);
          $course_id =$row_all['course_id']; 
          $menu_id =$row_all['menu_id'];         
          $meta_title =$row_all['meta_title'];
          $slug_url =$row_all['slug_url'];
          $meta_keywords =$row_all['meta_keywords'];
          $meta_description =$row_all['meta_description'];
          $ratings=$row_all['ratings'];
          $course_name =$row_all['course_name'];
          $description =$row_all['description'];
          $cover_image =$row_all['cover_image'];
          $professor_name=$row_all['professor_name'];
          $professor_image=$row_all['professor_image'];
          $lectures=$row_all['lectures'];
          $duration=$row_all['duration'];
          $skill_level=$row_all['skill_level'];
          $language=$row_all['language'];
          $students=$row_all['students'];
          $assessments=$row_all['assessments'];
          $description_main=$row_all['description'];
          $status =$row_all['status'];
          $date=$row_all['date']; 
          $location=$row_all['sub_menu_location'];
          $script_tag=$row_all['script_tag'];
        ?>
<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>Course</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;">View Posts</a></li>
              <li class="breadcrumb-item active">Edit Course</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">Edit Course</h3>
              </div>
              <!-- /.card-header -->
              <!-- form start -->
              <form role="form" method="POST" action="" enctype="multipart/form-data" novalidate="">
                <div class="card-body">
                  <div class="form-group">
                    <label for="exampleInputEmail1">Status</label>
                    <select class="form-control" name="status" required="">
                      <option value="">Select Status</option>
                      <option value="1" <?php echo $status=='1'?'selected':''; ?>>Show</option>
                      <option value="0" <?php echo $status=='0'?'selected':''; ?>>Hide</option>
                    </select>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Meta Title</label>
                    <input type="text" class="form-control" name="meta_title" id="exampleInputEmail1" placeholder="Meta Title" value="<?php echo $meta_title;?>" required>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Slug URL</label>
                    <input type="text" class="form-control" name="slug_url" id="exampleInputEmail1" placeholder="Slug URL" required value="<?php echo $slug_url;?>">
                  </div>
                  <div class="form-group">
                    <label for="exampleInputPassword1">Meta Keywords</label>
                    <input type="text" class="form-control" name="meta_keywords" id="exampleInputPassword1" placeholder="Meta Keywords" value="<?php echo $meta_keywords;?>" required>
                  </div>
          <div class="form-group">
                    <label for="exampleInputPassword1">Meta Description</label>
                    <textarea class="form-control" name="meta_description" id="exampleInputPassword1" placeholder="Meta Description" required><?php echo $meta_description;?></textarea>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">New Course</label>
                    <input type="name" class="form-control" name="new_course" id="exampleInputEmail1" placeholder="New Course" value="<?php echo $course_name;?>" required>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Menu Name</label>
                    <select class="form-control" name="menu_name" required="">
                      <option value="">Select Menu Name</option>
                      <?php
                        $get_menu="SELECT * FROM menu_course";
                        $run_menu=query($get_menu);
                        while($row_menu=fetch($run_menu))
                        {
                          $menu_course_id=$row_menu['menu_course_id'];
                          $menu_course_course_name=$row_menu['menu_course_course_name'];
                       ?>
                      <option value="<?php echo $menu_course_id;?>" <?php echo $menu_course_id==$menu_id?'selected':''; ?>><?php echo $menu_course_course_name; ?></option>
                    <?php } ?>
                    </select>
                  </div>

                  <div class="form-group">
                    <label for="exampleInputFile">Cover Image</label>
                    <div class="input-group">
                      <div class="custom-file">
                        <input type="file" class="custom-file-input" name="cover_image" id="exampleInputFile">
                        <input type="hidden" name="cover_image_hidden" value="<?php echo $cover_image; ?>">
                        <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                      </div>
                    </div>
                    <img src="images/cover_image/<?php echo $cover_image; ?>" height="250px" width="400px">
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Professor Name</label>
                    <input type="name" class="form-control" name="professor_name" id="exampleInputEmail1" placeholder="New Course" value="<?php echo $professor_name;?>" required>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Professor Image</label>
                    <div class="input-group">
                      <div class="custom-file">
                        <input type="file" class="custom-file-input" name="professor_image" id="exampleInputFile">
                        <input type="hidden" name="professor_image_hidden" value="<?php echo $professor_image; ?>">
                        <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                      </div>
                    </div>
                    <img src="images/professor/<?php echo $professor_image; ?>" height="250px" width="400px">
                  </div>
                  <div class="form-group">
                    <label for="exampleInput">Ratings</label>
                    <input type="number" class="form-control" name="rating" placeholder="Ratings" value="<?php echo $ratings; ?>" required min="0" max="5">
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Location</label>
                    <select class="form-control" name="location" required="">
                      <option value="">Select Location</option>
                      <option value="1" <?php echo $location=='1'?'selected':''; ?>>Noida</option>
                      <option value="2" <?php echo $location=='2'?'selected':''; ?>>Delhi</option>
                      <option value="3" <?php echo $location=='3'?'selected':''; ?>>Gurgaon</option>
                      <option value="4" <?php echo $location=='4'?'selected':''; ?>>India</option>
                    </select>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputPassword1">Description</label>
                    <textarea rows="5" name="course_desc" class="form-control" id="mytextarea" placeholder="Content" required><?php echo $description;?></textarea>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputPassword1">Script tag</label>
                    <textarea rows="5" name="script_tag" class="form-control"  placeholder="Script tag" required><?php echo $script_tag;?></textarea>
                  </div>
                </div>
                <hr>
                  <div class="card-header" style="background:#040202;">
                    <h3 class="card-title" style="color: #fff;">Courses Features</h3>
                  <br>
                  </div>
                  <div class="card-body">
                  <div class="form-group">
                    <label for="exampleInputEmail1">Lectures</label>
                    <input type="number" class="form-control" name="lectures" id="exampleInputEmail1" placeholder="Lectures" required value="<?php echo $lectures;?>">
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Duration</label>
                    <input type="number" class="form-control" name="duration" id="exampleInputEmail1" placeholder="Duration" required value="<?php echo $duration;?>">
                  </div>
                  <div class="form-group">
                    <label for="exampleInputPassword1">Skill Level</label>
                    <input type="name" class="form-control" name="skill_level" id="exampleInputPassword1" placeholder="Skill Level" value="<?php echo $skill_level;?>" required>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Language</label>
                    <input type="name" class="form-control" name="language" id="exampleInputEmail1" placeholder="Language" required value="<?php echo $language;?>">
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Students</label>
                    <input type="number" class="form-control" name="students" id="exampleInputEmail1" placeholder="Students" value="<?php echo $students;?>" required>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputPassword1">Assessments</label>
                    <input type="name" class="form-control" name="assessments" id="exampleInputPassword1" value="<?php echo $assessments;?>" placeholder="Assessments" required>
                  </div>
                <!-- /.card-body -->
                <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"); ?>
<script src="https://cdn.tiny.cloud/1/504fazmsky7z6fs0vo2n3o3vss57qqti45243huu6yszba67/tinymce/5/tinymce.min.js" referrerpolicy="origin"></script>
  <script>
  tinymce.init({
    selector: '#mytextarea',
    plugins: [
    'advlist autolink lists link image charmap print preview anchor textcolor',
    'searchreplace visualblocks code fullscreen',
    'insertdatetime media table contextmenu paste code help wordcount'
  ],
  mobile: { 
    theme: 'mobile' 
  },
  toolbar: 'insert | undo redo |  formatselect | bold italic backcolor  | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | removeformat | help',
  content_css: [
    '//fonts.googleapis.com/css?family=Lato:300,300i,400,400i',
    '//www.tiny.cloud/css/codepen.min.css'
  ],
  });
  </script>
</body>
</html>
<?php
if(isset($_POST['submit']))
{
  $the_id=$_GET['basic'];
 $status=$_POST['status'];
 $meta_title=escape($_POST['meta_title']);
 $slug_url=$_POST['slug_url'];
 $meta_keywords=escape($_POST['meta_keywords']);
 $meta_description=escape($_POST['meta_description']);
 $course_name=escape($_POST['new_course']);
 $course_desc=escape($_POST['course_desc']);
 $present_date=date('Y-m-d');
 $menu_name=$_POST['menu_name'];
 $rating=$_POST['rating'];
 $locations=$_POST['location'];
 $post_script_tag=$_POST['script_tag'];
 
 $cover_image= $_FILES['cover_image']['name'];
 $cover_image_temp= $_FILES['cover_image']['tmp_name'];
 move_uploaded_file($cover_image_temp, "images/cover_image/$cover_image");

 if(empty($cover_image))
 {
  $cover_image=$_POST['cover_image_hidden'];
 }

 $professor_name=escape($_POST['professor_name']);
 $professor_image= $_FILES['professor_image']['name'];
 $professor_image_temp= $_FILES['professor_image']['tmp_name'];
 move_uploaded_file($professor_image_temp, "images/professor/$professor_image");

 if(empty($professor_image))
 {
  $professor_image=$_POST['professor_image_hidden'];
 }

 $lectures=$_POST['lectures'];
 $duration=$_POST['duration'];
 $skill_level=$_POST['skill_level'];
 $language=$_POST['language'];
 $students=$_POST['students'];
 $assessments=$_POST['assessments'];


 $update_post="UPDATE `courses` SET `menu_id`='$menu_name',`meta_title`='$meta_title',`slug_url`='$slug_url',`meta_description`='$meta_description',`meta_keywords`='$meta_keywords',`course_name`='$course_name',`cover_image`='$cover_image',`professor_name`='$professor_name',`professor_image`='$professor_image',`ratings`='$rating',`lectures`='$lectures',`duration`='$duration',`skill_level`='$skill_level',`language`='$language', `students`='$students', `assessments`='$assessments', `description`='$course_desc',status='$status' ,`sub_menu_location`='$locations',`script_tag`='$post_script_tag' WHERE `course_id`='$the_id'";

 $run_insert_post=query($update_post);
 confirm($run_insert_post);
 if($run_insert_post)
 {
  echo "<script>alert('Course has been Updated');</script>";
   echo "<script>window.open('edit_posts.php?edit=$the_id','_self');</script>";
 }

}

?>