<?php include "layouts/menu.php"; ?>    
  <!--  page-wrapper -->
         <div class="right_col" role="main">
            <div class="row">
                 <!-- page header -->
                <div class="col-lg-12">
                    <h1 class="page-header  alert alert-info">Customers Of Vehicle Loan</h1>
                </div>
                <!--end page header -->
            </div>
            <div class="row">
                <div class="col-lg-12">
                    <!-- Form Elements -->
                    <div class="panel panel-default">
                        <div class="panel-heading">
                             Details
                        </div>
                        <div class="panel-body">
                            <div class="row">
  
   <div class="alert alert-info">Customer Details</div>
  
                    <?php
		
						$qry=mysqli_query($conn, "select * from vuser where mfin='$mfin'");
						$n=mysqli_num_rows($qry);
						if($n==0)
						{
							echo "Nothing To Display";
						}
						else
					{ 
						?></p>
					<table class="table table-striped" table class="table" border="0" align="center" cellspacing="0" cellpadding="10" >
					<col width="100px">
						<tr class="danger" style="color:purple;">
						<th>Loan No</th>
						<th>Name</th>
						<th>User Image</th>
						<th>Vehicle No</th>
						<th>Debit Given</th>
						<th>Credit pay</th><th>Pay Date</th>
						<th>More Details</th>
					</tr>
					<?php 
$x=1; 
while($x<=2000)
  {$qry=mysqli_query($conn, "select * from vuser where mfin='$mfin' &&  hpl=$x");
				$n=mysqli_num_rows($qry);
				$row=mysqli_fetch_array($qry);
						if($n==0)
						{
							$x++;
						}
						else
					{
?>				<tr class="warning">
					<col width="100px">
						<td><?php echo $row['hpl'];?></td>
						<td><?php echo $row['name']; ?></td>
						<td><img src="user/<?php echo $row['uimg'];?>" width="120" height="120"/></td>
						<td><?php echo $row['vno'];?></td>
						<td><?php echo $row['fine'];?></td>
						<td><?php echo $row['dfaultdate'];?></td><td><?php echo $row['paydate'];?></td>
						<td><a href="audelete.php?hpl=<?php echo $row['hpl'];?>&name=<?php echo $row['name'];?>">More Info</a></td>
					</tr>
					<?php
						$x++;}}
					}
				
					?>
					</table>
					
</div>
</div></div>
</div></div></div> <?php include "layouts/footer.php"; ?></body></html>
