添加到购物车后显示成功的消息

Question

I am developing a eCommerce website in php without any cms. I have done approx all things, but I am facing a problem in add to cart page. I want to display a successfully message after add to cart with session variable. Please suggest me.

Here is my code:

<?php
session_start();
include('dbfunctions.php');

$id = $mysqli->real_escape_string($_GET['id']);
$category_id=$mysqli->real_escape_string($_GET['category_id']);
?>

<?php
$current_url = base64_encode($url="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']);
$products=$mysqli->query("select * from product_details where id=$id and  category_id='$category_id'");
if(count($products)>0) 
{

$obj=$products->fetch_object(); {

echo '<form method="post" action="cart_update.php">';
echo '<img src="../image/product/'.$obj->pic.'"class="img-responsive" style="width:100%;height:300px;">';
echo ucwords($obj->product_name);
echo $obj->material;
echo $obj->product_code;
echo $obj->area;
echo $obj->width;
echo $obj->rolls;
echo $obj->features;
echo '<button id="button-cart">Add to Cart</button>';
echo '<input type="hidden" name="id" value="'.$obj->uid.'" />';
echo '<input type="hidden" name="type" value="add" />';
echo '<input type="hidden" name="return_url" value="'.$current_url.'" />';
}
}
?>

Answer 1

mysqli_query Returns FALSE on failure and for successful queries if will return TRUE. You can't use it for count

So instead of this

 $products=$mysqli->query("select * from product_details where id=$id and  category_id='$category_id'");

 if(count($products)>0) 

you need to count number of rows

 $row_cnt = $products->num_rows;
 if(count($row_cnt)>0)