<?php ob_start(); ?>
<?php include('session.php'); ?>

<!DOCTYPE HTML>
<html lang="en-US">
<head>
	<meta charset="UTF-8">
	
 <title>Training Institute Manager - ITM-SOFTS</title> 
 <link rel="icon" type="image/x-icon" href="../includes/dim.png">
<link rel="stylesheet" href="css/table_data_center_with_border_black.css">
</head>


<body>
<br>
<center> <?php 
				  				   $pq=mysqli_query($con,"select * from stuff left join `user` on user.userid=stuff.userid where stuff.userid='".$_SESSION['id']."'");
				   while($pqrow=mysqli_fetch_array($pq)){
				?>
			<span style="font-size:21;font-weight:bold;">
			 <?php echo $pqrow['business_name']; ?>  <br>
			 </span>	
			<?php }?>
			<span style="font-size:19;">
			 In Active Students List<br>
            </span>			 
			 </div>	   
<span style="font-size:18;">
		 
Present Date  :</b> <?php echo date("M d,Y") ;?> |
Present Time: </b> <?php date_default_timezone_set("Asia/Dhaka"); echo  date("h:i:sa");?>
</span>	

 </center> 
<body>
    <div class="container-fluid">
		<br>
            <div class="container-fluid">
			
				<div class="row">
                <div class="col-lg-12">
                    <table width="100%" class="table table-bordered">
						<thead>								 
								<tr>
									<th>SL</th> 
									<th>Batch</th> 
									<th>Students Name</th> 
									<th>Address</th> 
									<th>Phone</th> 
									<th>Admission Date</th>
									<th>Comments</th>
								</tr>
						</thead>
						<tbody>
							<?php
							$sl=0;
								$eq=mysqli_query($con,"select * from customer 	 
								LEFT JOIN batch ON batch.id = customer.batch_no
								where  customer.member_id='".$_SESSION['id']."'  and customer.status=0 ");
								while($eqrow=mysqli_fetch_array($eq)){
								?>
								<tr>
								    <td><?php echo ++$sl; ?>  </td> 
									<td><?php echo $eqrow['batch_name']; ?></td>
									<td><?php echo $eqrow['customer_name']; ?></td>
									<td><?php echo $eqrow['address']; ?></td>
									<td><?php echo $eqrow['contact_info']; ?></td>									
									<td><?php echo date("d-M-Y", strtotime($eqrow['join_date'])); ?></td>
									<td> </td>
								</tr>
							
								<?php
								}
							?>
						</tbody>
						
						 
						
					</table>					
				</div>
				</div>
           
			</div>
	</div>
	
		
</body>
</html>
