Order Insert before confirmed?
I am running Dreamweaver CS4 and eCart 5.0.1 on a Windows Vista machine using PHP and MySql. I have a question about the sequence of events during the checkout process. First, users click on the Add To Cart button by each product they want to purchase. Next they click on the View Cart button which takes them to the cart.php program. There, they click on the Checkout button which takes them to checkout.php. At this point they will be shown the shipping from and ship to information. When they click the Checkout button there, they go to confirm.php which immediately inserts records into the orders and orderdetail tables before displaying the Order Confirmation screen. Finally, on this screen they get to see how much the Grand Total including taxes and shipping is going to be. There are buttons to Modify Information and Check Out to pay. It seems to me that logically, you would want them to see how much the Grand Total is and decide that they are satisfied with the total and click the checkout button to pay before you would insert order records into the tables. If they change their minds after seeing how much the Grand Total is and abandon the cart then this would leave invalid order records in the tables. Does it seem like the insert should be done when the Check Out button is clicked to pay instead of before they get to see what the Grand Total is going to be?