How can a PHP user limit the number of posts a user can make within a 24-hour period?

To limit the number of posts a user can make within a 24-hour period, you can store the user's post timestamps in a database and check against them before allowing a new post. If the user has exceeded the limit, you can prevent them from making additional posts. 

// Connect to database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Get current user ID
$user_id = 123;

// Define post limit and time window
$post_limit = 5;
$time_window = 24 * 60 * 60; // 24 hours in seconds

// Check if user has exceeded post limit within time window
$stmt = $pdo->prepare("SELECT COUNT(*) FROM posts WHERE user_id = :user_id AND created_at >= NOW() - INTERVAL :time_window SECOND");
$stmt->bindParam(':user_id', $user_id, PDO::PARAM_INT);
$stmt->bindParam(':time_window', $time_window, PDO::PARAM_INT);
$stmt->execute();
$post_count = $stmt->fetchColumn();

if ($post_count >= $post_limit) {
    echo "You have exceeded the maximum number of posts allowed within a 24-hour period.";
} else {
    // Allow user to make a new post
    // Insert new post into database
}

Keywords

PHP limit posts 24-hour period user

Related Questions