I'm planning to put a PayPal shopping cart on my Web. The shopping cart "Buy" and "View Cart" icons are easy to create and consist of simple HTML on my products pages. I also want to include PayPal's Instant Payment Notification (IPN) so it can "post" to a database on the server. I've created a MySQL database with a MyISAM table structure using PayPal provided variables (fields).
To activate IPN, I need to enter the URL at which I want to receive the
notification posts. After activation, the server will be sent notifications as a hidden "FORM POST" to the URL specified.
Question #1: What URL should I use, the www site where my public
web pages with the shopping cart resides, the CGI_BIN, or somewhere else? Can someone give me an idea what URL I should use, based on the above information?
Question #2: Can anyone give me a hint how to proceed to link IPN
transaction data to the MySQL database I created on the server? Has anyone done this already?
BTW: TCH rejected this as a ticket item because "they do not assist with code." I'm not asking for help with coding. The question is where should I put code and how to link PayPal-generated script with a server-resident database.