add/remove from cart working

1 files changed, 4 insertions, 3 deletions

diff --git a/lib/login.php b/lib/login.php
index 0683031..05caf17 100644
--- a/lib/login.php
+++ b/lib/login.php
@@ -39,9 +39,10 @@ function check_login($username, $password) {
 }
 
 function get_cart_count() {
-	global $username, $cursor;
-	$statement = $cursor->prepare("select sum(cart.count) as count from cart join user on user.id = cart.user join product on product.id = cart.product where user.name = ?");
-	$statement->bind_param("s", $username);
+	global $user_id, $cursor;
+	if (!$user_id) return 0;
+	$statement = $cursor->prepare("select ifnull(sum(count), 0) as count from webs.orderproduct where `order` = webs.cart(?)");
+	$statement->bind_param("i", $user_id);
 	if (!$statement->execute()) return 0;
 	$res = $statement->get_result();
 	if (!mysqli_num_rows($res)) return 0;