通过电子邮件更新Mysql表

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.

我正在使用PHP。我只是想通过电子邮件在我的mysql表中添加一行来自秘密电子邮件地址的电子邮件（就像它们用于在facebook和youtube上传内容一样）将添加到表中。

2 个解决方案

#1

1. Get the email into your script
   • use something like procmail to push it there when it arrives or
   • 使用像procmail这样的东西，当它到达时将它推到那里或
   • run the script from a schedular (like cron) and poll your POP or IMAP server for new mail.
   • 从调度程序（如cron）运行脚本，并轮询POP或IMAP服务器以获取新邮件。
2. 将电子邮件发送到您的脚本中使用类似procmail的东西，当它到达时将其推送到那里或从调度程序（如cron）运行脚本并轮询您的POP或IMAP服务器以获取新邮件。
3. Parse the email
4. 解析电子邮件
5. Use the data as you would from any other source
6. 像使用任何其他来源一样使用数据

#2

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.

为此，您将需要此软件不断检查电子邮件，如Outlook或任何其他电子邮件代理。

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

除此之外，我不确定你是否可以通过任何其他方式实现这一目标......