Hello, All -

I'm sorry if this has been raised before but I'm on the cusp of cracking this thing and I need some clear information!

I've set-up my form to take payments through PayPal. I'm also saving the data to a MySQL database. So far, so good.

When I first set-up the form I followed the advice posted (somewhere) on this forum and allowed WFB to create the database table for me. I also noticed that after processing the form for the first time, a second table was also created called "transactions".

Everything appears to work well. There's just one tiny problem.

The database entries on the main table and the transaction table are created before the PayPal payment has been completed. In fact, if the user were (for some reason) to fail to complete the process, there would be no-way of determining whether or not they had paid.

From what I can see, once a payment has been completed, the form does not update any of the entries in the database.

If that's the case, how can I tell by looking at the information in the database who has paid?

Am I missing something?

:0/

Antar

You'll need ipn enabled on your account.
This might help.
https://www.paypal.com/ipn

http://www.dynamicdrive.com/forums/show … e-database

http://www.phpwebcommerce.com/shop-chec … eckout.php

http://www.micahcarrick.com/php-paypal- … class.html

Thanks, Eric -

This is going to keep me busy for a while. I can't help but wonder why the IPN functionality isn't already built into WFB. Surely it has to be on the "to do" list!

:0/

Antar

It really has nothing to do with form builder because the call back is coming from your Paypal account which you setup. Now if you want to give CC access to your account then maybe they can do it since they could build in a submission fee on every transaction.

...or use something else that already has IPN built in!

I generally do not worry about things that rarely happen. I have been selling stuff for years and have about 0.2% payment glitches on record that requires contact with clients anyway. I would tend to only worry about reported failures. You get a failure notice. An edit to the database once an event happens, would be rare if your products are sound.

Each record is date/time coded so after scripting is pretty straight forward. Paypal receipts to me match within seconds of the data stored. Still belts and braces does give one more confidence

Hello, All -

I appreciate what people are saying but it just seems odd that a system set-up to record "transactions" doesn't actually work properly.

A transaction should only be created in the database after someone has paid. That's what transaction means!

As it stands, however, a transaction is created as soon as someone uses the form - which is not the same thing at all.



Antar

The only problem I see with that is that your relaying on that the database works correctly to make a transaction. I would rather have the transaction work and then get the results to the database. Did you take a look at enabling ipn on your account?

Hi, Eric -

I've cobbled together a working IPN listener script. All I need to do now is make it update the corresponding database (transaction) entry as each payment is approved...

Life would be easier if CC did all this!



Antar

Any chance you can post an example code for other users wanting to do the same thing.