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

Edit

Picture of gaery by gaery - 10 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.

+3

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

The class implements access to mailboxes using the POP3 protocol.

It features:

- Support secure connections using TLS
- Provides a stream wrapper class to access messages like files using fopen('pop3://user:pass@localhost/1', 'r');
- POP3 server access using standard and APOP login methods
- Authentication mechanisms implemented by SASL client classes like PLAIN, LOGIN, CRAM-MD5, NTLM (Windows or Linux/Unix via Samba), XOAUTH2, etc...
- Determining mailbox statistics (mailbox size in bytes and the number of stored messages)
- Listing of individual message sizes and identifier numbers
- Retrieving messages in data blocks of limited size to not exceed the available memory
- Retrieving messages all at once, separating the headers from the body, and limiting the number of message lines that it may retrieve at once
- Marking messages to be deleted
- Resetting the list of messages to be deleted
- Issuing of protocol NOOP command to avoid connection shutdown while in an idle state
This recommendation solves the problem.
This recommendation does not solve the problem.

0

Picture of Manuel Lemos by Manuel Lemos package author package author Reputation 26695 - 10 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 - 10 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
: 
: