<?php  
$page_title = 'Alumini List';
include 'header.php';
?>
<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>
            <!-- /.card-header -->
            <div class="card-body">
              <table class="table table-bordered table-striped main_datatables">
                <thead>
                  <tr>
                    <th>Sr. No.</th>
                    <th style="min-width: 100px;">Action</th>
                    <th>Name</th>
                    <th>Admitted Year</th>
                    <th>Passing Year</th>
                    <th>Roll Number</th>
                    <th>College</th>
                    <th>Course</th>
                    <th>Mobile Number</th>
                    <th>Email</th>
                    <th>Address</th>
                    <th>Current Occupation</th>
                  </tr>
                </thead>
                <tbody>
                  <?php
                  $sel_alumini=mysqli_query($con,'select a.*, clg.name as college_name from alumini as a inner join college as clg on clg.id = a.college_id  order by a.id desc');
                  $i=1;
                  while($row_alumini=mysqli_fetch_array($sel_alumini))
                  {

                    ?>
                    <tr>
                      <td><?php echo $i; ?></td>
                      <td>
                        <a href="alumini-edit.php?id=<?php echo $row_alumini['id']; ?>" class="btn btn-sm btn-primary"><i class="fas fa-edit"></i></a>
                        <a href="alumini-delete.php?id=<?php echo $row_alumini['id']; ?>" onclick="return confirm('Are you sure you want to delete ?');" class="btn btn-sm btn-danger"><i class="fas fa-trash"></i></a>
                      </td>
                      <td><?php echo $row_alumini['name']; ?></td>
                      <td><?php echo $row_alumini['admitted_year']; ?></td>
                      <td><?php echo $row_alumini['passing_year']; ?></td>
                      <td><?php echo $row_alumini['roll_number']; ?></td>
                      <td><?php echo $row_alumini['college_name']; ?></td>
                      <td><?php echo $row_alumini['course']; ?></td>
                      <td><?php echo $row_alumini['mobile_number']; ?></td>
                      <td><?php echo $row_alumini['email']; ?></td>
                      <td><?php echo $row_alumini['address']; ?></td>
                      <td><?php echo $row_alumini['current_occupation']; ?></td>
                    </tr>
                    <?php
                    $i=$i+1;
                  }
                  ?>
                </tbody>
              </table>
            </div>
            <!-- /.card-body -->
          </div>
        </div>
      </div>
    </div>
  </section>
</div>
<?php include 'footer.php'; ?>