CODEWITHSUNDEEP
phpmysql
meadhikari
meadhikari

Reputation: 1039

Updating a Mysql Table through Email

I am using php. I just want to add a row to my mysql table through e-mail A email from secret email address (just like they do for uploading content in facebook and youtube) will be added to the table.

Upvotes: 1

Views: 127

Answers (2)

HishHash
HishHash

Reputation: 157

You will have to create a service or a standalone software application that continuously checks for new emails for a particular email account. Whenever a new email is received you can verify its authentication and perform the required operation on the database.

For this you will need this software constantly checking for emails like an outlook or anyother email agents.

Apart from this i am not sure whether you can achieve this through any other aproach...

Upvotes: 0

Quentin
Quentin

Reputation: 943548

  1. Get the email into your script
    • use something like procmail to push it there when it arrives or
    • run the script from a schedular (like cron) and poll your POP or IMAP server for new mail.
  2. Parse the email
  3. Use the data as you would from any other source

Upvotes: 3

Related Questions