PayPal：IPN 和 PDT 脚本同时协同工作
我正在努力将 PaylPal 作为支付模块集成到我的网上商店中。我使用 PHP 和 Mysql。使用 PayPal 付款后，客户将被重定向到我的网上商店。那时我的 IPN 和 DPT 脚本会同时被调用。我这样做是因为有时 IPN 会有（微小的）延迟。我不希望我的客户等待 IPN，因此 PDT 脚本会负责处理订单并将其插入数据库。当然，在插入之前，PDT 脚本会通过回发检查顺序。
当同时调用 2 个脚本时，存在订单被处理两次的危险。我们不希望这样。因此，我将 txn_id 字段的列设为唯一列。如果 IPN 查询失败，则 DPT 已将数据插入数据库，反之亦然。这样我就不必锁定任何桌子。
我这样做对吗？
I am working on integrating PaylPal as a payment module in my webshop. I use PHP and Mysql. After a payment has been made with PayPal the customer is redirected to my webshop. At that time my IPN en DPT scripts are called simultaniously. I do that because sometimes IPN has a (tiny) delay. I don't want my customer to wait for the IPN, so the PDT script then takes care of processing the order and makes an insert into the database. Ofcourse before the insert the PDT script checks the order with a postback.
When the 2 scripts are called simultaniously there is a danger that the order is processed twice. We don't want that. So I made the column for the txn_id field a unique column. If the query fails for IPN, DPT already made the insert into the database and vice versa. That way I don't have to lock any tables.
Am I right doing this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我不是专业人士，目前正在亲自尝试这些事情。但从我到目前为止所读到的内容来看，我认为这是一个很好的方法。
您可能想要的是让 IPN 和 PDT 数据相互填充一点。因为即使PDT先完成，我认为你可以通过IPN获得更多数据。然而，如何做到最好我不太确定。当然，这还取决于您到底想要数据的目的以及您需要将其用于什么目的。
I'm not a pro, and trying out these things myself at the moment. But from what I have read so far, I think this is a good way to do it.
What you might want to is to have the IPN and PDT data fill each other out a bit. Because even though the PDT is done first, I think you can get more data through the IPN. How to do that best I am not quite sure about however. And it of course also depends on what exactly you want of the data and what you need to use it for.