prepare($query); $stmt->bind_param("i", $buyerId); $stmt->execute(); $result = $stmt->get_result(); $buyer = $result->fetch_assoc(); if (!$buyer) { header("Location: base.php"); exit(); } // Handle form submission if ($_SERVER["REQUEST_METHOD"] == "POST") { $query = "UPDATE buyers SET name = ?, phone = ?, rate_tilapia = ?, rate_small_fish = ?, rate_big_fish = ?, delivery_rate = ?, harvesting_fee_tilapia = ?, harvesting_fee_small_fish = ?, harvesting_fee_big_fish = ? WHERE id = ?"; $stmt = $conn->prepare($query); $stmt->bind_param("ssdddddddi", $_POST["name"], $_POST["phone"], $_POST["rate_tilapia"], $_POST["rate_small_fish"], $_POST["rate_big_fish"], $_POST["delivery_rate"], $_POST["harvesting_fee_tilapia"], $_POST["harvesting_fee_small_fish"], $_POST["harvesting_fee_big_fish"], $buyerId); $stmt->execute(); header("Location: base.php"); exit(); } $content = <<Edit Buyer

Buyer Name: Phone: Rate of Tilapia per Kg: Rate of Small Fish per Kg: Rate of Big Fish per Kg: Delivery Rate: Harvesting Fee Per Kg - Tilapia: Harvesting Fee Per Kg - Small Fish: Harvesting Fee Per Kg - Big Fish: Update Buyer

HTML; // Include the main layout include 'main_layout.php';