-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsearch-result.php
89 lines (88 loc) · 6.05 KB
/
search-result.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
<?php include 'components/authentication.php' ?>
<?php include 'components/session-check.php' ?>
<?php include 'controllers/base/head.php' ?>
<?php include 'controllers/navigation/first-navigation.php' ?>
<?php
if($_POST){
$query=$_POST['search-form'];
$sql=mysqli_query($database,"select * from user where user_firstname like '%$query%' or user_lastname like '%$query%' order by user_id");
$number=mysqli_num_rows($sql);
}
?>
<div id="content">
<div class="row">
<div class="col-md-12">
<div class="panel panel-default" style="margin: 20px 0px;">
<div class="panel-heading">
<?php
if($number > 1){
?>
<h3 class="panel-title"><?php echo $number; ?> Results for "<?php echo $query; ?>"</h3>
<?php
}
else{
?>
<h3 class="panel-title"><?php echo $number; ?> Result for "<?php echo $query; ?>"</h3>
<?php
}
?>
</div>
<div class="panel-body">
<div class="row">
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div class="row clearfix">
<?php
if($_POST){
$query=$_POST['search-form'];
$sql=mysqli_query($database,"select * from user where user_firstname like '%$query%' or user_lastname like '%$query%' order by user_id");
if( mysqli_num_rows($sql) > 0) {
while($rws = mysqli_fetch_array($sql)){
?>
<div class="panel-group" id="panel-<?php echo $rws['user_id']; ?>">
<div class="panel panel-default">
<div class="panel-heading">
<a class="panel-title" data-toggle="collapse" data-parent="#panel-<?php echo $rws['user_id']; ?>" href="#panel-element-<?php echo $rws['user_id']; ?>"><?php echo $rws['user_firstname'];?> <?php echo $rws['user_lastname'];?><button type="button" class="close" data-dismiss="panel"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button></a>
</div>
<div id="panel-element-<?php echo $rws['user_id']; ?>" class="panel-collapse collapse in">
<div class="panel-body">
<div class="col-md-6 column">
<img src="userfiles/avatars/<?php echo $rws['user_avatar'];?>" name="aboutme" class="img-responsive">
</div>
<div class="col-md-6 column">
<div class="col-md-12 column">
<h2><span><?php echo $rws['user_firstname'];?> <?php echo $rws['user_lastname'];?></span></h2>
<hr>
<p><?php echo $rws['user_shortbio'];?></p>
<hr>
</div>
<div class="col-md-4 column">
<a href="profile.php?user_username=<?php echo $rws['user_username'];?>"><button type="button" class="btn btn-primary">View</button></a>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
}
}
else{
?>
<center>
<h1>No Results to show</h1>
</center>
<?php
}
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>