-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsearch_page.php
127 lines (103 loc) · 5.38 KB
/
search_page.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
127
<?php
@include 'config.php';
session_start();
$user_id = $_SESSION['user_id'];
if(!isset($user_id)){
header('location:login.php');
}
if(isset($_POST['add_to_wishlist'])){
$product_id = $_POST['product_id'];
$product_name = $_POST['product_name'];
$product_price = $_POST['product_price'];
$product_image = $_POST['product_image'];
$check_wishlist_numbers = mysqli_query($conn, "SELECT * FROM `wishlist` WHERE name = '$product_name' AND user_id = '$user_id'") or die('query failed');
$check_cart_numbers = mysqli_query($conn, "SELECT * FROM `cart` WHERE name = '$product_name' AND user_id = '$user_id'") or die('query failed');
if(mysqli_num_rows($check_wishlist_numbers) > 0){
$message[] = 'already added to wishlist';
}elseif(mysqli_num_rows($check_cart_numbers) > 0){
$message[] = 'already added to cart';
}else{
mysqli_query($conn, "INSERT INTO `wishlist`(user_id, pid, name, price, image) VALUES('$user_id', '$product_id', '$product_name', '$product_price', '$product_image')") or die('query failed');
$message[] = 'product added to wishlist';
}
}
if(isset($_POST['add_to_cart'])){
$product_id = $_POST['product_id'];
$product_name = $_POST['product_name'];
$product_price = $_POST['product_price'];
$product_image = $_POST['product_image'];
$product_quantity = $_POST['product_quantity'];
$check_cart_numbers = mysqli_query($conn, "SELECT * FROM `cart` WHERE name = '$product_name' AND user_id = '$user_id'") or die('query failed');
if(mysqli_num_rows($check_cart_numbers) > 0){
$message[] = 'already added to cart';
}else{
$check_wishlist_numbers = mysqli_query($conn, "SELECT * FROM `wishlist` WHERE name = '$product_name' AND user_id = '$user_id'") or die('query failed');
if(mysqli_num_rows($check_wishlist_numbers) > 0){
mysqli_query($conn, "DELETE FROM `wishlist` WHERE name = '$product_name' AND user_id = '$user_id'") or die('query failed');
}
mysqli_query($conn, "INSERT INTO `cart`(user_id, pid, name, price, quantity, image) VALUES('$user_id', '$product_id', '$product_name', '$product_price', '$product_quantity', '$product_image')") or die('query failed');
$message[] = 'product added to cart';
}
}
?>
<!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.0">
<title>Search Page</title>
<link rel="stylesheet" href="css/search.css">
</head>
<body>
<?php @include 'header.php'; ?>
<div class="container">
<section class="search-section">
<div class="search-container">
<h2>Search Products</h2>
<form action="" method="POST" class="search-form">
<input type="text" class="search-box" placeholder="Search products..." name="search_box">
<input type="submit" class="search-btn" value="Search" name="search_btn">
</form>
</div>
</section>
<section class="products-section">
<div class="products-container">
<?php
if(isset($_POST['search_btn'])){
$search_box = mysqli_real_escape_string($conn, $_POST['search_box']);
$select_products = mysqli_query($conn, "SELECT * FROM `products` WHERE name LIKE '%{$search_box}%'") or die('query failed');
if(mysqli_num_rows($select_products) > 0){
while($fetch_products = mysqli_fetch_assoc($select_products)){
?>
<div class="product-box">
<form action="" method="POST" class="product-form">
<a href="view_page.php?pid=<?php echo $fetch_products['id']; ?>" class="view-btn"><i class="fas fa-eye"></i></a>
<div class="price">$<?php echo $fetch_products['price']; ?>/-</div>
<img src="uploaded_img/<?php echo $fetch_products['image']; ?>" alt="" class="product-image">
<div class="name"><?php echo $fetch_products['name']; ?></div>
<input type="number" name="product_quantity" value="1" min="0" class="qty">
<input type="hidden" name="product_id" value="<?php echo $fetch_products['id']; ?>">
<input type="hidden" name="product_name" value="<?php echo $fetch_products['name']; ?>">
<input type="hidden" name="product_price" value="<?php echo $fetch_products['price']; ?>">
<input type="hidden" name="product_image" value="<?php echo $fetch_products['image']; ?>">
<input type="submit" value="Add to Wishlist" name="add_to_wishlist" class="wishlist-btn">
<input type="submit" value="Add to Cart" name="add_to_cart" class="cart-btn">
</form>
</div>
<?php
}
} else {
echo '<p class="empty">No results found!</p>';
}
} else {
echo '<p class="empty">Search something!</p>';
}
?>
</div>
</section>
</div>
<?php @include 'footer.php'; ?>
<script src="js/script.js"></script>
</body>
</html>