-
Notifications
You must be signed in to change notification settings - Fork 0
/
search.php
104 lines (103 loc) · 5.78 KB
/
search.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
<?php
include 'header.php';
include 'config.php';
if (isset($_GET['search'])) {
$search_tram = mysqli_real_escape_string($con,$_GET['search']);
}
$limit = 3;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
else{
$page = 1;
}
$offset = ($page - 1) * $limit;
$select = "SELECT post.post_id,post.title,post.description,post.category,post.post_date,post.author,post.post_img,category.category_name,user.username FROM post LEFT JOIN category ON post.category = category.category_id LEFT JOIN user ON post.author = user.user_id
WHERE post.title LIKE '%{$search_tram}%' OR post.description LIKE '%{$search_tram}%' OR category.category_name LIKE '%{$search_tram}%' OR user.username LIKE '%{$search_tram}%'
ORDER BY post.post_id DESC LIMIT {$offset},{$limit}";
$query = mysqli_query($con,$select);
?>
<div id="main-content">
<div class="container">
<div class="row">
<div class="col-md-8">
<!-- post-container -->
<div class="post-container">
<h2 class="page-heading">Search : <?php echo $search_tram; ?></h2>
<?php
if (mysqli_num_rows($query) > 0) {
while ($row = mysqli_fetch_assoc($query)) {
?>
<div class="post-content">
<div class="row">
<div class="col-md-4">
<a class="post-img" href="single.php?id=<?php echo $row['post_id'];?>"><img src="admin/upload/<?php echo $row['post_img']; ?>" alt="<?php echo $row['title'];?>"/></a>
</div>
<div class="col-md-8">
<div class="inner-content clearfix">
<h3><a href='single.php?id=<?php echo $row['post_id'];?>'><?php echo $row['title'];?></a></h3>
<div class="post-information">
<span>
<i class="fa fa-tags" aria-hidden="true"></i>
<a href='category.php?cid=<?php echo $row['category'];?>'><?php echo $row['category_name'];?></a>
</span>
<span>
<i class="fa fa-user" aria-hidden="true"></i>
<a href='author.php?aid=<?php echo $row['author'];?>'><?php echo $row['username'];?></a>
</span>
<span>
<i class="fa fa-calendar" aria-hidden="true"></i>
<?php echo $row['post_date'];?>
</span>
</div>
<p class="description">
<?php echo substr($row['description'],0,130)."...."?>
</p>
<a class='read-more pull-right' href='single.php?id=<?php echo $row['post_id'];?>'>read more</a>
</div>
</div>
</div>
</div>
<?php
}
}
else{
echo "Post not Found";
}
?>
<?php
// $user = "SELECT * FROM post WHERE post.title LIKE '%{$search_tram}%' OR post.description LIKE '%{$search_tram}%' OR post.category LIKE '%{$search_tram}%' OR user.username LIKE '%{$search_tram}%'";
// echo $user;
$user = "SELECT post.post_id,post.title,post.description,post.category,post.post_date,post.author,post.post_img,category.category_name,user.username FROM post LEFT JOIN category ON post.category = category.category_id LEFT JOIN user ON post.author = user.user_id
WHERE post.title LIKE '%{$search_tram}%' OR post.description LIKE '%{$search_tram}%' OR category.category_name LIKE '%{$search_tram}%' OR user.username LIKE '%{$search_tram}%'";
$query1 = mysqli_query($con,$user) or die("query unsussfully");
// $row1 = mysqli_fetch_assoc($query1);
if (mysqli_num_rows($query) > 0) {
$total_recourds = mysqli_num_rows($query1);
$total_pages = ceil($total_recourds / $limit);
echo "<ul class='pagination admin-pagination'>";
if ($page > 1) {
echo '<li><a href="search.php?search='.$search_tram.'&page='.($page - 1).'">Prev</li>';
}
for ($i = 1; $i <= $total_pages; $i++) {
if ($i == $page) {
$active = "active";
}
else{
$active = "";
}
echo "<li class='{$active}'><a href='search.php?search=".$search_tram."&page=".$i."'>".$i."</a></li>";
}
if ($total_pages > $page) {
echo '<li><a href="search.php?search='.$search_tram.'&page='.($page + 1).'">Next</a></li>';
}
echo "</ul>";
}
?>
</div>
</div>
<?php include 'sidebar.php'; ?>
</div>
</div>
</div>
<?php include 'footer.php'; ?>