protected static function getUserId($username)
{
$conn = DbHandler::getConnection();
$query = "SELECT id FROM users WHERE username = '******'";
$user_id = $conn->querySingle($query);
return $user_id;
}
public static function insertMessage($user_id, $chat_id, $message)
{
$conn = DbHandler::getConnection();
$query = "INSERT INTO messages (chat_id, user_id, message, insert_time) " . "VALUES (" . $conn->escapeString($chat_id) . ", " . $conn->escapeString($user_id) . ", '" . $conn->escapeString($message) . "', " . $conn->escapeString(getMicrotime()) . ")";
$conn->exec($query);
UserHandler::setUserActivity();
return true;
}
<?php
/**
* Created by PhpStorm.
* User: Kristaps
* Date: 11/27/2015
* Time: 1:15 AM
*/
require_once "handlers/SessionsHandler.php";
SessionsHandler::startSession();
SessionsHandler::checkAccess("chatroom.php");
require_once "handlers/DbHandler.php";
$conn = DbHandler::getConnection();
require_once "handlers/ChatHandler.php";
require_once "handlers/UserHandler.php";
$chatroom_name = UserHandler::getUsername(ChatHandler::PUBLIC_CHAT_ID);
$username = UserHandler::getCurrentUserName();
require_once "header.php";
?>
<div id="chat">
<div id="chat-content">
<div style="header">
<h1 id="topic">
ChatRoom :: <span id="chat_name"><?php
echo $chatroom_name;
?>
</span>
</h1>
click on user for private chat
<div id="logout">
<a href="operations.php?action=logout" class="button">
protected static function updateChatActivity($user_id, $chat_id)
{
$conn = DbHandler::getConnection();
$query = "UPDATE user_chat_rel SET last_activity = " . $conn->escapeString(getMicrotime()) . " " . "WHERE user_id = " . $conn->escapeString($user_id) . " AND chat_id = " . $conn->escapeString($chat_id);
$conn->exec($query);
}
