How do I save the total number of items in a cart into database?
Maybe I missed the option but I can't find way to save the total number of items in a cart into the database (summary). How do I do this?
Maybe I missed the option but I can't find way to save the total number of items in a cart into the database (summary). How do I do this?
It is not something that you missed, it is not a binding that is available from the eCart object. You can get this info into your db by using this for the value of the column:
<?php echo $eCart1->TotalColumn("Quantity"); ?>
You will need to adjust the eCart1 part to be the name of your cart.
Instead of storing the number of items in the order, you could modify the query that is going to display the number of items by using the Count() function which will return the number rows.
Here is query example:
SELECT t1.OrderID, t2.DetailOrderID, COUNT(t1.OrderID) as tot
FROM ps3_orders as t1 INNER JOIN ps3_orderdetails as t2 on t1.OrderID = t2.DetailOrderID WHERE t1.OrderID = 1
Let me know if you have additional questions.
Thanks for your fast replies.
Due to the fact that I want to show the total number of items in a order history, the query solution seems to be the better one.
what files do i have to include from the ecart to show how many items and what is the total amount of money in the shopping cart?
Depending on what the name of your cart, you will have to add these lines of code to the top of your page:
<?php
//WA eCart Include
require_once("WA_eCart/eCart1_PHP.php");
?>
<?php
$eCart1->GetContent();
?>
in this case my cart is called eCart1.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.