<?php include "layouts/menucodfa.php"; ?> <div class="right_col" role="main">
            
            <div class="row">
                <div class="col-lg-12">
                    <!-- Form Elements -->
                    <div class="panel panel-default">
                        <div class="panel-heading">
                        Smart  CustomerS Details
                        </div>
                        <div class="panel-body">
                            <div class="row">
 
  <?php $gid=$_REQUEST['gid'];?>
  <div class="table-responsive">
  <table id="datatable-buttons" id="datatable-buttons" class="table table-striped table-bordered">
					<thead>
						<tr>
						<th>S.No</th>
						<th>Name</th>
						<th>User Image</th>
						<th>Vehicle No</th>
						
						<th>Phone No</th>
						<th>Aadhar</th>
						<th>PAN</th>
						
					</tr></thead><tbody>
					
                    <?php $ii = 0;
					
						$qry=mysqli_query($conn, "select * from customerdetails  where g1 LIKE '$gid'");
						$n=mysqli_num_rows($qry);
						if($n==0)
						{
						
						}
						else
					        { 
						?></p>
					
					<?php 
					while($row=mysqli_fetch_array($qry))
						{ $ii++;
							$mfin2 = $row['mfin'];
					?>
					
				<tr>
				
						<td><?php echo $ii;?></td>
						<td><?php echo $row['name']; ?></td>
					<?php $dddd = $row['uimg']; if($dddd!= NULL) { ?>	<td><img src="user/<?php echo $row['uimg'];?>" width="40" height="40"/></td> <?php } else { ?>
					<td><img src="111.png" width="40" height="40"/></td> <?php } ?>
						<td><?php echo $row['vno'];?></td>
						
		
				
				
						<td><?php echo $row['pno'];?></td>
						<td><?php echo $row['g1'];?></td>
						<td><?php echo $row['g2'];?></td>
						
					</tr>
					<?php
						}
					}
				
					?>
					
					
			 <?php
					
						$qry22=mysqli_query($conn, "select * from customerdetails  where g2 LIKE '$gid'");
						$n=mysqli_num_rows($qry22);
						if($n==0)
						{
						
						}
						else
					        { 
						?></p>
					
					<?php 
					while($row=mysqli_fetch_array($qry22))
						{ $ii++;
							$mfin2 = $row['mfin'];
					?>
					
			<tr>
				
						<td><?php echo $ii;?></td>
						<td><?php echo $row['name']; ?></td>
					<?php $dddd = $row['uimg']; if($dddd!= NULL) { ?>	<td><img src="user/<?php echo $row['uimg'];?>" width="40" height="40"/></td> <?php } else { ?>
					<td><img src="111.png" width="40" height="40"/></td> <?php } ?>
						<td><?php echo $row['vno'];?></td>
						
		
				
				
						<td><?php echo $row['pno'];?></td>
						<td><?php echo $row['g1'];?></td>
						<td><?php echo $row['g2'];?></td>
						
					</tr>
					<?php
						}
					}
				
					?>		
					
			 <?php
					
						$qry33=mysqli_query($conn, "select * from customerdetails  where g3 LIKE '$gid'");
						$n=mysqli_num_rows($qry33);
						if($n==0)
						{
						
						}
						else
					        { 
						?></p>
					
					<?php 
					while($row=mysqli_fetch_array($qry33))
						{ $ii++;
							$mfin2 = $row['mfin'];
					?>
					
				<tr>
				
						<td><?php echo $ii;?></td>
						<td><?php echo $row['name']; ?></td>
					<?php $dddd = $row['uimg']; if($dddd!= NULL) { ?>	<td><img src="user/<?php echo $row['uimg'];?>" width="40" height="40"/></td> <?php } else { ?>
					<td><img src="111.png" width="40" height="40"/></td> <?php } ?>
						<td><?php echo $row['vno'];?></td>
						
		
				
				
						<td><?php echo $row['pno'];?></td>
						<td><?php echo $row['g1'];?></td>
						<td><?php echo $row['g2'];?></td>
						
					</tr>
					<?php
						}
					}
				
					?>		
					
					
					
					 <?php
					
						$qry55=mysqli_query($conn, "select * from customerdetails  where b1 LIKE '$gid'");
						$n=mysqli_num_rows($qry55);
						if($n==0)
						{
						
						}
						else
					        { 
						?></p>
					
					<?php 
					while($row=mysqli_fetch_array($qry55))
						{ $ii++;
							$mfin2 = $row['mfin'];
					?>
					
			<tr>
				
						<td><?php echo $ii;?></td>
						<td><?php echo $row['name']; ?></td>
					<?php $dddd = $row['uimg']; if($dddd!= NULL) { ?>	<td><img src="user/<?php echo $row['uimg'];?>" width="40" height="40"/></td> <?php } else { ?>
					<td><img src="111.png" width="40" height="40"/></td> <?php } ?>
						<td><?php echo $row['vno'];?></td>
						
		
				
				
						<td><?php echo $row['pno'];?></td>
						<td><?php echo $row['g1'];?></td>
						<td><?php echo $row['g2'];?></td>
						
					</tr>
					<?php
						}
					}
				
					?>
					
					
					
					 <?php
					
						$qry66=mysqli_query($conn, "select * from customerdetails  where b2 LIKE '$gid'");
						$n=mysqli_num_rows($qry66);
						if($n==0)
						{
						
						}
						else
					        { 
						?></p>
					
					<?php 
					while($row=mysqli_fetch_array($qry66))
						{ $ii++;
							$mfin2 = $row['mfin'];
					?>
					
				<tr>
				
						<td><?php echo $ii;?></td>
						<td><?php echo $row['name']; ?></td>
					<?php $dddd = $row['uimg']; if($dddd!= NULL) { ?>	<td><img src="user/<?php echo $row['uimg'];?>" width="40" height="40"/></td> <?php } else { ?>
					<td><img src="111.png" width="40" height="40"/></td> <?php } ?>
						<td><?php echo $row['vno'];?></td>
						
		
				
				
						<td><?php echo $row['pno'];?></td>
						<td><?php echo $row['g1'];?></td>
						<td><?php echo $row['g2'];?></td>
						
					</tr>
					<?php
						}
					}
				
					?>
					
					<?php
					
						$qry001=mysqli_query($conn, "select * from customerdetails  where pno LIKE '$gid'");
						$n11=mysqli_num_rows($qry001);
						if($n11==0)
						{
						
						}
						else
					        { 
						?></p>
					
					<?php 
					while($row=mysqli_fetch_array($qry001))
						{ $ii++;
							$mfin2 = $row['mfin'];
					?>
					
				<tr>
				
						<td><?php echo $ii;?></td>
						<td><?php echo $row['name']; ?></td>
					<?php $dddd = $row['uimg']; if($dddd!= NULL) { ?>	<td><img src="user/<?php echo $row['uimg'];?>" width="40" height="40"/></td> <?php } else { ?>
					<td><img src="111.png" width="40" height="40"/></td> <?php } ?>
						<td><?php echo $row['vno'];?></td>
						
		
				
				
						<td><?php echo $row['pno'];?></td>
						<td><?php echo $row['g1'];?></td>
						<td><?php echo $row['g2'];?></td>
						
					</tr>
					<?php
						}
					}
				
					?>
					
					<?php
					
						$qry0012=mysqli_query($conn, "select * from customerdetails  where vno LIKE '%$gid%'");
						$n11=mysqli_num_rows($qry0012);
						if($n11==0)
						{
						
						}
						else
					        { 
						?></p>
					
					<?php 
					while($row=mysqli_fetch_array($qry0012))
						{ $ii++;
							$mfin2 = $row['mfin'];
					?>
					
				<tr>
				
						<td><?php echo $ii;?></td>
						<td><?php echo $row['name']; ?></td>
					<?php $dddd = $row['uimg']; if($dddd!= NULL) { ?>	<td><img src="user/<?php echo $row['uimg'];?>" width="40" height="40"/></td> <?php } else { ?>
					<td><img src="111.png" width="40" height="40"/></td> <?php } ?>
						<td><?php echo $row['vno'];?></td>
						
		
				
				
						<td><?php echo $row['pno'];?></td>
						<td><?php echo $row['g1'];?></td>
						<td><?php echo $row['g2'];?></td>
						
					</tr>
					<?php
						}
					}
				
					?>
					
				</tbody>	</table>
					
 
</div>
</div></div>
</div></div></div> <?php include "layouts/footert.php"; ?> </body></html>