<div class="container">
  <div class="col-sm-12 col-12" id="mainpage">


   <div class="col-sm-12 col-12 p-0"  data-aos="fade-in" data-aos-duration="2000" >
    <ul class="list-group p-0">
      <li class="list-group-item font-weight-bold bg-success text-light" id="about">অনুসন্ধানকৃত শিক্ষার্থীর তথ্য </li>
      <li class="list-group-item">

        <div class="table table-responsive">
          <table id="example" class="display table-bordered" style="width:99.7%">
            <thead>
              <tr style="font-size: 15px;">
                <th>ক্রমিক</th>
                <th>নাম</th>
				<th>অভিভাবক</th>
                <th>আইডি</th>
				<th>রোল</th>
				<th>ক্লাস</th>
				<th>ব্লাড গ্রুপ</th>
				<th>ধর্ম</th>
                <th>লিংগ</th>
              </tr>
            </thead>
            <tbody>


              
             <?php
							  $i=1;
							  
					?>
					<?php 
						$query_1="";
						$query_2="";
						$query_3="";
						$query_4="";
						$query_5="";
						$query_6="";
						
						//$query="SELECT * FROM training_student_info WHERE project_id='$project_idds'";
						
						if($class_name!="")
							$query_1=" AND class_name='$class_name'";
						
						if($shift_name!='')
						{
							$query_2=" AND shift_name='$shift_name'";
						}
						
						if($section_name!='')
						{
							$query_3=" AND section_name='$section_name'";
						}
						
						if($religion!='')
						{
							$query_4=" AND religion='$religion'";
						}
						
						if($gender!='')
						{
							$query_5=" AND gender='$gender'";
						}
						
						if($bg!='')
						{
							$query_6=" AND bg='$bg'";
						}
						
						
						//$i=1;	
						//$where1 = "ctype='1'";
						//$this->db->where($where1);
								$where = "mobile!='4'".$query_1.$query_2.$query_3.$query_4.$query_5.$query_6;
								$this->db->where($where);					
								$query2 = $this->main_model->student();
								foreach($query2 as $row2):
							  ?>
                            
              

				<tr style="font-size: 12px;">
                <td><?php echo $i; ?></td>
                <td><?php echo $row2['name']; ?></td>
				 <td>F: <?php echo $row2['name']; ?><br>M: <?php echo $row2['name']; ?></td>
                <td><?php echo $row2['jbID']; ?></td> 
<td><?php echo $row2['stID']; ?></td>  				
				<td>
				
					<?php 
										$query111 = $this->main_model->sclass();
										foreach($query111 as $row123):
									?>
									<?php if($row2['class_name']==$row123['scid']): ?><?php echo $row123['name']; ?><?php endif; ?>
								<?php endforeach; ?><br>
					Section: 
					
					<?php if($row2['shift_name']==1){?>A<?php }elseif($row2['shift_name']==2){?>B<?php }elseif($row2['shift_name']==3){ ?>C<?php }else{ ?>D<?php } ?>
					<br>Group: <?php echo $row2['section_name']; ?>
				</td>	
				<td><?php echo $row2['bg']; ?></td>
				<td><?php echo $row2['religion']; ?></td>
				<td><?php echo $row2['gender']; ?></td>				
				 
			  </tr>
<?php $i=$i+1; ?>
                             <?php endforeach; ?>

              
              

             


                            

             
          </table>

        </div>

      </li>

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





</div>
</div>