<?php  
$id=0;
if(isset($_GET['id']))
{
  $page_title = 'Edit Achievers';
  include 'header.php';
  $id = $_GET['id'];
  $sel=mysqli_query($con,"select * from achievers where id=$id");
  while($row_achievers=mysqli_fetch_array($sel))
  {
    ?>
    <div class="content-wrapper">
      <section class="content mt-4">
        <div class="container-fluid">
          <div class="row">
            <div class="col-md-12">
              <?php include('alert-msg.php'); ?>
              <div class="card card-primary">
                <div class="card-header">
                  <h3 class="card-title"><?php echo $page_title; ?></h3>
                </div>
                <form action="" method="POST" enctype="multipart/form-data">
                  <div class="card-body">
                    <div class="row">
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Name</label>
                          <input type="text" class="form-control" name="name" value="<?php echo $row_achievers['name']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Event</label>
                          <input type="text" class="form-control" name="event" value="<?php echo $row_achievers['event']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Year</label>
                          <input type="text" class="form-control" name="year" value="<?php echo $row_achievers['year']; ?>" required />
                        </div>
                      </div>
                    </div>
                    <div class="row">
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Place</label>
                          <input type="text" class="form-control" name="place" value="<?php echo $row_achievers['place']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Section</label>
                          <select name="section" class="form-control" required>
                            <option <?php echo $row_achievers['section']=='Achievers' ? 'selected' : ''; ?>>Achievers</option>
                            <option <?php echo $row_achievers['section']=='Sports' ? 'selected' : ''; ?>>Sports</option>
                          </select>
                        </div>
                      </div>
                      <div class="col-md-12">
                          <div class="row">
                              <div class="col-md-8">
                                  <div class="form-group">
                                      <label for="exampleInputFile">File</label>
                                      <div class="input-group">
                                        <div class="custom-file">
                                          <input type="file" class="custom-file-input fileUpload_allow" name="profile_photo" id="exampleInputFile">
                                          <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                                        </div>
                                      </div>
                                    </div>
                              </div>
                              <div class="col-md-4">
                                  <?php if($row_achievers['file'] != '') { ?>
                                  <div class="form-group">
                                      <label style="width:100%;">&nbsp;</label>
                                      <a href="<?php echo $row_achievers['file']; ?>" target="_blank"><i class="fas fa-file-pdf fa-3x"></i></a>
                                  </div>
                                  <?php } ?>
                              </div>
                          </div>
                      </div>
                      <div class="col-md-12">
                        <div class="form-group">
                          <label>Remarks</label>
                          <textarea class="text_editor" name="remarks">
                            <?php echo $row_achievers['remarks']; ?>
                          </textarea>
                        </div>
                      </div>
                    </div>
                    <button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
                  </div>
                </form>
              </div>
            </div>
          </div>
        </div>
      </section>
    </div>
    <?php
  }
  ?>
  <?php include 'footer.php'; ?>
  <?php
}
else
{
  session_start();
  $_SESSION['error_msg'] = 'Something wrong...';
  echo"<script>window.location='achievers-list.php';</script>";
}
?>


<?php
if(isset($_POST['btnSubmit']))
{
  $name = $_POST['name'];
  $event = $_POST['event'];
  $year = $_POST['year'];
  $place = $_POST['place'];
  $section = $_POST['section'];
  $remarks = mysqli_real_escape_string($con,$_POST['remarks']);
  
  $location = '';
	$upload = 0;
	if(isset($_FILES["profile_photo"]["name"]) && $_FILES["profile_photo"]["name"] !=  '') {
    	$fileinfo=PATHINFO($_FILES["profile_photo"]["name"]);
        $newFilename="achievers_". time()."." .$fileinfo['extension'];
        $location="uploads/achievers/" . $newFilename;
        $upload = 1;
	}

  
  $upd = mysqli_query($con,"UPDATE `achievers`  SET name='$name', event='$event',  year='$year', place='$place', remarks='$remarks', section='$section' WHERE id=$id");
  if($upd)
  {
      if($upload == 1) {
          mysqli_query($con,"UPDATE `achievers`  SET file='$location' WHERE id=$id");
          move_uploaded_file($_FILES["profile_photo"]["tmp_name"],$location);
      }
    $_SESSION['success_msg'] = 'Achievers has been updated...';
    echo"<script>window.location='achievers-list.php';</script>";
  }
  else
  {
    $_SESSION['error_msg'] = 'Unable to update Achievers...';
    echo"<script>window.location='achievers-list.php';</script>";
  }
}
?>