Super Suite
Get all extensions for one suite price
Design Extender
Design and create unlimited websites
Data Bridge
Develop database-driven websites
eCart
Build a responsive shopping cart + checkout
MySQLi Server Behaviors
Generate streamlined MySQLi
Free PayPal Toolkit
Paypal, PayPal Credit, and Skype
Help
11/01/2009 7:39 am | #1 kwkistler147744 I would like to add the "ADD TO CART" Button to the "Products_Results.php" page below the "LEARN MORE" Button. Can you show us what PHP markup needs to be copied from the HEAD & BODY on the "Products_Detail.php" and where to paste it on the "Products_Results.php"?
11/02/2009 9:42 am | #2 Jason ByrnesWebAssist
This is not something that can be accomplished with a simple copy and paste operation, you need to own eCart to modify the PowerStore results page for this.
11/02/2009 9:51 am | #3 kwkistler147744 I have eCart 3 will this work or do I have to upgrade. Also is there a Readme file on how to do this?
11/02/2009 11:14 am | #4 Jason ByrnesWebAssist
No, PowerStore was created using eCart 4, you will not be able to use eCart 3.
there is no tutorial for doing this.
before proceding, back up the page.
First change the recordset SDQL:
$query_WADAProducts = "SELECT *, (ProductStock - (SELECT Coalesce(Sum(DetailQuantity),0) FROM orderdetails INNER JOIN orders ON OrderID = DetailOrderID WHERE DetailProductID = ProductID AND OrderDate > ProductUpdateDate)) AS NumLeft, (SELECT MAX(ProductPrice) FROM products as prod2 INNER JOIN productoptions ON productoptions.ProductID = prod2.ProductID WHERE productoptions.GroupingID = products.ProductID AND prod2.ProductLive <> 0) AS TopPrice, (SELECT MIN(ProductPrice) FROM products as prod2 INNER JOIN productoptions ON productoptions.ProductID = prod2.ProductID WHERE productoptions.GroupingID = products.ProductID AND prod2.ProductLive <> 0) AS BottomPrice FROM products LEFT OUTER JOIN productcategories ON ProductCategoryID = CategoryID WHERE ProductLive <> 0 AND COALESCE((SELECT GroupingID FROM productoptions WHERE productoptions.ProductID = products.ProductID LIMIT 1), ProductID) = ProductID";
to:
$query_WADAProducts = "SELECT * FROM products";
Then you have to add an add to cart button to the page, and select the Lookup item from recordset option, then bind the cart columns to the recordset columns.
after adding the add to cart button to the page, change the recordset SQL back to:
$query_WADAProducts = "SELECT *, (ProductStock - (SELECT Coalesce(Sum(DetailQuantity),0) FROM orderdetails INNER JOIN orders ON OrderID = DetailOrderID WHERE DetailProductID = ProductID AND OrderDate > ProductUpdateDate)) AS NumLeft, (SELECT MAX(ProductPrice) FROM products as prod2 INNER JOIN productoptions ON productoptions.ProductID = prod2.ProductID WHERE productoptions.GroupingID = products.ProductID AND prod2.ProductLive <> 0) AS TopPrice, (SELECT MIN(ProductPrice) FROM products as prod2 INNER JOIN productoptions ON productoptions.ProductID = prod2.ProductID WHERE productoptions.GroupingID = products.ProductID AND prod2.ProductLive <> 0) AS BottomPrice FROM products LEFT OUTER JOIN productcategories ON ProductCategoryID = CategoryID WHERE ProductLive <> 0 AND COALESCE((SELECT GroupingID FROM productoptions WHERE productoptions.ProductID = products.ProductID LIMIT 1), ProductID) = ProductID";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.
©1999-2024 WebAssist.com Corporation. All rights reserved and all that jazz.
Account or customer service questions?
Please user our contact form.
Need technical support?
Please visit support to ask a question
Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...
Uploading file...