getConnection(); // Build query $sql = "SELECT * FROM users WHERE 1=1"; $params = []; if ($search) { $sql .= " AND (name LIKE ? OR email LIKE ? OR mobile LIKE ? OR registration_id LIKE ?)"; $params[] = "%$search%"; $params[] = "%$search%"; $params[] = "%$search%"; $params[] = "%$search%"; } if ($status) { $sql .= " AND status = ?"; $params[] = $status; } if ($user_type) { $sql .= " AND user_type = ?"; $params[] = $user_type; } if ($membership) { $sql .= " AND membership_type = ?"; $params[] = $membership; } // Get total count $count_sql = str_replace("SELECT *", "SELECT COUNT(*)", $sql); $stmt = $db->prepare($count_sql); $stmt->execute($params); $total_records = $stmt->fetchColumn(); $total_pages = ceil($total_records / $limit); // Get users with pagination $sql .= " ORDER BY created_at DESC LIMIT ? OFFSET ?"; $params[] = $limit; $params[] = $offset; $stmt = $db->prepare($sql); $stmt->execute($params); $users = $stmt->fetchAll(); ?>

Users Management

Complete CRUD operations for all users ( total)

Advanced Search & Filter
All Users
ID Name Email Mobile Membership Status Type Joined Actions
1): ?>