-
Notifications
You must be signed in to change notification settings - Fork 5
/
search.php
86 lines (75 loc) · 2.5 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
<?php
require_once('funs.php');
session_start();
check_session();
$session_name = $_SESSION['username'];
$row = array();
$row = get_member_data($session_name);
$id = $row['id'];
$name = $row['name'];
$role = $row['role'];
$pic = $row['pic'];
$last_login = $row['last_login'];
$last_login = date('jS M Y H:i', strtotime($last_login));
$total_members = get_all_status();
$core_members = get_vip_status();
$total_sessions = total_sessions();
$completed_sessions = completed_sessions();
starter($id,$name,$role,$pic,$last_login,$total_members,$core_members,$total_sessions,$completed_sessions);
$key = $_POST['term'];
$query = "SELECT * FROM blog_posts WHERE postTitle LIKE '%".$key."%' OR description LIKE '%".$key."%' OR content LIKE '%".$key."%'";
$result = mysqli_query($con,$query);
?>
<div class="row">
<ol class="breadcrumb">
<li><a href="home.php"><i class="fa fa-home" aria-hidden="true"></i></a></li>
<li class="active">Search</li>
</ol>
</div><!--/.row-->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">Search Results for <u><?php echo $key; ?></u></h1>
</div>
</div><!--/.row-->
<div class="row">
<?php
if(mysqli_num_rows($result) == 0)
{
echo '<br><div class="text-center alert bg-warning col-lg-offset-2 col-lg-5"><span><b>Sorry, no results found</b></span></div>';
}
if(mysqli_num_rows($result) > 0)
{
$select = 1;
while($row = mysqli_fetch_assoc($result))
{
if($select%2 == 1)
{
$css = 'panel-teal';
}
else
{
$css = 'panel-orange';
}
?>
<div class="col-lg-4">
<div class="panel <?php echo $css; ?>">
<div class="panel-body">
<a href="viewpost.php?id=<?php echo $row['id']; ?>&title=<?php echo $row['postTitle']; ?>" style="color: #fff;">
<h3 style="color: #fff;"><?php echo $row['postTitle']; ?></h3>
<a href="viewpost.php?id=<?php echo $row['id']; ?>&title=<?php echo $row['postTitle']; ?>" style="color: #fff;">
<p>Posted by <b><?php echo $row['auther']; ?></b> on <b><?php echo date('jS M Y H:i:s', strtotime($row['post_date'])); ?></b> in
<b><a style="color: #fff;" href="viewbycat.php?cat=<?php echo $row['catinfo']; ?>"><?php echo $row['catinfo']; ?></a></b></p>
<p><a style="color: #fff;" href="viewbycat.php?cat=<?php echo $row['catinfo']; ?>"><?php echo $row['description']; ?></a></p>
</a>
</a>
</div>
</div>
</div>
<?php
$select++;
}
}
?>
</div><!--/.row-->
<?php
at_bottom();