query($sql); if ($result->num_rows == 0) { redirect(SITE_URL . ADMIN_PATH . '/manage-members.php'); } $member = $result->fetch_assoc(); if ($_SERVER['REQUEST_METHOD'] === 'POST') { $full_name = clean_input($_POST['full_name']); $email = clean_input($_POST['email']); $phone = clean_input($_POST['phone']); $is_verified = isset($_POST['is_verified']) ? 1 : 0; $is_approved = isset($_POST['is_approved']) ? 1 : 0; $payment_status = isset($_POST['payment_status']) ? 1 : 0; // Validation if (empty($full_name) || empty($email) || empty($phone)) { $error = "Name, email, and phone are required"; } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $error = "Invalid email format"; } else { // Check if email is already used by another member $check_sql = "SELECT id FROM members WHERE email = '$email' AND id != $member_id"; $check_result = $conn->query($check_sql); if ($check_result->num_rows > 0) { $error = "Email is already registered by another member"; } else { // Update member $update_sql = "UPDATE members SET full_name = '$full_name', email = '$email', phone = '$phone', is_verified = $is_verified, is_approved = $is_approved, payment_status = $payment_status WHERE id = $member_id"; if ($conn->query($update_sql)) { $success = "Member updated successfully!"; // Refresh member data $result = $conn->query("SELECT * FROM members WHERE id = $member_id"); $member = $result->fetch_assoc(); } else { $error = "Failed to update member: " . $conn->error; } } } } $page_title = 'Edit Member'; include '../includes/header.php'; ?>

← Back to Members

Edit Member

Basic Information

Full Name *

Email Address *

Phone Number *

Account Status

style="width: 20px; height: 20px; margin-right: 10px; cursor: pointer;"> Email Verified Member has verified their email address

style="width: 20px; height: 20px; margin-right: 10px; cursor: pointer;"> Payment Completed Mark as paid after verifying payment proof (UTR/Reference Number)

style="width: 20px; height: 20px; margin-right: 10px; cursor: pointer;"> Account Approved Member can access survey sites after approval

Registration Details

Member ID:

Registered On:

⚠️ Important: Make sure to verify payment proof before marking as paid and approving the member. Check the UTR/Reference number from the payment screenshot sent to signupverification@paidsurveyhub.in

Cancel