FileXXXXXXXXXXX

?????????????? ?????????????? FileXXXXXXXXXXX

File manager - Edit - D:/Inetpub/vhosts/xceljsr.com/httpdocs/cms/insert_fee.php

Back
<?php include('session.php'); include 'connection.php'; $admission_no = mysqli_real_escape_string($conn, $_POST['admission_no']); $student_name = mysqli_real_escape_string($conn, $_POST['student_name']); $fathers_name = mysqli_real_escape_string($conn, $_POST['fathers_name']); $mobile_no = mysqli_real_escape_string($conn, $_POST['mobile_no']); $course_name = mysqli_real_escape_string($conn, $_POST['course_name']); $total_fee = floatval($_POST['total_fee']); $due_amount = floatval($_POST['due_amount']); // This is the calculated due amount from frontend $paid_amount = floatval($_POST['paid_amount']); $mr_no = mysqli_real_escape_string($conn, $_POST['mr_no']); $transaction_id = mysqli_real_escape_string($conn, $_POST['transaction_id']); $payment_date = mysqli_real_escape_string($conn, $_POST['payment_date']); $received_amount = floatval($_POST['received_amount']); $bank_upi = mysqli_real_escape_string($conn, $_POST['bank_upi']); $addedby = $_SESSION['uid']; // Insert fee record $sql = "INSERT INTO fees ( admission_no, student_name, fathers_name, mobile_no, course_name, total_fee, due_amount, paid_amount, mr_no, transaction_id, payment_date, received_amount, bank_upi, addedby ) VALUES ( '$admission_no','$student_name','$fathers_name','$mobile_no','$course_name','$total_fee','$due_amount','$paid_amount','$mr_no','$transaction_id','$payment_date','$received_amount','$bank_upi','$addedby' )"; if ($conn->query($sql) === TRUE) { // Update MR counter $update_counter_sql = "UPDATE mr_counter SET counter = counter + 1 WHERE id = 1"; if (mysqli_query($conn, $update_counter_sql)) { echo "<script> alert('Fee record added successfully.'); window.location.href = 'fee.php'; </script>"; } else { echo "<script> alert('Fee added, but failed to update MR counter.'); window.location.href = 'fee.php'; </script>"; } } else { echo "<script> alert('Error adding fee record: " . addslashes($conn->error) . "'); window.history.back(); </script>"; } ?>