-
Notifications
You must be signed in to change notification settings - Fork 1
/
search_subcom.php
111 lines (83 loc) · 2.46 KB
/
search_subcom.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
<?php
include 'common.php';
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" >
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="index.css" rel="stylesheet" type="text/css"/>
<style>
.row_style{
margin-top:10px;
}
</style>
<title>N</title>
</head>
<body>
<?php
include 'header.php';
?><br><br>
<div class='container'>
<div class='row'>
<div class='col-md-3'>
<h2>subcommunities related</h2>
<?php
if(!empty($_POST)) {
$a=$_GET['id'];
$t = $_POST['search'];
$select_query = "SELECT * FROM subcommunities where c_id ='$a' and name like '%{$t}%'";
$select_query_result = mysqli_query($con, $select_query) or die(mysqli_error($con));
$total_rows_fetched = mysqli_num_rows($select_query_result);
if($total_rows_fetched==0){
echo 'NO REsults';
}
else {
while($row = mysqli_fetch_assoc($select_query_result)) {?>
<div class="card mb-4">
<img class="card-img-top" src="http://placehold.it/750x300" alt="Card image cap">
<div class="card-body">
<h2 class="card-title"><?php echo '<h2>'.$row['name'].'</h2>';?></h2>
<?php echo '<a href="subcomm.php?id='.$row['s_id'].'" class="btn btn-primary">explore</a> | ';
?>
</div>
</div>
<?php
}
}
}
?>
</div>
<div class='col-md-offset-5 col-md-3'>
<h2>THREADS RELATED</h2>
<?php
if(!empty($_POST)) {
$t = $_POST['search'];
$select_query = "SELECT * FROM threads where title='$t' or createdby='$t'";
$select_query_result = mysqli_query($con, $select_query) or die(mysqli_error($con));
$total_rows_fetched = mysqli_num_rows($select_query_result);
if($total_rows_fetched==0){
echo 'NO REsults';
}
else {
while($row = mysqli_fetch_assoc($select_query_result)) {?>
<div class="card mb-3">
<div class="card-body">
<h2 class="card-title"><?php echo '<h2>'.$row['title'].'</h2>';?></h2>
<p class="card-text"><?php echo nl2br($row['body']).'<br/>' ;?>
<?php echo '<a href="post_view.php?id='.$row['th_id'].'" class="btn btn-primary">explore</a> | ';
?>
</div>
</div>
<?php
}
}
}
?>
</div>
</div>
</div>
</body>
</html>