Hello All,
I planing to add a "paynow" buton of paypal on my site.
Anyone will register a username on my website but not active. The user need active by login and make the payment. "pay now" button will appear for clicking to complete the payment after user log in.
I want to update the field Endday of mysql into (now + 30days) after user finish payments through paypal.
Now, I have been activated IPN but I don't know how to update mysql.
Please help me.
Here my sql:
CREATE TABLE `user` (
`id` bigint(20) NOT NULL auto_increment,
`uSername` text collate utf8_unicode_ci NOT NULL,
`pAssword` text collate utf8_unicode_ci NOT NULL,
`email` text collate utf8_unicode_ci NOT NULL,
`eNddate` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=45 ;
Here is original code of paypal button:
<form action=" https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="8409810">
<input type="image" src=" https://www.paypal.com/en_US/i/btn/btn_paynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src=" https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form> |
