close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

sessions (i thnk)

Thread began 10/09/2015 5:28 am by Jamie | Last modified 10/15/2015 5:40 pm by Ray Borduin | 813 views | 7 replies |

Jamie

sessions (i thnk)

Hey Ray

been looking around the forum and the tutorials but cant find what I am looking for and been fumbling around trying to do it but I just need a step by step understanding and 'how to' to get new form inputs on a checkout page to be added to the orders table and to the order email that goes out.

Any and all help as always greatly appreciated.

Jamie

Sign in to reply to this post

Ray BorduinWebAssist

The eCart 6 wizard automatically uses the persistent form... so simply adding the fields to the checkout page should make them available on the subsequent pages just like any other field.

Just look how one of the other fields is referenced and reference the new fields the same way. It will be something like:
<?php echo(WA_getSavedFormValue('[form_id],'[field_name]'); ?>

Sign in to reply to this post

Jamie

how would I then use that to get them into the database so that it can be displayed in the order_details page?

Sign in to reply to this post

Ray BorduinWebAssist

You would add a column to the orders table and not the order details table (order details is for items per row in the cart not general information from the order). Then you refer the fields in the Store Cart Summary in database the same way the fields that are already there are referred to, just copy one of the others and change the field name.

Sign in to reply to this post

Jamie

I had already added the fields to the order table (the order_details I referenced above was the page in the back end to view the order details)

Right

on the pp_confirm.php page I have added the 2 conditional queries:

$ConditionalQuery->bindColumn("PracticeName", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Practice_name_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Practice_name'))))  ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("EyeTestConfirmation", "s", "".(WA_coalesce(array(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Eye_test_confirmation_2'),WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Eye_test_confirmation')))) ."", "WA_DEFAULT");



But the columns in the db table (PracticeName and EyeTestConfirmation) are not getting populated.

Not sure if I have missed anything with those fieds on the checkouot.php page ?

Sign in to reply to this post

Ray BorduinWebAssist

It should just be:

$ConditionalQuery->bindColumn("PracticeName", "s", "".(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Practice_name'))  ."", "WA_DEFAULT");
$ConditionalQuery->bindColumn("EyeTestConfirmation", "s", "".(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','Eye_test_confirmation')) ."", "WA_DEFAULT");



But really I would think your version would have worked. Maybe contact me via skype and I'll take a few minutes to debug it with you this afternoon.

Sign in to reply to this post

Jamie

:( for some reason although I am going through to paypal and the transaction is going throught there, we'[re back to the details not being passed to the database at all (which may explaiun why I am not seeing the above info being entered as well!)

Sign in to reply to this post

Ray BorduinWebAssist

Let's debug this together in screen sharing.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...