<?php
require('db.php');
include "x.php";
?>
<!doctype html>
<html lang="en">
  <head>
    
     <?php include "include/meta.php"; ?>

     <?php include "include/css.php"; ?>

      
<style>
  td{
    padding: 10px 10px;
  }
   .center{
    text-align: center;
  }
</style>
  </head>
  <body>
<?php include "include/header.php"; ?>


<section class="w3l-contact-breadcrum">
  <div class="breadcrum-bg py-sm-5 py-4">
    <div class="container py-lg-3">
      <h2>Industry Visit </h2>
      <p><a href="index.php">Home</a> &nbsp; / &nbsp; Industry Visit </p>
    </div>
  </div>
</section>


<div class="container">
  <div class="row">
        <div class="col-md-1">
      



    </div>
    <div class="col-md-10">
      <br>
<div class="well form-horizontal">

            
  <p align="left"><table width="98%" border="1" cellspacing="3" cellpadding="3" bordercolor="#000000" style="border-collapse:collapse;">
           <tr align="center" style="background:grey; border:1px solid #000; color:#fff;">
            <td  colspan="4" style="co lor: black; padding: 20px 0; font-size: 20px; ">Industrial Training  Conducted by the Institute</td>
           </tr>
           <tr align="center" style="background:#990000; border:1px solid #000; color:#fff;">
            <td width="30">Sl. No.</td>
            <td width="129">Name of The Companies</td>
              <td width="152">Department</td>
              <td width="119">No. of Students</td>
           </tr>

           <?php
                    $iv_sql = "SELECT * FROM industry_training WHERE i_by = '$x' AND year = '2019' ORDER BY createdate DESC";
                    $iv_run = mysqli_query($con, $iv_sql);

                    $c = 1;
                    while ( $iv_rows = mysqli_fetch_assoc($iv_run) ) {
                ?>
                                                                                                 
           <tr class="text_col">
            <td class="center"><?php echo $c; ?></td>
            <td align="left"><a href="" style="text-decoration:none;"><?php echo $iv_rows['company']; ?></a></td>
              <td class="center"><?php echo $iv_rows['dept']; ?></td>
              <td class="center"><?php echo $iv_rows['total_student']; ?> <br> <?php echo $iv_rows['dept_student']; ?></td>
           </tr>
           
           <?php 
              $c++;
                }
            ?>
           
          </table></p>



</div>

    </div>
    <div class="col-md-1">
      



    </div>
  </div>
</div>

<?php include "include/footer.php"; ?>
<?php include "include/js.php"; ?>

</body>

</html>
<!-- // grids block 5 -->
