<?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="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 = $_POST['remarks'];

  
  $upd = mysqli_query($con,"UPDATE `achievers`  SET name='$name', event='$event',  year='$year', place='$place', remarks='$remarks', section='$section' WHERE id=$id");
  if($upd)
  {
    $_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>";
  }
}
?>