-
Notifications
You must be signed in to change notification settings - Fork 0
/
category_post.php
87 lines (69 loc) · 2.51 KB
/
category_post.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
<?php
include "includes/header.php";
?>
<main role="main">
<!-- "The HTML <main> element represents the main content of the <body> of a document, portion of a document, or application.
The main content area consists of content that is directly related to, or expands upon the central topic of, a document or the central functionality of an application."
For more information: https://developer.mozilla.org/en-US/docs/Web/HTML/Element/main
-->
<!-- Main jumbotron for a primary marketing message or call to action -->
<div class="jumbotron">
<div class="container">
<h1 class="display-3">ForceCMS: Category Posts</h1>
</div>
</div>
<div class="container">
<!-- Example row of columns -->
<div class="row">
<div class="col-md-9">
<?php
if (isset($_GET['c_id'])) {
//Posts are displayed only if they are published
$sql = "SELECT * FROM posts WHERE post_status = 'published' AND post_cat_id = " . $_GET['c_id'];
}
else {
//Posts are displayed only if they are published
$sql = "SELECT * FROM posts WHERE post_status = 'published'";
}
$retrieve_post_result = $conn->query($sql);
if ($retrieve_post_result->num_rows > 0) {
while ($row = $retrieve_post_result->fetch_assoc()) {
$post_id = $row['post_id'];
$post_title = $row['post_title'];
$post_author = $row['post_author'];
$post_date = explode(" ",$row['post_date']);
$post_image = $row['post_image'];
$post_content = create_paragraphs_from_DBtext($row['post_content']);
$post_status = $row['post_status'];
?>
<article>
<h3><a href="posts.php?p_id=<?php echo $post_id; ?>"><?php echo $post_title; ?></a></h3>
<p class="text-secondary small space-top-bottom">Posted by <a href=""><?php echo $post_author; ?></a> on <span class="text-primary"><?php echo $post_date[0]; ?></span></p>
<?php
//Show the post image only if one has been set.
if ($post_image != "") {
?>
<img class="col-md-4 col-no-left-padding" src="images/<?php echo $post_image; ?>" alt="">
<?php
}
?>
<p><?php echo $post_content; ?></p>
<p><a class="btn btn-secondary" href="posts.php?p_id=<?php echo $post_id; ?>" role="button">View details »</a></p>
</article>
<hr class="space-top-bottom">
<?php
}
}
?>
</div>
<div class="col-md-3">
<?php
/* Panel containing the login form and report issues link */
include "includes/panel.php";
?>
</div>
</div>
<hr>
</div> <!-- /end main container -->
</main>
<?php include "includes/footer.php"; ?>