-
Notifications
You must be signed in to change notification settings - Fork 0
/
productbyprice.php
116 lines (104 loc) · 4.04 KB
/
productbyprice.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
<?php
include 'config.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Products</title>
<link rel="stylesheet" href="style.css">
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Poppins:wght@200;300;500;600;700&display=swap" rel="stylesheet">
</head>
<body>
<div class="container">
<div class="navbar">
<div class="logo">
<a href="index.php"><img src="images/logo.png" width ="125px"></a>
</div>
<nav>
<ul>
<li><a href="index.php">Home</a></li>
<li><a href="aboutus.php">About</a></li>
<li><a href="contact.php">Contact</a></li>
<li><a href="slogin.php">Seller Account</a></li>
<li><a href="clogin.php">Customer Account</a></li>
</ul>
</nav>
<a href="cart.php"><img src="images/cart.png" width="30px" height="30px"></a>
</div>
</div>
<section class="search-product">
<div class="container">
<form action="search.php" method="POST">
<input type="search" name="search" placeholder="Search your needs.." required>
<input type="submit" name="submit" value="Search" class="search-btn">
</form>
</div>
</section>
<div class="small-container">
<div class="row row-2">
<h2>ALL PRODUCTS</h2>
<nav>
<ul>
<li><a href="product.php"><u>View by Default</u></a></li>
<li><a href="productbyname.php"><u>View by Name</u></a></li>
<li><a href="bycategory.php"><u>View by Category</u></a></li>
</ul>
</nav>
</div>
<div class="row">
<?php
$sq="SELECT product.id,product.pname,product.pdetail,product.price,product.availity,product.picture,product.category,seller.store,seller.saddress FROM product,seller where product.sphone=seller.sphone ORDER BY price LIMIT 8";
$result=mysqli_query($conn,$sq);
$num=mysqli_num_rows($result);
if($num>0){
while( $row=mysqli_fetch_assoc($result)){
$pid=$row['id'];
$saddress=$row['saddress'];
$store=$row['store'];
$pname=$row['pname'];
$pdetail=$row['pdetail'];
$price=$row['price'];
$availity=$row['availity'];
$category=$row['category'];
$picture=$row['picture'];
echo ' <div class="col-4">
<img src="images/'. $picture.'">
<h4>'.$pname.'</h4>
<p> RS. '.$price.'/kg </p>
<h3> '.$store.' </h3>
<p> '.$saddress.' <p>
<a href="order.php?productid='.$pid.'" class= "btn-order">Order Now</a>
</div>';
}
}
?>
</div>
</div>
<a href="productbypricepage2.php"><h2> Next Page»</h2></a><br>
<!------------------------------------footer-------------------------------->
<div class="footer">
<div class="container">
<div class="row">
<div class="footer-col">
<h3>Follow Us On</h3>
<ul>
<li>
<a href=""><img src="https://img.icons8.com/fluent/50/000000/facebook-new.png"/></a>
</li>
<li>
<a href=""><img src="https://img.icons8.com/fluent/48/000000/instagram-new.png"/></a>
</li>
<li>
<a href=""><img src="https://img.icons8.com/fluent/48/000000/twitter.png"/></a>
</li>
</ul>
</div>
</div>
</div>
<div class="copyright"><p>All rights reserved.</p></div>
</div>
</body>
</html>