1#@!#!123s

: / home / epksuofuukz9 / www / admin /
Filename : edit_career.php
back
<?php
  $the_id=$_GET['edit'];
?>
<?php include("includes/header.php"); ?>
<?php
        $get_all="SELECT * FROM careers WHERE career_id='$the_id'";
        $run_all=query($get_all);
        $row_all=fetch($run_all);
          $career_title =$row_all['career_title'];
          $career_image =$row_all['career_image'];
          $career_desc =$row_all['career_desc'];
          $career_experience =$row_all['career_experience'];
          $career_designation =$row_all['career_designation'];
          $career_status =$row_all['career_status'];
        ?>
<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>Career</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_careers.php" style="color:#111;">View Careers</a></li>
              <li class="breadcrumb-item active">Edit Career</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 Career</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 $career_status=='1'?'selected':''; ?>>Show</option>
                      <option value="0" <?php echo $career_status=='0'?'selected':''; ?>>Hide</option>
                    </select>
                  </div>
                  
                  <div class="form-group">
                    <label for="exampleInputEmail1">Title</label>
                    <input type="name" class="form-control" name="title" placeholder="Title" required value="<?php echo $career_title; ?>">
                  </div>
                  <div class="form-group">
                      <label for="exampleInputPassword1">Description</label>
                      <textarea class="form-control" name="description" placeholder="Description" required><?php echo $career_desc; ?></textarea>
                  </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" required>
                        <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                      </div>
                    </div>
                    <img src="images/career/<?php echo $career_image; ?>" height="250px" width="400px">
                  </div>
                  <div class="row">
                    <div class="col-sm-6">
                      <!-- text input -->
                      <div class="form-group">
                        <label>Experience</label>
                        <input type="number" class="form-control" name="experience" placeholder="Enter Experience" value="<?php echo $career_experience; ?>">
                      </div>
                    </div>
                    <div class="col-sm-6">
                      <div class="form-group">
                        <label>Designation</label>
                        <input type="text" class="form-control" name="designation" placeholder="Enter Designation" value="<?php echo $career_designation; ?>">
                      </div>
                    </div>
                  </div>
                </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"); ?>
</body>
</html>
<?php
if(isset($_POST['submit']))
{
  
 $the_id=$_GET['edit'];
 $title=escape($_POST['title']);
 $description=escape($_POST['description']);
 $experience=escape($_POST['experience']);
 $designation=escape($_POST['designation']);
 $status=escape($_POST['status']);
 
 $cover_image= $_FILES['cover_image']['name'];

 if(empty($cover_image))
 {
  $cover_image=$career_image;
 }
 else
 {
 $cover_image= date('dmYHis').str_replace(" ", "", basename($_FILES['cover_image']['name']));
 $cover_image_temp= $_FILES['cover_image']['tmp_name'];
 move_uploaded_file($cover_image_temp, "images/career/$cover_image");
 }

 $update="UPDATE `careers` SET `career_image`='$cover_image',`career_title`='$title',`career_desc`='$description',`career_experience`='$experience',`career_designation`='$designation',`career_status`='$status' WHERE `career_id`='$the_id'";
 $run=query($update);
 confirm($run);
 if($run)
 {
   echo "<script>alert('Career has been Updated');</script>";
   echo "<script>window.open('view_careers.php','_self');</script>";
 }

}

?>