PHP Classes

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

Recommend this page to a friend!
  All requests RSS feed  >  Update MySQL from mail  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

Update MySQL from mail


Picture of gaery by gaery - 9 years ago (2014-12-16)

I want to update my database using info sent by email

This request is clear and relevant.
This request is not clear or is not relevant.


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.

Ask clarification

1 Recommendation

POP3 e-mail client: Access to e-mail mailboxes using the POP3 protocol

This recommendation solves the problem.
This recommendation does not solve the problem.


Picture of Manuel Lemos by Manuel Lemos package author package author Reputation 23650 - 9 years 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.

  • 1 Comment
  • 1. Picture of gaery by gaery - 8 years ago (2015-03-11) Reply

    thanks for your help I set up databases mysql on a machine with appserv is that it is not regular but my databases are all within a lan network what I want is that this is communicated by a smtp server ( gmail ) and update the database data with customer mails

Recommend package