checkout page send as email attachment?

When pressing the "Continue" button to normally proceed to authorize.net, the merchant now wants the filled in billing/shipping and shopping cart information to be sent to him by email, and since the data seems to be cookie driven, is there a way to send all the page information in an email or perhaps as a PDF capture of the page as an attachment sent?

Are you looking to stop using authorize.net and only send the email?

That could be as easy as updating the form action to go to the success page and then applying the "send email message" server behavior on the success page.

That is correct, only send the email of the billing/shipping & shopping cart information to the merchant salesperson.

You could run the wizard again and just choose "none" for the payment gateway.

Or you could use the existing pages and change the confirm form action to submit directly to the success page and then apply "send email message" to the success page.

So to make sure I understand correctly, in the confirm.php page, I just change the action from
https://secure.authorize.net/gateway/transact.dll
to
checkout_success.php

I'm guessing I'll need to add something else since I'm getting the following message upon doing so:
Field 'OrderUserID' doesn't have a default value

In further trying to troubleshoot the 'OrderUserID' not having a default value, I am guessing this is referring to a mySql table which I appear to not be using but rather as a cookie somewhere since I couldn't find 'OrderUserID' anywhere in my code. Anything further I need to tweak?

update 2, I set fields such as OrderUserID & OrderFax in the thought to be unused Orders table but then got the following message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KG,'Ammonium Nitrate',118.2,1)' at line 1

The line item in order summary shows as:

Item Price Quantity Total
A1110-2.5KG Ammonium Nitrate 6484-52-2 $118.20 1 $118.20

Please attach a copy of the confirm page and success page to a reply and I'll take a look.

attached as requested.

Do you want to store the order information in the database as well? If not you can just remove the "Store cart summary" and "Store cart details" server behaviors on the success page.

The error appears to be because you are using text values as the ProductID and the insert details server behavior has the ProductID field defined in the database and server behavior as numeric. You could probably fix it by updating the column type in the orderdetails table for the ProductID to be varchar(50) and then update the store cart summary in database server behavior to specify that field as a text data type on the php page as well.