· 9 years ago · Nov 18, 2016, 03:02 PM
1<!DOCTYPE html>
2<html>
3<head lang="en">
4 <meta charset="UTF-8">
5 <meta name="viewport" content="width=device-width, minimum-scale=1, initial-scale=1, user-scalable=yes">
6 <title>Message Board</title>
7 <style>
8 body {
9 font: 12pt Arial, sans-serif;
10 background-color: #eee;
11 }
12
13 label, input, textarea {
14 display: block;
15 width: 100%;
16 margin-bottom: 5px;
17 }
18
19 #formContainer {
20 margin: auto;
21 width: 80%;
22 border-radius: 10px;
23 background-color: dodgerblue;
24 color: white;
25 padding: 16px;
26 }
27 .message {
28 background-color: white;
29 border-radius: 10px;
30 padding: 16px;
31 margin: 16px 0;
32 box-shadow: 0 2px 5px rgba(0, 0, 0, 0.2);
33 }
34 </style>
35</head>
36<body>
37
38<?php
39
40$connectionInfo = array(
41 "host" => "localhost",
42 "user" => "root",
43 "password" => "",
44 "db" => "mmn1617"
45);
46
47include_once('connectionInfo.private.php'); // TODO uncomment this.
48
49// connect to the database
50$c = mysqli_connect($connectionInfo['host'],
51 $connectionInfo['user'],
52 $connectionInfo['password'],
53 $connectionInfo['db']
54);
55
56
57// first create the table for the messages, if it doesn't exist
58$createTableQuery = "CREATE TABLE IF NOT EXISTS messages
59 (`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
60 `name` VARCHAR(20) NOT NULL DEFAULT 'anonymous',
61 `message` TEXT NOT NULL)";
62
63$createTableResult = mysqli_query($c, $createTableQuery);
64if (!$createTableResult) {
65 echo '<div>Could not create messages table</div>';
66}
67
68
69$alterTableQuery = "ALTER TABLE messages ADD title VARCHAR(512)";
70$horst = mysqli_query($c, $alterTableQuery);
71if ($horst) {
72 echo "<div> ALTER TABLE worked. </div>";
73} else {
74 // echo mysqli_error($c);
75}
76
77
78
79if (isset($_POST['name']) && isset($_POST['message'])) {
80 $name = $_POST['name'];
81 $message = $_POST['message'];
82 $title = $_POST['title'];
83
84 if (strlen($message) > 0) {
85 $insertMessageQuery = "INSERT INTO messages
86 (name,message,title) VALUES
87 ('$name','$message','$title')";
88 $insertResult = mysqli_query($c,
89 $insertMessageQuery);
90 if ($insertResult) {
91 echo "<div class='success'>
92 Message successfully inserted</div>";
93 }
94 } else {
95 echo "<div>Error: please enter a message</div>";
96 }
97}
98?>
99
100<div id="formContainer">
101 <form method="post">
102 <label>Your Name: <input type="text" name="name"></label>
103
104 <label>Title: <input type="text" name="title"></label>
105 <label>Message: <textarea name="message" required></textarea></label>
106
107 <input type="submit" name="submit" value="Save your message."/>
108 </form>
109</div>
110
111<?php
112$selectMessagesQuery = "SELECT * FROM messages ORDER BY `id` DESC";
113$messagesResult = mysqli_query($c, $selectMessagesQuery);
114
115while ($message = mysqli_fetch_assoc($messagesResult)) {
116 echo "<div class='message'>";
117 echo "<h2>{$message['name']}</h2>";
118 echo "<h3>{$message['title']}</h3>";
119 echo "<div>{$message['message']}</div>";
120 echo "</div>";
121}
122
123?>
124
125</body>
126</html>