-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.php
109 lines (109 loc) · 4.86 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
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
<?php
include('includes/header.php');
function getCat($con,$id){
$getCatQuery = "SELECT * FROM categories WHERE id='$id'";
mysqli_query($con,$getCatQuery);
$result = mysqli_query($con,$getCatQuery);
return $category = $result->fetch_assoc();
}
?>
<div class="container">
<div class="row" style="margin-top:50px">
<div class="col-md-8">
<div class="panel panel-default" style="padding:20px">
<?php
$limit = 5;
$start = 0;
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$start = ($page*5)-5;
$query = "SELECT * FROM articles LIMIT $start,$limit ";
mysqli_query($con,$query);
$result = mysqli_query($con,$query);
while($row = $result->fetch_assoc()):
?>
<?php
$category = getCat($con,$row['category_id']);
?>
<div class="media post">
<div class="image media-left">
<img src="admin/images/<?php echo $row['image'];?>" class="media-object" alt="" height="200" width="200">
</div>
<div class="media-body" style="padding:10px">
<h3 class="media-heading text-primary"><a href="viewPost.php?id=<?php echo $row['id'];?>"><?php echo $row['title'];?></a></h3>
<small class="text-danger"><i class="glyphicon glyphicon-time"></i> <?php echo $row['created'];?></small>
<small class="text-success"><i class="glyphicon glyphicon-tags"></i> <?php echo $category['name'];?></small>
<p class=""><?php echo substr($row['body'],0,150).'...';?></p>
</div>
</div>
<hr>
<?php
endwhile;
?>
<?php
$query = "SELECT COUNT(id) FROM articles";
$result = mysqli_query($con,$query);
$row = mysqli_fetch_row($result);
$total_records = $row[0];
$total_pages = ceil($total_records / $limit);
$links = "<nav class='text-center'><ul class='pagination'>";
$page = isset($_GET['page']) ? $_GET['page'] : 1;
for ($i=1; $i<=$total_pages; $i++) {
$active = $i == $page ? 'class="active"' : '';
$links .= "<li $active><a href='index.php?page=".$i."'>".$i."</a></li>";
};
echo $links . "</ul></nav>";
?>
</div>
</div>
<div class="col-md-4">
<ul class="list-group">
<li class="list-group-item li-nav">
Categories
</li>
<?php
$query = "SELECT * FROM categories";
if(mysqli_query($con,$query)):
$result = mysqli_query($con,$query);
while($row = $result->fetch_assoc()):
?>
<li class="list-group-item">
<a href="categoryPosts.php?id=<?php echo $row['id'];?>"><?php echo $row['name'];?></a>
</li>
<?php
endwhile;
endif;
?>
</ul>
</div>
<div class="col-md-4">
<ul class="list-group">
<li class="list-group-item li-nav">
Latest Posts
</li>
<li class="list-group-item">
<?php
$query = "SELECT * FROM articles order by created DESC LIMIT 5";
if(mysqli_query($con,$query)):
$result = mysqli_query($con,$query);
while($row = $result->fetch_assoc()):
?>
<div class="media">
<div class="image media-left">
<img src="admin/images/<?php echo $row['image'];?>" class="media-object" alt="" height="60" width="60">
</div>
<div class="media-body" style="padding:5px">
<h4 class="media-heading text-primary"><a href="viewPost.php?id=<?php echo $row['id'];?>"><?php echo $row['title'];?></a></h4>
<p class=""><?php echo substr($row['body'],0,20).'...';?></p>
</div>
</div>
<hr>
<?php
endwhile;
endif;
?>
</li>
</ul>
</div>
</div>
</div>
<?php include('includes/footer.php');?>