PayPal & MySQL - PayPal Confirmation?...

User 38401 Photo


Senior Advisor
10,951 posts

I believe this is something they are planning to address in a future update, if this is the same issue as the one in this post that is:

http://www.coffeecup.com/forums/web-for … submitted/
User 69715 Photo


Registered User
30 posts

HI, Prism -

I've followed your advice in the post above and I've had good results :)

I've also worked on the IPN response script so that it inserts values into a separate DB table.

The only issue now seems to be how to pass a custom value from WFB to PayPal. This value will be returned as a variable in the PayPal IPN. If we can grab this we can establish a relationship between the two different sets of data.

That would open up several possibilities.

For example, if we could send the WFB "_transactid_" to PayPal as a custom value it would be returned as a variable in the IPN. We could then use this to locate the row in the DB and update the entry with the payment status received from PayPal.

Question: how to pass the custom value in a WFB form?

Antar
User 2204160 Photo


Registered User
2 posts

I have to agree Antar. There is a flaw in the way WFB is setup and it does need to be addressed by CC. I'm doing registrations for a club convention and it's only been online 1 day before this flaw came up. Someone submitted their registration form, we received a message that the form was complete and the registration was submitted, but no PayPal payment was made. The emails should only go out AFTER the return from Paypal that the transaction was completed.

John
User 38401 Photo


Senior Advisor
10,951 posts

Jo Ann wrote:
I believe this is something they are planning to address in a future update, if this is the same issue as the one in this post that is:

http://www.coffeecup.com/forums/web-for … submitted/
User 452266 Photo


Registered User
267 posts

I have also been handling Online Registrations. I have about 1/3, or more, of the registrants say they never were taken to a Paypal Total page after hitting Submit. They would try several times. This IS a big problem. They only way that I could collect funds (I did receive their registration email) is Invoice them out of PayPal. I couldn't figure out what the problem was.

May The Good Lord Take A Likin' To You,
Sandcrab3 (Scooterman)
User 69715 Photo


Registered User
30 posts

Hello, All

I've been trying to find a fix inside the "checkoutpps.php" file. I'm sure the answer lies here somewhere. It lists all of the hidden fields which are sent to PayPal.

I configured a field called "custom". I tested this with various simple strings and each time my IPN script successfully returned the value.

Next I tried to assign a variable to the value including $transactionid, $transactionID, $route, etc - but this did not work. (It's beyond my pay scale to work out why but I tried every parameter I could think of!)

If we could somehow get the real Transaction ID via the IPN we could then cross-reference the value (with the same value in the MySQL table created by WFB). It would then be a simple task to use an UPDATE statement to enter confirmation of the payment into the relevant table row.

The IPN could also trigger confirmation emails via PHPMailer (which is what I'm using) or something similar.

It's tantalizningly close!

Antar
User 2204160 Photo


Registered User
2 posts

I think part of the problem is those from a foreign country who does a Paypal transaction. From what I understand, Paypal automatically puts those in a pending status until the funds are processed with the currency conversion? So in those cases, would a PDT (Payment Data Transfer) go through indicating the transaction was complete?

The reason I'm asking this is that we have had 2 convention registrations fail so far with their Paypal payments, one from Japan, the other from Canada.

It seems that IPN is the way to go, but I don't want to spend the next 2 weeks or so trying to figure out how to setup a IPN Listener. I bought WFB to make my life easier, not to try and turn me into a .php coder. That's CC's job :)

John
User 187934 Photo


Senior Advisor
20,193 posts

I just got my ipn working for a site that I'm working on. It's a php membership site where I allow user to register then they are presented with a Paypal button to pay their membership fee to get full access to the content. My ipn updates my user mysql database to paid and increases their user level that allows them access to more content. If anybody's interested I will post a sample of my ipn.:cool:
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 499472 Photo


Registered User
3 posts

Hello Eric .. is it possible to share the code to allow the form to mysql to be updated with paid once the user pays?
User 187934 Photo


Senior Advisor
20,193 posts

Lyn O wrote:
Hello Eric .. is it possible to share the code to allow the form to mysql to be updated with paid once the user pays?

Are you using a login system?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.