How can PHP be used to limit the number of sign-ups per group on a website?

To limit the number of sign-ups per group on a website using PHP, you can track the number of sign-ups for each group in a database and compare it to a predefined limit. If the limit is reached, prevent further sign-ups for that group.

// Assume $group_id is the ID of the group being signed up for
// Assume $max_signups is the maximum number of sign-ups allowed per group

// Check the number of sign-ups for the group
$signup_count = $db->query("SELECT COUNT(*) FROM signups WHERE group_id = $group_id")->fetchColumn();

// If the maximum sign-ups limit is reached, prevent further sign-ups
if ($signup_count >= $max_signups) {
    echo "Sorry, this group has reached its maximum sign-up limit.";
    exit;
}

// If the limit is not reached, proceed with the sign-up process
// Insert new sign-up record into the database
$db->query("INSERT INTO signups (group_id, user_id) VALUES ($group_id, $user_id)");
echo "Sign-up successful!";