-
Notifications
You must be signed in to change notification settings - Fork 0
/
search.php
112 lines (104 loc) · 5.51 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
105
106
107
108
109
110
111
112
<?php include 'header.php'; ?>
<div id="main-content">
<div class="container">
<div class="row">
<div class="col-md-8">
<!-- post-container -->
<div class="post-container">
<?php
include "config.php";
if(isset($_GET['search'])){
$search_term = mysqli_real_escape_string($conn, $_GET['search']); // for securty purpose
?>
<h2 class="page-heading">Search : <?php echo $search_term; ?></h2>
<?php
/* Calculate Offset Code */
$limit = 3;
if(isset($_GET['page'])){
$page = $_GET['page'];
}else{
$page = 1;
}
$offset = ($page - 1) * $limit;
// Searching In Name as well as In Quality(Description) of product
$sql = "SELECT post.post_id, post.title, post.description,post.post_date,post.author,
category.category_name,user.username,post.category,post.post_img 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_term}%' OR post.description LIKE '%{$search_term}%'
ORDER BY post.post_id DESC LIMIT {$offset},{$limit}";
// search record from title as well as contain
$result = mysqli_query($conn, $sql) or die("Query Failed.");
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)) {
?>
<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=""/></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 "<h2>No Record Found.</h2>";
}
// show pagination
$sql1 = "SELECT * FROM post
WHERE post.title LIKE '%{$search_term}%'";
$result1 = mysqli_query($conn, $sql1) or die("Query Failed.");
if(mysqli_num_rows($result1) > 0){
$total_records = mysqli_num_rows($result1);
$total_page = ceil($total_records / $limit);
echo '<ul class="pagination admin-pagination">';
if($page > 1){
echo '<li><a href="search.php?search='.$search_term .'&page='.($page - 1).'">Prev</a></li>';
}
for($i = 1; $i <= $total_page; $i++){
if($i == $page){
$active = "active";
}else{
$active = "";
}
echo '<li class="'.$active.'"><a href="search.php?search='.$search_term .'&page='.$i.'">'.$i.'</a></li>';
}
if($total_page > $page){
echo '<li><a href="search.php?search='.$search_term .'&page='.($page + 1).'">Next</a></li>';
}
echo '</ul>';
}
}else{
echo "<h2>No Record Found.</h2>";
}
?>
</div><!-- /post-container -->
</div>
<?php include 'sidebar.php'; ?>
</div>
</div>
</div>
<?php include 'footer.php'; ?>