How can PHP be used to create a private messaging system for registered users on a website?

To create a private messaging system for registered users on a website using PHP, you can set up a database table to store messages between users. Each message should have fields for sender, recipient, message content, and timestamp. Then, you can create PHP scripts to handle sending, receiving, and displaying messages between users. 

// Assuming you have a database connection established

// Function to send a message
function sendMessage($sender, $recipient, $message) {
    // Insert message into the database
    $sql = "INSERT INTO messages (sender, recipient, message, timestamp) VALUES ('$sender', '$recipient', '$message', NOW())";
    $result = mysqli_query($conn, $sql);
    if ($result) {
        return true;
    } else {
        return false;
    }
}

// Function to retrieve messages for a specific user
function getMessages($user) {
    // Retrieve messages from the database
    $sql = "SELECT * FROM messages WHERE recipient='$user' ORDER BY timestamp DESC";
    $result = mysqli_query($conn, $sql);
    $messages = [];
    while ($row = mysqli_fetch_assoc($result)) {
        $messages[] = $row;
    }
    return $messages;
}

Keywords

PHP private messaging system registered users website authentication

Related Questions