Technical ....
This page provides a brief description of some of the principles behind the application which incorporates the PayPal IPN system.
PayPal IPN
Instant Payment Notification (IPN) is the method that PayPal uses to automatically notify a defined web page when a PayPal payment has been made. For a complete description refer to the PayPal IPN Manual which you can find on the http://www.paypal.com/ipn site.
The principle that PayPal uses is as follows : You first create a PayPal 'buy now' button and place it on your web page or create the buttons dynamically from a database. When someone clicks on your 'buy now' button, PayPal posts data to the web page you defined during IPN set up. Your web page must then respond back to the paypal site.
After PayPal has confirmed the payment, it posts data back to your web page. If payment is correctly completed, PayPal sends 'completed' to your web page along with other data which your site can monitor. Once completed has been received by your web page, you process the data in whatever way you want.
PHP-KeyCodes takes the IPN data from PayPal, carries out security checks to make sure the details are correct, then emails the purchaser with the next key code, all without any intervention by yourself.
Tables
For those who are interested in the structure of the tables and how they are related, the following provides some relevant information.
-
tblsaleshistory
This is purely a historical table and is not linked to other tables, so if your change the name of an item then this table will have the the old item name.
-
tblsetup
Contains global set up details.
-
tblpasswords
Contains admin user details.
-
tblfiles
Identifies the locations of the files for downloading.
-
tblcurrency
Lists the currency types.
