How can the database be updated in real-time to reflect a user's banned status in a PHP web application?

To update the database in real-time to reflect a user's banned status in a PHP web application, you can use AJAX to send a request to a PHP script that updates the user's status in the database. This way, the user's status can be updated without needing to refresh the page. 

// AJAX request to update user's banned status
$.ajax({
    url: 'update_user_status.php',
    type: 'POST',
    data: { user_id: userId, banned: 1 }, // Set banned to 1 for banned status
    success: function(response) {
        // Handle success response
    },
    error: function(xhr, status, error) {
        // Handle error
    }
});
```

```php
// update_user_status.php
<?php
// Connect to database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Update user's banned status
$user_id = $_POST['user_id'];
$banned = $_POST['banned'];

$stmt = $pdo->prepare("UPDATE users SET banned = :banned WHERE id = :user_id");
$stmt->execute(array(':banned' => $banned, ':user_id' => $user_id));

// Return success response
echo "User status updated successfully";
?>

Keywords

PHP database real-time user status banned

Related Questions