prepare($query); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); $trader = $result->fetch_assoc(); if (!$trader) { header('Location: view_members.php'); exit; } $markets = getMarkets(); $states = getStates(); $success_message = ''; $error_message = ''; if ($_SERVER['REQUEST_METHOD'] == 'POST') { $query = "UPDATE traders SET full_name = ?, market_name = ?, market_lga = ?, shop_no = ?, en_no = ?, whatsapp = ?, email = ?, state_of_origin = ?, lga_of_origin = ? WHERE id = ?"; $stmt = $conn->prepare($query); $stmt->bind_param("sssssssssi", $_POST['full_name'], $_POST['market_name'], $_POST['market_lga'], $_POST['shop_no'], $_POST['en_no'], $_POST['whatsapp'], $_POST['email'], $_POST['state_of_origin'], $_POST['lga_of_origin'], $id ); if ($stmt->execute()) { $success_message = "Member information updated successfully!"; // Refresh data $stmt = $conn->prepare("SELECT * FROM traders WHERE id = ?"); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); $trader = $result->fetch_assoc(); } else { $error_message = "Error updating record: " . $stmt->error; } } ?>

Edit Member:

Back to List