<?php  
$id=0;
if(isset($_GET['id']))
{
  $page_title = 'Edit Alumini';
  include 'header.php';
  $id = $_GET['id'];
  $sel=mysqli_query($con,"select * from alumini where id=$id");
  while($row_alumini=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_alumini['name']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Admitted Year</label>
                          <input type="text" class="form-control" name="admitted_year" value="<?php echo $row_alumini['admitted_year']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Year Of passing</label>
                          <input type="text" class="form-control" name="passing_year" value="<?php echo $row_alumini['passing_year']; ?>" required />
                        </div>
                      </div>
                    </div>
                    <div class="row">
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Roll Number</label>
                          <input type="text" class="form-control" name="roll_number" value="<?php echo $row_alumini['roll_number']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>College</label>
                          <select class="form-control" name="college_id" required>
                              <option value="">Select College</option>
                              <?php
                                $sel_clg = mysqli_query($con, 'select * from college where is_active=1');
                                while($row_clg = mysqli_fetch_array($sel_clg)) {
                              ?>
                                <option value="<?php echo $row_clg['id']; ?>" <?php if($row_alumini['college_id'] == $row_clg['id']) { echo"selected"; } ?> ><?php echo $row_clg['name']; ?></option>
                              <?php
                                }
                              ?>
                          </select>
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Course</label>
                          <input type="text" class="form-control" name="course" value="<?php echo $row_alumini['course']; ?>" />
                        </div>
                      </div>
                    </div>
                    <div class="row">
                    <div class="col-md-4">
                        <div class="form-group">
                          <label>Mobile Number</label>
                          <input type="text" class="form-control" name="mobile_number" value="<?php echo $row_alumini['mobile_number']; ?>" />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Email</label>
                          <input type="email" class="form-control" name="email" value="<?php echo $row_alumini['email']; ?>" />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Address</label>
                          <textarea class="form-control" name="address"><?php echo $row_alumini['address']; ?></textarea>
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Current Occupation</label>
                          <textarea class="form-control" name="current_occupation"><?php echo $row_alumini['current_occupation']; ?></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='alumini-list.php';</script>";
}
?>


<?php
if(isset($_POST['btnSubmit']))
{
  $name = $_POST['name'];
  $admitted_year = $_POST['admitted_year'];
  $passing_year = $_POST['passing_year'];
  $roll_number = $_POST['roll_number'];
  $college_id = $_POST['college_id'];
  $course = $_POST['course'];
  $mobile_number = $_POST['mobile_number'];
  $email = $_POST['email'];
  $address = $_POST['address'];
  $current_occupation = $_POST['current_occupation'];
  
    $upd = mysqli_query($con,"UPDATE `alumini`  SET name='$name', admitted_year='$admitted_year', passing_year='$passing_year', roll_number='$roll_number', college_id='$college_id', course='$course',  mobile_number='$mobile_number', email='$email', address='$address', current_occupation='$current_occupation' WHERE id=$id");
    if($upd)
    {
      $_SESSION['success_msg'] = 'Alumini has been updated...';
      echo"<script>window.location='alumini-list.php';</script>";
    }
    else
    {
      $_SESSION['error_msg'] = 'Unable to update Alumini...';
      echo"<script>window.location='alumini-list.php';</script>";
    }
}
?>