Code-Helper-Blog/blog.php at main · Armanidrisi/Code-Helper-Blog · 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
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
144
145
146
147
148
149
150
151
152
153
<?php
//Including The Config Fail
include('includes/config.php'); // Include Config File Of Site
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
<meta name="description" content="" />
<meta name="author" content="Arman Idrisi" />
<title>Home - <?php echo $sitename; ?></title>
<link rel="icon" type="image/x-icon" href="assets/favicon.ico" />
<!-- Font Awesome icons (free version)-->
<script src="https://use.fontawesome.com/releases/v6.1.0/js/all.js" crossorigin="anonymous"></script>
<!-- Google fonts-->
<link href="https://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic" rel="stylesheet" type="text/css" />
<link href="https://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800" rel="stylesheet" type="text/css" />
<!-- Core theme CSS (includes Bootstrap)-->
<link href="css/styles.css" rel="stylesheet" />
</head>
<body>
<!-- Navigation-->
<?php
//Including Navbar From navbar.php

include('includes/navbar.php'); //Include The Navbar Component From navbar.php
?>
<!-- Page Header-->

<!-- Main Content-->
<div class="container px-4 px-lg-5 mt-4">
<div class="row gx-4 gx-lg-5 justify-content-center">
<h3 class="text-center mb-4 mt-4">Welcome To <?php echo $sitename; ?> Blog</h3>
<hr />
<div class="col-md-10 col-lg-8 col-xl-7">
<!-- Post preview-->
<?php

//Adding Pagination Logic For Showing Posts

$result_per_page = 3; //Number Of Entries Show in a Page

//Get The Page Number From Get Request

if (isset($_GET["page"])) {
$page = $_GET["page"];
} else {
$page = 1;
}

$start_from = ($page-1) * $result_per_page;


//Fetching The Posts From Database And Showing On homepage

$sql = "SELECT * FROM tbl_posts ORDER BY id DESC LIMIT $start_from,$result_per_page";
$query = $conn->query($sql);
while ($data = $query->fetch_assoc()) {
$title = $data['post_title'];
$content = substr($data['post_content'], 0, 200);
$author = $data['post_author'];
$slug = $data['post-slug'];
$date = date_create($data['post_date']);
$df = date_format($date, "d-M-Y");
echo "<div class='post-preview'>
<h3>
$title
</h3>
<p class='post-subtitle'>
$content..........
</p>

<p class='post-meta'>
By $author - $df
</p>
<a class='btn btn-primary' href='blogpost.php?post=$slug'>Read More →</a>
</div><hr class='my-4'>";
//print_r($data);
}
?>
<!-- Divider
<hr class="my-4" />-->
<!-- Pager-->
<?php
//pagination logic for buttons

//Sql Query: For Getting Total Records row
$psql = "SELECT COUNT(*) FROM tbl_posts";
$rs_result = $conn->query($psql);
$row = $rs_result->fetch_row();
$total_rec = $row[0];

//Number Of Pages Required

$total_pages = ceil($total_rec / $result_per_page);
$pagLink = "";


echo "<div class = 'd-flex justify-content-center mb-4'><nav><ul class='pagination'>";

//Adding Previous Button If Page Greater Then 2

if ($page >= 2) {
$href = $page-1;
echo"
<li class='page-item'><a class='page-link' href='blog.php?page=$href'>Previous</a></li>";
}

//Creating All Number Of Buttons

for ($i = 1; $i < $total_pages; $i++) {
if ($i == $page) {
$pagLink .= "<li class='page-item active'><a class='page-link' href='blog.php?page=$i'>$i</a></li>";
} else {
$pagLink .= "<li class='page-item'><a class='page-link' href='blog.php?page=$i'>$i</a></li>";
}
}

//echo"<li class='page-item'><a class='page-link' href='#'>1</a></li>";
echo $pagLink;


//Adding The Next Button

if ($page < $total_pages) {
$pa = $page+1;
echo"
<li class='page-item'><a class='page-link' href='blog.php?page=$pa'>Next</a></li>";
}


echo"</ul>
</nav>

</div>"; ?>
</div>
</div>
</div>
<!-- Footer-->
<?php
//Including footer From footer.php

include('includes/footer.php'); //Include The footer Component From footer.php
?>
<!-- Bootstrap core JS-->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
<!-- Core theme JS--> <script src="js/scripts.js">
</script>
</body>
</html>