-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsearch.php
More file actions
133 lines (118 loc) · 3.33 KB
/
search.php
File metadata and controls
133 lines (118 loc) · 3.33 KB
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
127
128
129
130
131
132
133
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Untitled Document</title>
<!-- Bootstrap -->
<link href="css/bootstrap.css" rel="stylesheet">
<link href="css/styles.css" rel="stylesheet" type="text/css">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<div class="container">
<nav class="navbar navbar-default">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="defaultNavbar1"><a href="index.html">
<img src="images/logo.png" class="img-responsive" alt="Placeholder image"></a>
<ul class="nav navbar-nav navbar-right">
<li><a href="REgister.php">Register</a></li>
<li><a href="">ContactUs</a></li>
<li><a href="collections.php">Collection</a></li>
<li><a href="Offers.html">Offers</a></li>
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container-fluid -->
</nav>
<?php
if(isset($_POST['submit'])){
include('DBconnection.php');
if($_POST['name']){
$search=$_POST['name'];
$sql = 'SELECT * FROM products WHERE product_name = "'.$search.'"';
$result = mysqli_query($conn,$sql) or die("Couldn't execute query. ". mysqli_error($conn));
if(mysqli_num_rows($result) > 0){
//-create while loop and loop through result set
while($row=mysqli_fetch_array($result)){
$product_name=$row['product_name'];
$category=$row['category'];
$sub_category=$row['sub_category'];
$price=$row['price'];
//-display the result of the array
echo "<ul>\n";
echo 'The product Name is';
"<br/>";
echo "<li>" .$product_name."</li>\n";
"<br/>";
echo "</ul>";
echo 'The Category is';
"<br/>";
echo "<li>" .$category."</li>\n";
"<br/>";
echo "</ul>";
echo 'The Sub Category is';
"<br/>";
echo "<li>" .$sub_category."</li>\n";
"<br/>";
echo "</ul>";
echo 'The price is';
"<br/>";
echo "<li>" .$price."</li>\n";
"<br/>";
echo "</ul>";
echo 'The price is';
"<br/>";
echo "<li>" .$category."</li>\n";
"<br/>";
}//end while
}
else{
echo " No results found ";
}
}
}
else{
header("Location:index.html");
}
?>
<br>
<br>
<br>
<br>
<br>
<footer class="footer-distributed">
<div class="footer-left">
<p class="footer-links">
<a href="#">Home</a>
·
<a href="#">Blog</a>
·
<a href="#">Pricing</a>
·
<a href="#">About</a>
·
<a href="#">Faq</a>
·
<a href="#">Contact</a>
</p>
<p class="footer-company-name">Company Name © 2015</p>
</div>
</footer>
</div>
<script src="js/jquery-1.11.3.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/bootstrap.js"> </script>
</div>
</body>
</html>