'Buyer ID is required']); exit(); } $buyerId = intval($_GET['id']); try { $stmt = $conn->prepare("SELECT rate_tilapia, rate_small_fish, rate_big_fish, delivery_rate, harvesting_fee_tilapia, harvesting_fee_small_fish, harvesting_fee_big_fish FROM buyers WHERE id = ?"); $stmt->bind_param("i", $buyerId); $stmt->execute(); $result = $stmt->get_result(); $buyer = $result->fetch_assoc(); $stmt->close(); if ($buyer) { echo json_encode($buyer); } else { echo json_encode(['error' => 'Buyer not found']); } } catch (Exception $e) { echo json_encode(['error' => 'Database error']); error_log("Get buyer rates error: " . $e->getMessage()); } $conn->close(); ?>