Computer-Science-Forum-Website-Using-PHP/search.php at main · ankur-omar/Computer-Science-Forum-Website-Using-PHP · GitHub

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
<!doctype html>
<html lang="en">

<head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css"
        integrity="sha384-JcKb8q3iqJ61gNV9KGb8thSsNjpSL0n8PARn9HuZOnIxN0hoP+VmmDGMN5t9UJ0Z" crossorigin="anonymous">

    <title>Welcome To Smart Forum</title>
    <style>
    #ques{
        min-height: 100vh;
}
    </style>
</head>

<body>
    <?php include 'partials/dbconnect.php'; ?>
    <?php include 'partials/header.php'; ?>


    <!-- container start -->


    <!-- search result -->

    <div class="container my-3" id="ques">
        <h1>Search results for <em>"<?php echo $_GET['search']?>"</em></h1>
<?php
$noresult =true;
$query = $_GET['search'];
$sql ="SELECT * FROM `thread` WHERE match(thread_title,thread_description) against('$query')";

$result = mysqli_query($conn,$sql);
while($row = mysqli_fetch_assoc($result)){

$title = $row['thread_title'];
$desc = $row['thread_description'];

$thread_id =$row['thread_id'];
$url ="thread.php?threadid=". $thread_id;
$noresult =false;
// display search result

echo '<div class="result">
<h3><a href="'. $url. '" class="text-dark">'. $title. '</a> </h3>
<p class="py-2">'. $desc .'</p>

</div>';


}

if($noresult){
    echo '<div class="jumbotron jumbotron-fluid">
    <div class="container">
      <h1 class="display-4">No Results Found</h1>
      <h3>Suggestions</h3>
      <p class="lead"><ul style="margin-left:1.3em;margin-bottom:2em"><li>Make sure that all words are spelled correctly.</li>
      <li>Try different keywords.</li>
      <li>Try more general keywords.</li>
    </ul>
      </p>
    </div>
  </div>';
}
?>
   </div>


    <?php include 'partials/footer.php'; ?>


    <!-- Optional JavaScript -->
    <!-- jQuery first, then Popper.js, then Bootstrap JS -->
    <script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"
        integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous">
    </script>
    <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js"
        integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous">
    </script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"
        integrity="sha384-B4gt1jrGC7Jh4AgTPSdUtOBvfO8shuf57BaghqFfPlYxofvL8/KUEfYiJOMMV+rV" crossorigin="anonymous">
    </script>
</body>

</html>