-
Notifications
You must be signed in to change notification settings - Fork 1
/
search.php
126 lines (118 loc) · 6.74 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
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
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<!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.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.8.2/css/all.css" integrity="sha384-oS3vJWv+0UjzBfQzYUhtDYW+Pj2yciDJxpsK1OYPAYjqT085Qq/1cq5FLXAZQ7Ay" crossorigin="anonymous">
<title>Home</title>
<link rel = "icon" href ="img/logo.jpg" type = "image/x-icon">
<style>
#cont {
min-height : 515px;
}
</style>
</head>
<body>
<?php include 'partials/_dbconnect.php';?>
<?php require 'partials/_nav.php' ?>
<div class="container my-3">
<h2 class="py-2">Search Result for <em>"<?php echo $_GET['search']?>"</em> :</h2>
<h3><span id="cat" class="py-2"></span></h3>
<div class="row">
<?php
$noResult = true;
$query = $_GET["search"];
$sql = "SELECT * FROM `categories` WHERE MATCH(categorieName, categorieDesc) against('$query')";
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){
?><script> document.getElementById("cat").innerHTML = "Category: ";</script> <?php
$noResult = false;
$catId = $row['categorieId'];
$catname = $row['categorieName'];
$catdesc = $row['categorieDesc'];
echo '<div class="col-xs-3 col-sm-3 col-md-3">
<div class="card" style="width: 18rem;">
<img src="img/card-'.$catId. '.jpg" class="card-img-top" alt="image for this pizza" width="249px" height="270px">
<div class="card-body">
<h5 class="card-title"><a href="viewPizzaList.php?catid=' . $catId . '">' . $catname . '</a></h5>
<p class="card-text">' . substr($catdesc, 0, 29). '...</p>
<a href="viewPizzaList.php?catid=' . $catId . '" class="btn btn-primary">View All</a>
</div>
</div>
</div>';
}
?>
</div>
</div>
<div class="container my-3" id="cont">
<h3><span id="iteam" class="py-2"></span></h3>
<div class="row">
<?php
$query = $_GET["search"];
$sql = "SELECT * FROM `pizza` WHERE MATCH(pizzaName, pizzaDesc) against('$query')";
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)){
?><script> document.getElementById("iteam").innerHTML = "Items: ";</script> <?php
$noResult = false;
$pizzaId = $row['pizzaId'];
$pizzaName = $row['pizzaName'];
$pizzaPrice = $row['pizzaPrice'];
$pizzaDesc = $row['pizzaDesc'];
$pizzaCategorieId = $row['pizzaCategorieId'];
echo '<div class="col-xs-3 col-sm-3 col-md-3">
<div class="card" style="width: 18rem;">
<img src="img/pizza-'.$pizzaId. '.jpg" class="card-img-top" alt="image for this pizza" width="249px" height="270px">
<div class="card-body">
<h5 class="card-title">' . substr($pizzaName, 0, 20). '...</h5>
<h6 style="color: #ff0000">Rs. '.$pizzaPrice. '/-</h6>
<p class="card-text">' . substr($pizzaDesc, 0, 29). '...</p>
<div class="row justify-content-center">';
if($loggedin){
$quaSql = "SELECT `itemQuantity` FROM `viewcart` WHERE pizzaId = '$pizzaId' AND `userId`='$userId'";
$quaresult = mysqli_query($conn, $quaSql);
$quaExistRows = mysqli_num_rows($quaresult);
if($quaExistRows == 0) {
echo '<form action="partials/_manageCart.php" method="POST">
<input type="hidden" name="itemId" value="'.$pizzaId. '">
<button type="submit" name="addToCart" class="btn btn-primary mx-2">Add to Cart</button>';
}else {
echo '<a href="viewCart.php"><button class="btn btn-primary mx-2">Go to Cart</button></a>';
}
}
else{
echo '<button class="btn btn-primary mx-2" data-toggle="modal" data-target="#loginModal">Add to Cart</button>';
}
echo '</form>
<a href="viewPizza.php?pizzaid=' . $pizzaId . '"><button class="btn btn-primary">Quick View</button></a>
</div>
</div>
</div>
</div>';
}
if($noResult) {
echo '<div class="jumbotron jumbotron-fluid">
<div class="container">
<h1>Your search - <em>"' .$_GET['search']. '"</em> - No Result Found.</h1>
<p class="lead"> Suggestions: <ul>
<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>
</div>
<?php require 'partials/_footer.php' ?>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.4.1.min.js" integrity="sha256-CSXorXvZcTkaix6Yvo6HppcZGetbYMGWSFlBw8HfCJo=" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
<script src="https://unpkg.com/[email protected]/dist/bootstrap-show-password.min.js"></script>
</body>
</html>