-
Notifications
You must be signed in to change notification settings - Fork 152
/
topics.php
143 lines (117 loc) · 4.88 KB
/
topics.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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<?php
session_start();
require 'includes/dbh.inc.php';
define('TITLE',"Forums | KLiK");
if(!isset($_SESSION['userId']))
{
header("Location: login.php");
exit();
}
include 'includes/HTML-head.php';
?>
<link rel="stylesheet" type="text/css" href="css/list-page.css">
</head>
<body style="background: #f1f1f1">
<?php
include 'includes/navbar.php';
if(isset($_GET['cat']))
{
$sql = "select * from categories "
. "where cat_id = ?";
$stmt = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($stmt, $sql))
{
die('SQL error');
}
else
{
mysqli_stmt_bind_param($stmt, "s", $_GET['cat']);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$category = mysqli_fetch_assoc($result);
}
}
?>
<main role="main" class="container">
<div class="d-flex align-items-center p-3 my-3 text-white-50 bg-purple rounded shadow-sm">
<img class="mr-3" src="img/200.png" alt="" width="48" height="48">
<div class="lh-100">
<h1 class="mb-0 text-white lh-100">KLiK Forums</h1>
<small>Spreading Ideas</small>
</div>
</div>
<div class="my-3 p-3 bg-white rounded shadow-sm">
<h5 class="border-bottom border-gray pb-2 mb-0">
<?php
if(isset($_GET['cat']))
{
echo '<a href="forum.php">Forums</a>
/ <span style="color: #709fea ">'.ucwords($category['cat_name'])."</span>";
}
else
{
echo 'All Forums';
}
?>
</h5>
<?php
$sql = "select topic_id, topic_subject, topic_date, topic_cat, topic_by, userImg, idUsers, uidUsers, cat_name, (
select sum(post_votes)
from posts
where post_topic = topic_id
) as upvotes
from topics, users, categories
where ";
if(isset($_GET['cat']))
{
$sql .= "topic_cat = " . $_GET['cat'] . " and ";
}
$sql .= "topics.topic_by = users.idUsers
and topics.topic_cat = categories.cat_id
order by topic_id asc ";
$stmt = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($stmt, $sql))
{
die('SQL error');
}
else
{
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
while ($row = mysqli_fetch_assoc($result))
{
echo '<a href="posts.php?topic='.$row['topic_id'].'">
<div class="media text-muted pt-3">
<img src="img/forum-cover.png" alt="" class="mr-2 rounded div-img">
<p class="media-body pb-3 mb-0 small lh-125 border-bottom border-gray">
<strong class="d-block text-gray-dark">'.ucwords($row['topic_subject']).'</strong></a>
<span class="text-warning">'.ucwords($row['uidUsers']).'</span><br><br>
'.date("F jS, Y", strtotime($row['topic_date'])).'
</p>
<span class="text-primary text-center">
<i class="fa fa-chevron-up" aria-hidden="true"></i><br>
'.$row['upvotes'].'<br>';
if ($_SESSION['userLevel'] == 1 || $_SESSION['userId'] == $row['idUsers'])
{
echo '<a href="includes/delete-forum.php?id='.$row['topic_id'].'&page=topics" >
<i class="fa fa-trash" aria-hidden="true" style="color: red;"></i>
</a>
</span>';
}
else
{
echo '</span>';
}
echo '</span>
</div>';
}
}
?>
<small class="d-block text-right mt-3">
<a href="create-topic.php" class="btn btn-primary">Create A Forum</a>
</small>
</div>
</main>
<?php include 'includes/footer.php'; ?>
</body>
</html>