-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsearch.php
46 lines (36 loc) · 1.38 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
<?php include 'inc/header.php'; ?>
<?php
$search = mysqli_real_escape_string($db->link, $_GET['search']);
if (!isset($search) || $search == null) {
header("Location:404.php");
} else {
$search = $search;
}
?>
<div class="contentsection contemplete clear">
<div class="maincontent clear">
<?php
$query = "SELECT * FROM tbl_post WHERE tittle LIKE '%$search%' OR body LIKE '%$search%'";
$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['tittle']; ?></a></h2>
<h4><?php echo $fm->formatDate($result['date']); ?>, By <a href="#"><?php echo $result['author']; ?></a></h4>
<a href="#"><img src="admin/<?php echo $result['image']; ?>" alt="post image"/></a>
<?php echo $fm->textShorten($result['body']); ?>
<div class="readmore clear">
<a href="post.php?id=<?php echo $result['id']; ?>">Read More</a>
</div>
</div>
<?php
}
} else {
?>
<p>Your Search Query Not Found!!.</p>
<?php
} ?>
</div>
<?php include 'inc/sidebar.php'; ?>
<?php include 'inc/footer.php'; ?>