odeme

connect_error) { die("Connection failed: " . $conn->connect_error); }// Öğrenci Ekleme if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['submitStudent'])) { $studentName = $_POST['studentName']; $totalAmount = $_POST['totalAmount']; $installments = $_POST['installments']; $installmentAmount = $totalAmount / $installments;// Öğrenci bilgilerini veritabanına ekle $sql = "INSERT INTO students (name, total_amount, installments, installment_amount, paid_amount) VALUES ('$studentName', '$totalAmount', '$installments', '$installmentAmount', 0)";if ($conn->query($sql) === TRUE) { echo "Yeni öğrenci başarıyla eklendi."; } else { echo "Hata: " . $sql . "
" . $conn->error; } }// Ödeme işlemi if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['makePayment'])) { $studentId = $_POST['student_id']; $paymentAmount = $_POST['paymentAmount'];// Öğrenciye ait verileri al $sql = "SELECT * FROM students WHERE id = $studentId"; $result = $conn->query($sql); $student = $result->fetch_assoc();$paidAmount = $student['paid_amount']; $totalAmount = $student['total_amount']; $remainingAmount = $totalAmount - $paidAmount;if ($paymentAmount <= $remainingAmount) { $newPaidAmount = $paidAmount + $paymentAmount;// Ödeme sonrası veriyi güncelle $updateSql = "UPDATE students SET paid_amount = $newPaidAmount WHERE id = $studentId"; if ($conn->query($updateSql) === TRUE) { echo "Ödeme başarıyla kaydedildi."; } else { echo "Hata: " . $updateSql . "
" . $conn->error; } } else { echo "Ödeme tutarı, kalan borçtan fazla olamaz."; } }$conn->close(); ?>