"callback" from PayPal to confirm payment?

mysql perl paypal lamp
JoelFan picture JoelFan · Sep 30, 2009 · Viewed 10.2k times · Source

I have a very simple online ordering app in Perl. The user fills in a form, and when they submit, my app inserts the info into a mySql database, then redirects them to PayPal to complete the payment. The problem is that the database does not have any information about whether they actually completed the payment. I end up having to manually reconcile a report from PayPal with my database to confirm payment for each order.

Is there anything like a "callback" from PayPal, where I could provide PayPal with a unique identifier for the order and PayPal could send back that identifier as confirmation that the order was paid, preferably through an HTTP request back to my server? Then I could update the order in my database with a "paid" flag.

Answer

tliff picture tliff · Sep 30, 2009

yes, that's pretty much exactly how it works. Instant Payment Notification

Related questions

How do I know how many rows a Perl DBI query returns?

I'm trying to basically do a search through the database with Perl to tell if there is an item with a certain ID. This search can return no rows, but it can also return one. I have the following code: …

Read More
Perl DBI fetchall_hashref

Consider the following table: mysql> select * from vCountryStatus; +-------------+------------+------+---------+--------+-----------------+ | CountryName | CountryISO | Code | Status | Symbol | CurrencyName | +-------------+------------+------+---------+--------+-----------------+ | Brazil | BR | 55 | LIVE | BRL | Brazilian Real | | France | FR | 33 | offline | EUR | Euro | | Philippines | PH | 63 | …

Read More
How can I protect against SQL injection attacks using Perl's DBI?

Is there a function i can use in Perl to sanitize input before putting it into a MySQL db? I don't know regex very well so before I make my own function i was wondering if there was already one …

Read More