APPA NASTA CENTER

query("UPDATE emis SET status='overdue' WHERE due_date<'$today' AND status='pending'"); ?>

Select Customer

Select Customer query("SELECT * FROM customers"); while($c = $customers->fetch_assoc()){ $selected = (isset($_GET['customer_id']) && $_GET['customer_id']==$c['id']) ? 'selected' : ''; echo "{$c['full_name']}"; } ?>

View

query("SELECT * FROM loans WHERE customer_id = $customer_id"); if($loanQuery->num_rows == 0){ echo ""; } else { $loan = $loanQuery->fetch_assoc(); ?> query("SELECT * FROM emis WHERE loan_id={$loan['id']} ORDER BY emi_number ASC"); while($emi = $emis->fetch_assoc()): ?>

EMI No	Due Date	Amount	Status	Paid Date	Action
		₹			Pay Paid