prepare("SELECT cp.id, cp.applicant_id, cp.total_payment, cp.paid_amount, cp.pending_amount, cp.payment_date, cp.payment_message, cp.installment_number, cp.installment_due_date, ja.name, ja.passport_no, ja.position, ja.job_country, ja.reference FROM clientspayment cp JOIN job_applicants ja ON cp.applicant_id = ja.id WHERE cp.id = ?"); $stmt->bind_param("i", $payment_id); // "i" is for integer $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { $payment = $result->fetch_assoc(); } else { echo ""; exit; } } else { echo ""; exit; } // Handle form submission for updating the payment record if ($_SERVER["REQUEST_METHOD"] == "POST") { $total_payment = $_POST['total_payment']; $paid_amount = $_POST['paid_amount']; $payment_date = $_POST['payment_date']; $payment_message = $_POST['payment_message']; $installments = $_POST['installments']; // Number of installments // Calculate pending amount $pending_amount = $total_payment - $paid_amount; // Update payment record in the database $stmt_update = $con->prepare("UPDATE clientspayment SET total_payment = ?, paid_amount = ?, pending_amount = ?, payment_date = ?, payment_message = ? WHERE id = ?"); $stmt_update->bind_param("ddddsi", $total_payment, $paid_amount, $pending_amount, $payment_date, $payment_message, $payment_id); if ($stmt_update->execute()) { // If installments are added, update the installment information if ($installments > 0) { for ($i = 1; $i <= $installments; $i++) { $installment_due_date = $_POST['installment_due_date_' . $i]; $stmt_installment = $con->prepare("UPDATE clientspayment SET installment_due_date = ? WHERE id = ? AND installment_number = ?"); $stmt_installment->bind_param("sii", $installment_due_date, $payment_id, $i); $stmt_installment->execute(); } } echo ""; exit; } else { echo ""; } } ?>