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); }