query("SELECT * FROM students WHERE enrollment_no = '$enroll'"); if($get->num_rows){ $st = $get->fetch_assoc(); $course_id = $st['course_id']; $center_id = $st['center_id']; $cour = $con->query("SELECT * FROM courses WHERE id = '$course_id'")->fetch_assoc(); $cent = $con->query("SELECT * FROM centers WHERE id = '$center_id'")->fetch_assoc(); $total = $st['payable_amount']; $paid = $con->query("SELECT SUM(amount) as ttl FROM fee_collection WHERE enrollment_no = '$enroll'")->fetch_assoc()['ttl']; $due = $total - $paid; ?> Invoice

Invoice

Father's Name:

Address:

Contact Number:

Email:

DOB:

Course:

logo

Recipient

Enrollment No #
Total Rs.
Amount Due Rs.
query("SELECT * FROM fee_collection WHERE enrollment_no = '$enroll'"); while($fee = $fees->fetch_assoc()){ echo ''; } ?>
Date Description Amount
'.date('d-m-Y',strtotime($fee['date'])).' '.$fee['payment_details'].' Rs.'.$fee['amount'].'
Total Rs.
Amount Paid Rs.
Balance Due Rs.