43 lines
1.4 KiB
PHP
43 lines
1.4 KiB
PHP
<?php
|
|
include('pdf_header.php');
|
|
include('includes/config/config.php');
|
|
//include('pop_up_top.php');
|
|
?>
|
|
<h2 style="text-align: center;"> Fee Collection</h2>
|
|
<table border="1" cellspacing="0" cellpadding="5">
|
|
<?php
|
|
$sql = "SELECT student_name, beneficiary_id, fee_schedule_id, collection_date, fee_amount, remarks, collection_status, payment_mode, payment_remarks FROM fee_collection";
|
|
$result = mysqli_query($conn, $sql);
|
|
?>
|
|
<tr bgcolor='#eeeeee'>
|
|
<th width="30%">Student Name</th>
|
|
<th width="30%">Beneficiary Id</th>
|
|
<th width="20%">Fee Schedule Id</th>
|
|
<th width="20%">Collection Date</th>
|
|
<th width="20%">Fee Amount</th>
|
|
<th width="20%">Remarks</th>
|
|
<th width="20%">Collection Status</th>
|
|
<th width="20%">Payment Mode</th>
|
|
<th width="20%">Payment Remarks</th>
|
|
</tr>
|
|
<?php
|
|
while ($rowOfprograme = mysqli_fetch_array($result)) {
|
|
?>
|
|
<tr>
|
|
<td><?php echo $rowOfprograme['student_name']; ?></td>
|
|
<td><?php echo $rowOfprograme['beneficiary_id']; ?></td>
|
|
<td><?php echo $rowOfprograme['fee_schedule_id']; ?></td>
|
|
<td><?php echo $rowOfprograme['collection_date']; ?></td>
|
|
<td><?php echo $rowOfprograme['fee_amount']; ?></td>
|
|
<td><?php echo $rowOfprograme['remarks']; ?></td>
|
|
<td><?php echo $rowOfprograme['collection_status']; ?></td>
|
|
<td><?php echo $rowOfprograme['payment_mode']; ?></td>
|
|
<td><?php echo $rowOfprograme['payment_remarks']; ?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</table>
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|