
<?php include 'auth_header.php'; ?>




<!-- partial -->
      <div class="main-panel">
        <div class="content-wrapper">
            
            
            
            
            
             <div class="row">
            <div class="col-lg-6 grid-margin stretch-card">
              <div class="card">
                <div class="card-body">
                  <h4 class="card-title">Loan Statistics</h4>
                  <canvas id="lineChart"></canvas>
                </div>
              </div>
            </div>
            <div class="col-lg-6 grid-margin stretch-card">
              <div class="card">
                <div class="card-body">
                  <h4 class="card-title">Interest Reading...</h4>
                  <canvas id="barChart"></canvas>
                </div>
              </div>
            </div>
          </div>
            
            
            
            
            
            
          <div class="row">
      
   
            <div class="col-lg-12 grid-margin stretch-card">
              <div class="card">
                <div class="card-body">
                  <h4 class="card-title">Loan Application Status</h4>
                  <p class="card-description">
                    Loan Approval and Statistical Page</code>
                  </p>
                  <div class="table-responsive">
                    
                      
                      
                      
                      
                        <?php
								
			        $conn = mysqli_connect($host, $username, $password, $database);

		            $uname = $row['uname']; 
             	    $query=mysqli_query($conn,"SELECT * FROM `quick_loan` WHERE uname ='$uname' ");
     
            		
            		echo '<table  class="table table-striped">';
            		echo '<caption class=""><br>';
            		echo '<thead><tr><th>LOAN AMOUNT:</th><th>PURPOSE</th><th>DURATION</th><th>% RATE</th><th>M/PAY</th><th>BALANCE</th><th>STATUS</th><th>DATE</th><th>ACTION</th>
            		 
            		</tr></thead>';
            		
            		
            		while($active=mysqli_fetch_array($query)){
            			echo '
            			
            		  
            			<tbody><tr><td>'.$active['loanamt'].'</td><td>'.$active['purpose'].'</td>
            			<td>'.$active['dura'].'</td><td>'.$active['inter'].'</td><td>'.$active['monthlypay'].'</td><td>'.$active['balance'].'</td><td><strong style="color:green">'.$active['status'].'</strong></td>
            		<td>'.$active['date'].'</td>	<td class="filled-button dark"><strong ><a href="delete_loan.php?id='.$active['id'].'">DELETE</a></strong></td>
            			</tr></tbody>';
            		}
            		echo '</table>';
            		
            		      	 {
                                 						       
                     }
                         
            	  ?>
                      
                      
                    
               
                    </table>
                  </div>
                </div>
              </div>
            </div>
            
            
            
         
          </div>
        </div>
        
        
        
        
        
        
        
        
        
        <?php include 'auth_footer.php'; ?>
        
        