-
Notifications
You must be signed in to change notification settings - Fork 5
/
guestbook.php
79 lines (71 loc) · 2.21 KB
/
guestbook.php
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
75
76
77
78
79
<?php
print('<div class="container">');
print('<div class="row">
<div class="col-lg-12 text-center">
<h1>Guestbook</h1>
</div>
</div>
<!-- /.row -->
');
global $db;
if(isset($_POST['entry']) && $_POST['entry'] != "") {
$id = $_SESSION['userid'];
$entry = $_POST['entry'];
$query = "select * from `users` where `id` = '$id' LIMIT 1";
$result = $db->query($query);
if ($row = $result->fetch_assoc()) {
$username = $row['username'];
}
$query = "INSERT INTO `guestbook` (`username`, `entry`) VALUES ('$username', '$entry');";
$result = $db->query($query);
$db->commit();
print('<div class="row">
<div class="col-lg-12 text-center">
Your entry was recorded.
</div>
</div>');
}
$id = $_SESSION['userid'];
$query = "select * from `guestbook` ORDER BY `id` DESC";
$result = $db->query($query);
if ($result->num_rows > 0) {
print('<table class="table table-striped table-responsive"><thead><tr><th>Author</th><th>Entry</th></tr></thead><tbody>');
while ($row = $result->fetch_assoc()) {
$username = $row['username'];
$entry = $row['entry'];
print('<tr><td>' . $username . '</td><td>' . $entry . '</td></tr>');
}
print('</tbody></table>');
} else {
print('<div class="row">
<div class="col-lg-12 text-center">
Sorry. There is nothing here!
</div>
</div>
<!-- /.row -->
');
}
if(logged_in()) {
print('<div class="row">
<div class="col-lg-12 text-center">
<form action="#" method="POST">
<textarea class="form-control" rows="4" cols="50" name="entry" id="entry" value="entry" label="entry" placeholder="My entry ..."></textarea><br />
<input class="btn btn-default" type="submit" name="submit" id="submit" value="submit" label="submit" />
</form>
</div>
</div>
<!-- /.row -->
');
} else {
print('<div class="row">
<div class="col-lg-12 text-center">
Sorry. You need to log in to write something.
</div>
</div>
<!-- /.row -->
');
}
print('
</div>
<!-- /.container -->');
?>