1800)) { header("Location: logout.php"); exit(); } $_SESSION['last_activity'] = time(); require_once 'db_connection.php'; $pageTitle = "Edit Buyer"; if (!isset($_GET['id'])) { $_SESSION['error'] = "Buyer ID is required."; header("Location: base.php"); exit(); } $buyerId = intval($_GET['id']); // Fetch buyer data $stmt = $conn->prepare("SELECT * FROM buyers WHERE id = ?"); $stmt->bind_param("i", $buyerId); $stmt->execute(); $result = $stmt->get_result(); $buyer = $result->fetch_assoc(); $stmt->close(); if (!$buyer) { $_SESSION['error'] = "Buyer not found."; header("Location: base.php"); exit(); } // Handle form submission if ($_SERVER["REQUEST_METHOD"] == "POST") { try { $stmt = $conn->prepare("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->bind_param("ssddddddi", $_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(); $stmt->close(); $_SESSION['success'] = "Buyer updated successfully!"; header("Location: base.php"); exit(); } catch (Exception $e) { $_SESSION['error'] = "An error occurred while updating buyer."; error_log("Edit buyer error: " . $e->getMessage()); } } $content = <<

Edit Buyer

Buyer Name:

Phone:

Tilapia Rate (₹/kg):

Small Fish Rate (₹/kg):

Big Fish Rate (₹/kg):

Delivery Rate (₹):

Harvesting Fee - Tilapia (₹/kg):

Harvesting Fee - Small Fish (₹/kg):

Harvesting Fee - Big Fish (₹/kg):

Cancel

HTML; include 'main_layout.php'; $conn->close(); ?>