Forum Moderators: coopster

Message Too Old, No Replies

Updating a database based on email?

         

Modern Merlin

8:32 am on Sep 19, 2008 (gmt 0)

10+ Year Member



I need to know if it is possible in any shape or form to update a database based on an email sent to a specified email account.

As in is there a way to code a script to automatically update account information based on an email sent from PayPal?

Thanks

MM

omoutop

9:16 am on Sep 19, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



dont know if what you ask is possible, but paypal sends you back all teh vars you send to it, plus it can return customer in a success/failed/canceled page (depending on bank results)

so, in success page you can update the record you want, without needing to rely on an email

barns101

2:14 pm on Sep 20, 2008 (gmt 0)

10+ Year Member



Yes, it is possible. You pipe your email to a PHP script and then the script reads the email and updates the database as required.

I've never done anything like this myself so I can't tell you how to do it. However, search for "pipe email to php" and you'll get plenty of details.