Webbserv1: Källkod
Webbserverprogrammering 1

Show sourcecode

The following files exists in this folder. Click to view.

webbsrvprg/projects/slutprojekt/

blala.php
chat.php
createtable.php
delete.php
deletetable.php
deletetables.php
fetch_messages.php
filhantering/
footer.php
header.php
home.php
login.php
new_password.php
password_reset.php
profile.php
send_message.php
signup.php
verify.php

fetch_messages.php

32 lines ASCII Windows (CRLF)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<?php
session_start();
include('../../dbconnection.php');

if (!isset($_SESSION['id'], $_GET['receiverId'])) {
    exit;
}

$senderId = $_SESSION['id'];
$receiverId = $_GET['receiverId'];

$sql = "SELECT * FROM messages 
        WHERE (senderId = ? AND recieverId = ?) 
        OR (senderId = ? AND recieverId = ?)
        ORDER BY id ASC";

$stmt = $dbconn->prepare($sql);
$stmt->execute([$senderId, $receiverId, $receiverId, $senderId]);
$messages = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($messages as $message) {
    $picStmt = $dbconn->prepare("SELECT picture FROM pictures WHERE userId = ?");
    $picStmt->execute([$message['senderId']]);
    $pic = $picStmt->fetchColumn();

    if ($message['senderId'] == $senderId) {
        echo "<div class='message right'>{$message['message']}<img src='{$pic}' class='profile-img'></div><br>";
    } else {
        echo "<div class='message left'><img src='{$pic}' class='profile-img'>{$message['message']}</div><br>";
    }
}