-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpost.php
executable file
·128 lines (118 loc) · 5.52 KB
/
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
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
<?php
include("./library/db.php");
include("./library/function.php");
$site_data_qry = mysqli_query($conn, "SELECT * FROM `site_settings` Where id='1'");
$site_data = mysqli_fetch_assoc($site_data_qry);
$full_req = explode("/", $_GET['post']);
$postSlug = $full_req[1];
if (isset($postSlug)) {
$post_qry = mysqli_query($conn, "SELECT * FROM `posts` Where postSlug='$postSlug'");
$post_data = mysqli_fetch_assoc($post_qry);
} else {
header("location: ./index.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Custom Meta -->
<?= $post_data['post_meta'] ?>
<!-- Custom Meta End -->
<title><?= $post_data['post_title'] ?> - <?= $site_data['site_name'] ?></title>
<!-- CSS only -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-rbsA2VBKQhggwzxH7pPCaAqO46MgnOM80zW1RWuH61DGLwZJEdK2Kadq2F9CUG65" crossorigin="anonymous">
<link rel="stylesheet" href="<?= $baseurl ?>assets/css/style.css">
<!-- Favicon -->
<link rel="apple-touch-icon" sizes="57x57" href="<?= $baseurl ?>assets/img_site/fav/apple-touch-icon.png">
<link rel="apple-touch-icon" sizes="60x60" href="<?= $baseurl ?>assets/img_site/fav/apple-touch-icon.png">
<link rel="apple-touch-icon" sizes="72x72" href="<?= $baseurl ?>assets/img_site/fav/apple-touch-icon.png">
<link rel="apple-touch-icon" sizes="76x76" href="<?= $baseurl ?>assets/img_site/fav/apple-touch-icon.png">
<link rel="icon" type="image/png" sizes="192x192" href="<?= $baseurl ?>assets/img_site/fav/android-chrome-192x192.png">
<link rel="icon" type="image/png" sizes="512x512" href="<?= $baseurl ?>assets/img_site/fav/android-chrome-512x512.png">
<link rel="icon" type="image/png" sizes="32x32" href="<?= $baseurl ?>assets/img_site/fav/favicon-32x32.png">
<link rel="icon" type="image/png" sizes="96x96" href="<?= $baseurl ?>assets/img_site/fav/favicon.ico">
<link rel="icon" type="image/png" sizes="16x16" href="<?= $baseurl ?>assets/img_site/fav/favicon-16x16.png">
<meta name="theme-color" content="#ffffff">
<!-- Fav End -->
<style>
img {
max-width: 100%;
max-height: auto;
}
</style>
</head>
<body>
<header>
<?php include("./library/includes/navbar.php") ?>
</header>
<section id="main_story">
<div class="container mt-5">
<div class="row gx-2 gy-2">
<div class="col-md-8">
<div class="card">
<div class="card-body">
<div class="card-title border-bottom border-dark mb-2">
<h1 class="text-dark">
<?= $post_data['post_title'] ?>
</h1>
<h6><b class="badge bg-primary">
<?= cat_fatcher($conn, $post_data['post_cat']) ?>
</b> <span class="text-muted">
<?= timeStraper($post_data['time']) ?>
</span></h6>
</div>
<div class="post_text">
<?= $post_data['post_details'] ?>
</div>
</div>
</div>
</div>
<div class="col-md-4">
<div class="text-center">
<h4>Related Topics</h4>
</div>
<?php
$post_r_cat = $post_data['post_cat'];
$sql_r_topic = $conn->query("SELECT * FROM `posts` Where post_cat='$post_r_cat' AND types='1' Order by time DESC Limit 8");
if ($sql_r_topic->num_rows > 1) {
while ($r_post = $sql_r_topic->fetch_assoc()) {
if ($r_post['post_id'] == $post_data['post_id']) {
continue;
}
?>
<a href="<?= $baseurl ?>post/<?= catStraper($conn, $r_post['post_cat']) ?>/<?= $r_post['postSlug'] ?>"
class="text-decoration-none text-dark">
<div class="alert alert-secondary mb-2">
<h4 class="fs-4 text-truncate">
<?= $r_post['post_title'] ?>
</h4>
<span>
<?= timeStraper($r_post['time']) ?>
</span>
</div>
</a>
<?php
}
} else {
?>
<div class="alert alert-warning mb-2">
<h2 class="fs-4">This category doesn't contain any related posts.</h2>
</div>
<?php
}
?>
</div>
</div>
</div>
</section>
<br><br>
<!-- JavaScript Bundle with Popper -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"
integrity="sha384-kenU1KFdBIe4zVF0s0G1M5b4hcpxyD9F7jL+jjXkk+Q2h455rYXK/7HAuoJl+0I4"
crossorigin="anonymous"></script>
</body>
</html>