info2180-project4/message.php at master · Kimberleyieshaa/info2180-project4 · GitHub

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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
<?php
	/*connect to database*/
	require "connect.php";

	/*Resume user session*/
	session_start();

	//Check if user is logged in
	if (isset($_SESSION['id'])) {
		//set current user id
		$recipient_id = $_SESSION['id'];
		//set current message id
		$message_id = $_GET['id'];

		/*Get all the read messages*/
		$query = mysql_query("SELECT * FROM Message_read");

		/*Mark message as read*/
		$count = 1;
		while ($row = mysql_fetch_array($query)) {
			//Check if the message is already read
			if ($row['message_id'] == $message_id) {
				break;
			}
			$count++;
		}
		$total_query = mysql_query("SELECT * FROM Message_read");
		$total = 0;
		//Get the total number of read messages
		while ($row = mysql_fetch_array($total_query)) {
			$total++;
		}
		//If count exceeds total then mark the message as read
		if ($count > $total) {
			$mark_read = "INSERT INTO Message_read (message_id, reader_id) VALUES ('$message_id', '$recipient_id')";
			mysql_query($mark_read);
		}

		//get message contents
		$get_message = "SELECT * FROM Message WHERE id=$message_id";
?>

<!DOCTYPE html>
<html>
<head>
	<meta charst="UTF-8">
	<link rel="stylesheet" type="text/css" href="style.css">
	<script type="text/javascript" src="prototype.js"></script>
	<script src="script.js" type="text/javascript"> </script>
</head>
<body>
	<?php
		$row = mysql_fetch_array(mysql_query($get_message));
	?>
	<div class="subject"><?php echo $row['subject']; ?></div>
	<div class="body"><?php echo $row['body']; ?></div>

	<div id="reply">
		<form action="reply.php" method="post">
			Message: <input type="text" id="body" name="body" placeholder="Reply to message"><br>
			<input type="submit" value="reply">
			<input type="hidden" id="message_id" name="message_id" value=<?php echo $row['id']; ?>>
			<input type="hidden" id="subject" name="subject" value=<?php echo $row['subject']; ?>>
			<input type="hidden" id="recipient_id" name="recipient_id" value=<?php echo $row['user_id']; ?>>
		</form>
	</div>
</body>
</html>

<?php
	} else {
		echo "Please login to continue.";
	}
?>