Update MySQL from mail: I want to update my database using info sent by email

I would like to update the information of my MySQK database using information sent by mail.

First it would send a form and then that information would be sent to my mail and automatically be downloaded.

by Manuel Lemos package author 11100 - 1 year ago (2014-12-16) Comment

Updating your database is something specific to your application, so that part needs to be implement with code specific to your application. But it should be easy.

Now having PHP process email that arrives to a mailbox can be done in two ways:

1. Configure your mail server to run a PHP script when messages arrive. That is very specific of the mail server your use.
2. Another way is to use a IMAP or POP3 client class like this to regularly poll your mailbox and see if any new messages arrive. Your script pulls the message and process it somehow the way your application needs.

There is this article about Processing incoming email in PHP that you can use to get you started on how to do this.