prepare(" UPDATE users SET gender = ?, date_of_birth = ?, postcode = ?, status = ?, updated_at = NOW() WHERE id = ? "); $stmt->execute([$gender, $dob, $postcode, $status, $member_id]); logActivity($_SESSION['admin_id'], 'update_member', "Updated member #$member_id basic info", 'member', $member_id); $success = 'Member information updated successfully!'; } catch (Exception $e) { $error = 'An error occurred. Please try again.'; error_log("Update member error: " . $e->getMessage()); } } } if ($_POST['action'] === 'update_mobile') { $mobile = trim($_POST['mobile_number'] ?? ''); if (empty($mobile)) { $error = 'Mobile number is required'; } else { try { $panelPdo = getPanelDBConnection(); // Check if mobile verification record exists $checkStmt = $panelPdo->prepare("SELECT id FROM mobile_verifications WHERE user_id = ?"); $checkStmt->execute([$member_id]); $exists = $checkStmt->fetch(); if ($exists) { $stmt = $panelPdo->prepare(" UPDATE mobile_verifications SET mobile_number = ?, updated_at = NOW() WHERE user_id = ? "); $stmt->execute([$mobile, $member_id]); } else { $stmt = $panelPdo->prepare(" INSERT INTO mobile_verifications (user_id, mobile_number) VALUES (?, ?) "); $stmt->execute([$member_id, $mobile]); } logActivity($_SESSION['admin_id'], 'update_member', "Updated member #$member_id mobile number", 'member', $member_id); $success = 'Mobile number updated successfully!'; } catch (Exception $e) { $error = 'An error occurred. Please try again.'; error_log("Update mobile error: " . $e->getMessage()); } } } } // Fetch member details try { $panelPdo = getPanelDBConnection(); $stmt = $panelPdo->prepare(" SELECT u.*, mv.mobile_number, mv.is_verified as mobile_verified FROM users u LEFT JOIN mobile_verifications mv ON u.id = mv.user_id WHERE u.id = ? "); $stmt->execute([$member_id]); $member = $stmt->fetch(); if (!$member) { header('Location: members.php'); exit; } } catch (Exception $e) { error_log("Fetch member error: " . $e->getMessage()); header('Location: members.php'); exit; } include 'includes/header.php'; ?>

Edit Member

Update member information for #

👁️ View Details ← Back to List
✅
⚠️

Basic Information

Email cannot be changed

Mobile Number

✓ Verified Not verified

Account Information

✓ Yes' : '✗ No'; ?>

✓ Yes' : '⏳ No'; ?>