-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.php
60 lines (51 loc) · 1.56 KB
/
index.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
<?php
include 'inc/header.php';
include 'inc/slider.php';
?>
<div class="contentsection contemplete clear">
<div class="maincontent clear">
<!-- pagination -->
<?php
$per_page = 3;
if(isset($_GET['page'])){
$page = $_GET['page'];
}else{
$page = 1;
}
$start_form = ($page -1) * $per_page;
?>
<!-- pagination -->
<?php
$query = "SELECT * FROM tbl_post LIMIT $start_form, $per_page";
$post = $db->select($query);
if($post){
while($result = $post->fetch_assoc()){
?>
<div class="samepost clear">
<h2><a href="post.php?id=<?php echo $result['id'] ?>">
<?php echo $result['title'] ?></a></h2>
<h4><?php echo $fm->formaDate($result['date'] ) ?> By
<a href="#"><?php echo $result['author'] ?></a></h4>
<a href="#"><img src="admin/<?php echo $result['image']?>" alt="post image"/></a>
<p> <?php echo $fm->textShroten($result['body'] ) ?></p>
<div class="readmore clear">
<a href="post.php?id=<?php echo $result['id'] ?>">Read More</a>
</div>
</div>
<?php } ?> <!--end while loop -->
<!-- pagination -->
<?php
$query = "SELECT * FROM tbl_post";
$result = $db->select($query);
$total_rows = mysqli_num_rows($result);
$total_pages = ceil($total_rows / $per_page);
echo "<span class='pagination'><a href='index.php?page=1'>".'First Page'."</a>";
for($i = 1; $i <= $total_pages; $i++){
echo "<a href='index.php?page=".$i."'>".$i."</a>";
}
echo "<a href='index.php?page=$total_pages'>".'Last Page'."</a></span>" ?>
<!-- pagination -->
<?php } else { header("location:404.php"); } ?>
</div>
<?php include 'inc/sidebar.php' ?>
<?php include 'inc/footer.php' ?>