close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Payments Pro with Express Checkout

Thread began 4/04/2020 3:04 pm by TroyD | Last modified 4/08/2020 3:01 pm by Ray Borduin | 50 views | 6 replies |

TroyD

Payments Pro with Express Checkout

Ray,

Just to confirm.
With Payments Pro, both confirm.php and pp_confirm.pp have the Store Summary, Store Details and Send Emails behaviors on them? I assume they should match in each case, other than the trigger?

So, if they pay directly with a credit card, confirm.php is used but if they pay with paypal, pp_confirm.php is used?

Also, what to I bind to for the txn_id (Transaction ID) to be recorded in the database in each case?
For the stand alone express checkout I'm using

$ConditionalQuery->bindColumn("txn_id", "s", "".WA_PP_ECO_GetValue($WA_PP_ECO_DoResult, "TransactionID")  ."", "WA_DEFAULT");

on the pp_confirm.php so I assume that will work for Payments Pro. But what about the confirm.php page. The same?

Thanks,
Troy

Sign in to reply to this post

TroyD

Ray,

Please ignore my post above. I figured it out over the weekend. Thanks! TroyD

Sign in to reply to this post

TroyD

I might have spoken too soon here. I thought I had figured out both the confirm.php and the pp_confirm.php bindings for Transaction ID. And actually, they both work to record the Transaction ID into the database column txn_id.

However, the direct payment process is creating an error_log on the server. I'm not sure it has anything to do with this but it points to it I think.
If I do a test transaction using PayPal Express Checkout, there is no error. However, if I use the direct payment, it generates the following php warning in the error_log file. But the transaction all goes through ok and all emails are sent.

[07-Apr-2020 13:04:59 America/Chicago] PHP Warning:  A non-numeric value encountered in /home/domainname/pathtohtml/WA_eCart/Adv_CO_Scripts/PP_DirectPayment_PHP.php on line 335



When I look at line 335 of the PP_DirectPayment_PHP.php file, I see the variable $paramName, which is referenced above line 335, in the function PP_DirectPayment_Result where it is created in a switch statement. The only response I am using from that list of bindings is to insert the Transaction ID into the order table. So I figured I should check to see if it isn't the correct use of that binding or something else is going on.

Here is what that line in the "Store Cart Summary" (on the confirm.php page) behavior looks like.

$ConditionalQuery->bindColumn("txn_id", "s", "".PP_DirectPayment_Result("Transaction ID")  ."", "WA_DEFAULT");



Also, I captured the session for PP_DirectPayment. I noticed that the only part that does not include the "psi:type=" is the <TransactionID> in the xml response, but since this all comes from PayPal, maybe is has nothing to do with it. Basically, I was trying to figure this out myself but so far, I'm not finding the problem.

Thanks,
TroyD

Sign in to reply to this post

Ray BorduinWebAssist

That is just a warning and it can probably be ignored if everything works. However I can still probably fix it. Try changing that line from:
if (strpos($SessionVal,"<".strtolower($paramName))>=0 && strpos($SessionVal,"</"+strtolower($paramName))>=0) {

to:
if (strpos($SessionVal,"<".strtolower($paramName)) !== false && strpos($SessionVal,"</"+strtolower($paramName)) !== false) {

Sign in to reply to this post
Did this help? Tips are appreciated...

TroyD

Thanks Ray, but that did not fix the warning. Same warning but now it prevents the Transaction ID from being inserted into the database.
I reversed the change and tried again. Got the warning of course, but the Transaction ID was correctly inserted into the db.

If it's just a warning that can be ignored, I won't worry about it for now but if you have any other thoughts, I will try them.
If I see any other issue popup, I may revisit it.

Thanks,
TroyD

Sign in to reply to this post

Ray BorduinWebAssist

I'm not sure how it could have the same error and cause it to not work. If you have time to do a screen sharing session I can debug it and get it fixed with you.

Sign in to reply to this post
Did this help? Tips are appreciated...

TroyD

Sure thing. See PM

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...