prepare("SELECT * FROM payments WHERE id = ?");
$stmt->bind_param("i", $paymentId);
$stmt->execute();
$result = $stmt->get_result();
$payment = $result->fetch_assoc();
$stmt->close();
if (!$payment) {
$_SESSION['error'] = "Payment not found.";
header("Location: payments.php");
exit();
}
$buyersQuery = "SELECT id, name FROM buyers ORDER BY name";
$buyers = $conn->query($buyersQuery)->fetch_all(MYSQLI_ASSOC);
if ($_SERVER["REQUEST_METHOD"] == "POST") {
try {
$stmt = $conn->prepare("UPDATE payments SET date = ?, buyer_id = ?, amount_paid = ? WHERE id = ?");
$stmt->bind_param("sidi", $_POST['date'], $_POST['buyer_id'], $_POST['amount_paid'], $paymentId);
$stmt->execute();
$stmt->close();
$_SESSION['success'] = "Payment updated successfully!";
header("Location: payments.php");
exit();
} catch (Exception $e) {
$_SESSION['error'] = "Error updating payment.";
error_log("Edit payment error: " . $e->getMessage());
}
}
$buyerOptions = '';
foreach ($buyers as $buyer) {
$selected = $buyer['id'] == $payment['buyer_id'] ? 'selected' : '';
$buyerOptions .= "";
}
$content = <<
HTML;
include 'main_layout.php';
$conn->close();
?>