updating a database from a received email
Date: 04/01/09
(MySQL Communtiy) Keywords: php
hey everyone,
i've got a problem and having a hard time wrapping my head around a solution.
i'm writing an app in php that will send an email notification to about 100 people, my boss wants to know how many people actually open the emails, so what i've done is created a field in the db for views.
what i want to do is when someone opens the email it increments the views by 1. simple enough right?
i thought maybe i'd hide an iframe in the email that goes to a php script on the server that would update the views in the db. hit a road block since 99% of email clients now block or disable iframes in emails.
so are there any other ways to go about doing this?
Source: https://mysql.livejournal.com/134169.html