<?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>Year Of passing</label>
                          <input type="text" class="form-control" name="passing_year" value="<?php echo $row_alumini['passing_year']; ?>" required />
                        </div>
                      </div>
                      <div class="col-md-4">
                        <div class="form-group">
                          <label>Mobile</label>
                          <input type="text" class="form-control" name="mobile_number" value="<?php echo $row_alumini['mobile_number']; ?>" required />
                        </div>
                      </div>
                    </div>
                    <div class="row">
                      <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']; ?>" required />
                        </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-12">
                        <div class="form-group">
                          <label>Other Info</label>
                          <textarea class="text_editor" name="other_info">
                            <?php echo $row_alumini['otherinfo']; ?>
                          </textarea>
                        </div>
                      </div>
                    </div>
                    <div class="row">
                      <div class="col-md-8">
                        <div class="form-group">
                          <label for="exampleInputFile">Photos</label>
                          <div class="input-group">
                            <div class="custom-file">
                              <input type="file" class="custom-file-input fileUpload_allow" name="alumini_file" id="exampleInputFile">
                              <label class="custom-file-label" for="exampleInputFile">Choose file</label>
                            </div>
                          </div>
                        </div>
                      </div>
                      <div class="col-md-4">
                        <img src="<?php echo $row_alumini['photo']; ?>" style="width:150px;" />
                      </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'];
  $passing_year = $_POST['passing_year'];
  $mobile_number = $_POST['mobile_number'];
  $email = $_POST['email'];
  $address = $_POST['address'];
  $other_info = $_POST['other_info'];

  if($_FILES["alumini_file"]["name"]!="")
  {
    $fileinfo=PATHINFO($_FILES["alumini_file"]["name"]);
    $newFilename="alumini_". time()."." .$fileinfo['extension'];

    $location="uploads/alumini/" . $newFilename;
    $upd = mysqli_query($con,"UPDATE `alumini`  SET name='$name', passing_year='$passing_year',  mobile_number='$mobile_number', email='$email', address='$address', otherinfo='$other_info', photo='$location' WHERE id=$id");

    if($upd)
    {
      move_uploaded_file($_FILES["alumini_file"]["tmp_name"],$location);
      $_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>";
    }
  }
  else
  {
    $upd = mysqli_query($con,"UPDATE `alumini`  SET name='$name', passing_year='$passing_year',  mobile_number='$mobile_number', email='$email', address='$address', otherinfo='$other_info' 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>";
    }
  }
}
?>