STEP 6 – SETTING UP THE PAYMENTS TABLE

To store payment details in the database a payments table must be created in your database. The following MYSQL code will create a payments table.

1	CREATE TABLE IF NOT EXISTS `payments` (

2	`id` int(6) NOT NULL AUTO_INCREMENT,

3	`txnid` varchar(20) NOT NULL,

4	`payment_amount` decimal(7,2) NOT NULL,

5	`payment_status` varchar(25) NOT NULL,

6	`itemid` varchar(25) NOT NULL,

7	`createdtime` datetime NOT NULL,

8	PRIMARY KEY (`id`)

9	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

STEP 7 – SANDBOX TESTING / GOING LIVE

PayPal Sandbox offers all of the functionality of PayPal, but the information involves all “Fake accounts” created by the developer. You can create fake buyer and fake seller profiles, then test your PayPal integration through your development website.

During the testing phase of the development process the PayPal links should be prefixed to www.sandbox.paypal.com. You can visit the PayPal Developer website and sign up for a free PayPal Sandbox account

Once the payment process is ready to be used by real customers you will need to remove the sandbox from each PayPal link to www.paypal.com.

That’s it; you’re ready to start taking payments online through your website.

PAYPAL INTEGRATION – SOURCE FILES

Download source files