-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsuggestions.php
39 lines (35 loc) · 1.07 KB
/
suggestions.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
<?php
include("includes/header.php");
?>
<link rel="stylesheet" href="css/view_suggestions.css" />
<title>Suggestions </title>
<?php
include("includes/nav.php");
?>
<?php
echo "<div class='suggestions-container'>";
include("includes/db.php");
$sqlquery = "SELECT * from suggestions";
$result = mysqli_query($conn,$sqlquery);
while($row=mysqli_fetch_assoc($result)){
$field = $row["category"];
$username = $row["username"];
$suggestion = $row["description"];
$created = $row["created"];
//echo "Category $field <br> $suggestion <br> Suggested by $username at $created<hr>";
echo "<div class='suggestion'>
<h3>Suggestion</h3>
<p>$suggestion</p>
<h5>Created by $username</h5><h6>at $created</h6>
</div>";
}
echo "</div>";
?>
<div class="create-button">
<a href="suggestionsup.php" class="button">Create</a>
</div>
</div>
<hr>
<?php include("includes/footer.php"); ?>
</body>
</html>