Pantheon/category.php at main · maugus0/Pantheon · GitHub

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
<?php include "root/db.php" ?>
<?php include "root/header.php" ?>
	<!-- Preloader -->
	<div class="preeloader">
		<div class="preloader-spinner"></div>
	</div>
	<!-- End Preloader -->

	<!-- Color Plate -->
	<div class="color-plate ">
		<a class="color-plate-icon"><i class="fa fa-cog fa-spin"></i></a>
		<h4>Pantheon Deepsight</h4>
		<p>Here are same other awesome theme colors.</p>
		<span class="color1"></span>
		<span class="color2"></span>
		<span class="color3"></span>
		<span class="color4"></span>
	</div>
	<!-- /End Color Plate -->
    <!--Navigation-->
	<?php include "root/nav2.php" ?>
    <!--Breadcrumbs-->
    <div class="breadcrumbs">
		<div class="container">
			<div class="row">
				<div class="col-12">
					<div class="bread-inner">
						<ul class="bread-list">
							<li><a href="index.php">Home<i class="lni lni-arrow-right"></i></a></li>
							<li class="active"><a href="blog.php">Blog Posts</a></li>
						</ul>
					</div>
				</div>
			</div>
		</div>
	</div>
    <!--Blog Posts-->
    <!-- Start Blog Area -->
	<section class="blog section" id="blog">
		<div class="container">
			<?php include "root/searchbar.php"; ?>
			<div class="row">
            <?php
             if(isset($_GET['category'])) {
              $post_category_id = $_GET['category'];
             }
             $query = "SELECT * FROM posts WHERE post_category_id = {$post_category_id}";
             $select_all_posts_query = mysqli_query($connection,$query);
                while($row = mysqli_fetch_assoc($select_all_posts_query)) {
                 $post_id = $row['post_id'];
                 $post_title = $row['post_title'];
                 $post_author = $row['post_author'];
                 $post_date = $row['post_date'];
                 $post_image = $row['post_image'];
                 $post_content = $row['post_content'];
                 $post_status = $row['post_status'];
                 $post_desc = $row['post_desc'];
                 if ($post_status == 'Published') {
            ?>
				<div class="col-lg-4 col-md-6 col-12">
					<!-- Single Blog -->
					<div class="single-news">
						<div class="news-head">
							<img src="img/<?php echo $post_image; ?>" alt="#">
						</div>
						<div class="news-body">
							<div class="news-content">
								<div class="date"><?php echo $post_date; ?> | By <?php echo $post_author; ?></div>
								<h2><a href="bposts.php?p_id=<?php echo $post_id; ?>"><?php echo $post_title; ?></a></h2>
								<p class="text"><?php echo $post_desc; ?></p>
							</div>
						</div>
					</div>
					<!-- End Single Blog -->
				</div>
				<?php } } ?>
			</div>
		</div>
	</section>
	<!-- End Blog Area -->
    <!--Footer-->
    <?php include "root/footer.php" ?>