File Explorer

<?php include("includes/css.php")?>
<body class="hold-transition skin-blue sidebar-mini">
	<div class="wrapper">
		<?php include("includes/header.php");?>
		<?php include("includes/sidebar.php");?>
		
		<div class="content-wrapper"> 
			<section class="content">
				<div class="row"> 
					<div class="col-md-12">
						<div class="box box-primary">
							<div class="box-header with-border">
								<div class="col-md-7"> 
									<h3 class="box-title"> Fee Collection Report</h3> 
								</div> 
								<div class="col-md-3 pull-right">
									<?php $stotal=mysqli_query($conn,"select SUM(amount) as totals from fee_details ");
											$datat=mysqli_fetch_array($stotal);
											 ?>
									<h3 class="box-title text-right text-blue font-20 font-weight-600">Total Amount : <?=  $datat['totals']; ?> </h3> 
								</div> 
							</div>
							
							<div class="box-body">
								<div class="col-md-12">
										<hr/>
										
										<div class="row mt-20 mb-20 table-responsive"> 
											<table class="table table-bordered example3">
												<thead>
													<tr> 
														<th>Sr. No.</th>
														<th>Date</th>  
														<th>Student Name</th>  
														<th>Class</th>       
														<th>Fee Type</th>       
														<th>Payment Mode</th>       
														<th>Reciept No</th>       
														<th>User Name</th>          
														<th>Amount</th> 
														<th>Fees Due Date</th> 
													</tr>
												</thead>
												<tbody> 
									 <?php if(isset($_POST['search'])){ 
									 	$from_date=$_POST['from_date'];
									 	$to_date=$_POST['to_date'];
									 	$class_id=$_POST['class_id'];
									extract($_POST);
									$sql=mysqli_query($conn,"select fee_details.*,student.name,student.branch,student.username from fee_details join student on fee_details.student_id=student.id where fee_details.class_id='".$class_id."' and (date_of_transaction between '".$from_date."' and '".$to_date."')");
									}else{ $sql=mysqli_query($conn,"select fee_details.*,student.name,student.branch,student.username from fee_details join student on fee_details.student_id=student.id"); }
									           $j=1;
												while($res= mysqli_fetch_array($sql)){ 
													?>
													<tr>
											     <td><?php echo $j; $j++; ?></td>
											     <td><?php echo $res['date_of_transaction']; ?></td>
											     <td><?php echo $res['name']; ?></td>
											     <?php $class_id=$res['class_id'];
										     $sql_cl=mysqli_query($conn,"SELECT * from class where id='$class_id'");
                                             $res_cls=mysqli_fetch_array($sql_cl);?>
                                             <td><?php echo $res_cls['class_name']; ?></td>
                                             <td><?php echo $res['fee_type']; ?></td>
                                             <td><?php echo $res['amount_mode']; ?></td>
                                             <td><?php echo $res['reciept_no']; ?></td>
                                             <td><?php echo $res['username']; ?></td>
                                             <td><?php echo $res['amount']; ?></td>
                                             <td><?php echo $res['due_date']; ?></td>
													</tr> 
													<?php } ?>						
											<tr><?php $fdau = "Due Amt";
											$sqlss=mysqli_query($conn,"select SUM(amount) as du from fee_details where due_amt='".$fdau."'");
								               $resss= mysqli_fetch_array($sqlss);?>
								            
                                            <td colspan="9" class="text-center"><strong> Total Due Amount:</strong></td>
                                            <td class="text-center" style="font-size:20px;"><strong><?php echo $resss['du']; ?></strong></td>
                                        </tr>		
												</tbody>
											</table>
										</div>
								</div>
							</div> 
						</div>  
					</div>  
				</div>  
		</section>
	</div>
	<?php include("includes/footer.php");?>
</div>
<?php include("includes/js.php");?>
</body>
</html>

Editing File: fee-collection-report.php