1#@!#!123s

: / home / epksuofuukz9 / www / admin /
Filename : edit_post.php
back
<?php include("includes/header.php"); ?>
<?php
        $the_id=$_GET['edit'];
        $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'];          
          $meta_title =$row_all['meta_title'];
          $slug_url =$row_all['slug_url'];
          $meta_keywords =$row_all['meta_keywords'];
          $meta_description =$row_all['meta_description'];
          $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']; 
        ?>
<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="php/edit_post.php?edit=<?php echo $the_id; ?>" enctype="multipart/form-data">
                <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="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="exampleInputPassword1">Description</label>
          <textarea rows="5" name="course_desc" class="form-control" id="exampleInputPassword1" placeholder="Content" required><?php echo $description;?></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>
                <hr>
                  <div class="card-header" style="background:#040202;">
                    <h3 class="card-title" style="color: #fff;">Placement Students</h3>
                  <br>
                  </div>
                <!-- /.card-body -->

              <?php 
                $i=0;
                $get_course_placement="SELECT * FROM course_placement WHERE course_id='$the_id'";
                $run_course_placement=query($get_course_placement);
                while($row_course_placement=fetch($run_course_placement))
                  {
                    $cp_name=$row_course_placement['cp_name'];
                    $cp_profession=$row_course_placement['cp_profession'];
                    $cp_image=$row_course_placement['cp_image'];
                    $i++;
                    if($i=='1')
                    {
              ?>


              <div class="field_wrapper">
                <label for="exampleInputEmail1">Name </label>
                <div class="input-group control-group after-add-more">
                    <input type="text" name="addmore[]" required value="<?php echo $cp_name;?>" class="form-control" placeholder="Enter Name Here">
                    <div class="input-group-btn"> 
                      <button class="btn btn-success add-more" type="button"><i class="glyphicon glyphicon-plus"></i> Add</button>
                    </div>
                </div>
                <div class="form-group">
                    <label for="exampleInputEmail1">Placed Company</label>
                    <input type="name" class="form-control" name="placement_profession[]" id="exampleInputEmail1" value="<?php echo $cp_profession;?>" placeholder="Enter Profession Here" required>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputFile">Placement Student Image</label>
                    <div class="input-group">
                      <div class="custom-file">
                        <input type="file" class="custom-file-input" name="placement_image[]" value="<?php echo $cp_image; ?>" id="exampleInputFile" required>
                        <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                      </div>
                    </div>
                    <img src="images/placement/<?php echo $cp_image; ?>" height="250px" width="400px">
                  </div>
              </div>
              <?php
            }
            else
            {
              ?>
              <div class="field_wrapper"><hr><label for="exampleInputEmail1">Name</label><div class="input-group control-group after-add-more"><input type="text" name="addmore[]" class="form-control" placeholder="Enter Name Here" value="<?php echo $cp_name;?>" required></div><div class="form-group"><label for="exampleInputEmail1">Placed Company</label><input type="name" class="form-control" name="placement_profession[]" value="<?php echo $cp_profession;?>" id="exampleInputEmail1" placeholder="Enter Profession Here" required></div><div class="form-group"><label for="exampleInputFile">Placement Student Image</label><div class="input-group"><div class="custom-file"><input type="file" class="custom-file-input" name="placement_image[]" value="<?php echo $cp_image; ?>" id="exampleInputFile" required><label class="custom-file-label" for="exampleInputFile">Choose file</label></div></div><img src="images/placement/<?php echo $cp_image; ?>" height="250px" width="400px"></div><button class="btn btn-danger remove_button" type="button"><i class="glyphicon glyphicon-plus"></i> Remove</button></div>
              <?php
            }
          }
            ?>

              <hr>
                  <div class="card-header" style="background:#040202;">
                    <h3 class="card-title" style="color: #fff;">Review</h3>
                  <br>
                  </div>
                  <?php 
                    $j=0;
                    $get_course_review="SELECT * FROM course_review WHERE course_id='$the_id'";
                    $run_course_review=query($get_course_review);
                    while($row_course_review=fetch($run_course_review))
                      {
                        $cr_name=$row_course_review['cr_name'];
                        $cr_company_name=$row_course_review['cr_company_name'];
                        $cr_review=$row_course_review['cr_review'];
                        $cr_image=$row_course_review['cr_image'];
                        $j++;
                        if($j=='1')
                        {
                  ?>
              <div class="field_wrapper1">
                <label for="exampleInputEmail1">Person Name </label>
                  <div class="input-group control-group after-add-more">
                      <input type="text" name="addmore1[]" class="form-control" value="<?php echo $cr_name; ?>" required placeholder="Enter Person Name Here">
                      <div class="input-group-btn"> 
                        <button class="btn btn-success add-more1" type="button"><i class="glyphicon glyphicon-plus"></i> Add</button>
                      </div>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Comapny Name</label>
                    <input type="name" class="form-control" name="company_name[]" id="exampleInputEmail1" placeholder="Enter Company Name Here" value="<?php echo $cr_company_name; ?>" required>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputEmail1">Review</label>
                    <textarea class="form-control" name="company_review[]" id="exampleInputEmail1" placeholder="Enter Review Here" required><?php echo $cr_review; ?></textarea>
                  </div>
                  <div class="form-group">
                    <label for="exampleInputFile">Review Image</label>
                    <div class="input-group">
                      <div class="custom-file">
                        <input type="file" class="custom-file-input" name="review_image[]" value="<?php echo $cr_image; ?>" id="exampleInputFile" required>
                        <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                      </div>
                    </div>
                    <img src="images/review/<?php echo $cr_image; ?>" height="250px" width="400px">
                  </div>
              </div>
              <?php
            }
            else
            {
              ?>
              <div class="field_wrapper1"><label for="exampleInputEmail1">Person Name</label><div class="input-group control-group after-add-more"><input type="text" value="<?php echo $cr_name; ?>" name="addmore1[]" class="form-control" placeholder="Enter Person Name Here" required></div><div class="form-group"><label for="exampleInputEmail1">Company Name</label><input type="name" class="form-control" value="<?php echo $cr_company_name; ?>" name="company_name[]" id="exampleInputEmail1" placeholder="Enter Company Name Here" required></div><div class="form-group"><label for="exampleInputEmail1">Review </label><textarea class="form-control" name="company_review[]" id="exampleInputEmail1" placeholder="Enter Review Here" required><?php echo $cr_review; ?></textarea></div><div class="form-group"><label for="exampleInputFile">Review Image</label><div class="input-group"><div class="custom-file"><input type="file" class="custom-file-input" name="review_image[]" value="<?php echo $cr_image; ?>" required id="exampleInputFile" ><label class="custom-file-label" for="exampleInputFile">Choose file</label></div></div><img src="images/review/<?php echo $cr_image; ?>" height="250px" width="400px"></div><button class="btn btn-danger remove_button1" type="button"><i class="glyphicon glyphicon-plus"></i> Remove</button></div>

              <?php
            }
          }
              ?>
                <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 type="text/javascript">
$(document).ready(function(){
    var maxField = 1000; //Input fields increment limitation
    var addButton = $('.add-more'); //Add button selector
    var wrapper = $('.field_wrapper'); //Input field wrapper
    var fieldHTML = '<div><hr><label for="exampleInputEmail1">Name</label><div class="input-group control-group after-add-more"><input type="text" name="addmore[]" class="form-control" placeholder="Enter Name Here" required></div><div class="form-group"><label for="exampleInputEmail1">Placed Company</label><input type="name" class="form-control" name="placement_profession[]" id="exampleInputEmail1" placeholder="Enter Profession Here" required></div><div class="form-group"><label for="exampleInputFile">Placement Student Image</label><div class="input-group"><div class="custom-file"><input type="file" class="custom-file-input" name="placement_image[]" id="exampleInputFile" required><label class="custom-file-label" for="exampleInputFile">Choose file</label></div></div></div><button class="btn btn-danger remove_button" type="button"><i class="glyphicon glyphicon-plus"></i> Remove</button></div>'; //New input field html 
    var x = 1; //Initial field counter is 1
    
    //Once add button is clicked
    $(addButton).click(function(){
        //Check maximum number of input fields
        if(x < maxField){ 
            x++; //Increment field counter
            $(wrapper).append(fieldHTML); //Add field html
        }
    });
    
    //Once remove button is clicked
    $(wrapper).on('click', '.remove_button', function(e){
        e.preventDefault();
        $(this).parent('div').remove(); //Remove field html
        x--; //Decrement field counter
    });
});
</script>

<script type="text/javascript">
$(document).ready(function(){
    var maxField = 1000; //Input fields increment limitation
    var addButton = $('.add-more1'); //Add button selector
    var wrapper = $('.field_wrapper1'); //Input field wrapper
    var fieldHTML = '<div><hr><label for="exampleInputEmail1">Person Name</label><div class="input-group control-group after-add-more"><input type="text" name="addmore1[]" class="form-control" placeholder="Enter Person Name Here" required></div><div class="form-group"><label for="exampleInputEmail1">Company Name</label><input type="name" class="form-control" name="company_name[]" id="exampleInputEmail1" placeholder="Enter Company Name Here" required></div><div class="form-group"><label for="exampleInputEmail1">Review </label><textarea class="form-control" name="company_review[]" id="exampleInputEmail1" placeholder="Enter Review Here" required></textarea></div><div class="form-group"><label for="exampleInputFile">Review Image</label><div class="input-group"><div class="custom-file"><input type="file" class="custom-file-input" name="review_image[]" id="exampleInputFile" required><label class="custom-file-label" for="exampleInputFile">Choose file</label></div></div></div><button class="btn btn-danger remove_button1" type="button"><i class="glyphicon glyphicon-plus"></i> Remove</button></div>'; //New input field html 
    var x = 1; //Initial field counter is 1
    
    //Once add button is clicked
    $(addButton).click(function(){
        //Check maximum number of input fields
        if(x < maxField){ 
            x++; //Increment field counter
            $(wrapper).append(fieldHTML); //Add field html
        }
    });  
    //Once remove button is clicked
    $(wrapper).on('click', '.remove_button1', function(e){
        e.preventDefault();
        $(this).parent('div').remove(); //Remove field html
        x--; //Decrement field counter
    });
});
</script>

<script>
      CKEDITOR.replace( 'course_desc' );
</script>
</body>
</html>