PHP, MySQL: Receive email, auto search in DB & send email based on the results
- by Devner
Hi all,
Visitors can contact staff by means of contact form (visitor needs to submit email as well). This will be stored in DB. Now considering that staff responds to this message, the reply from the staff would be sent to the visitors email directly. Say if the user wants to follow up on the message sent by the staff, I would like the visitor to just hit the reply button in his email service & send me his questions on the same topic, but just retain the ID in the Subject line. So when the visitor send this email, I would like to receive the email & at the same time, try to search in my DB if the ID that is present in the email subject, actually exists in the system. If yes, that would be sent back to the same staff member who handled the response previously or it would be assigned to a new staff member.
That being said, I was thinking of how to do this. The part where I am really held up is when the staff receives the actual email from the visitors email, how can I check the DB? Say I am/staff is receiving emails at mydomain@hotmail.com. When visitor sends reply email, then it would be sent to mydomain@hotmail.com. How can I check to see if the ID in the subject line of the email that I received at mydomain@hotmail.com, actually exists in my DB in my website? This is where I am really stuck.
Looking forward for your replies. Thank you.
