Send email via pHp

For a number of years I’ve used @adamGreenPress’s twitter engagement framework for interacting with my twitter community. I’ve found it useful for generating a summary of a tweets that have been sent while I’ve been away from the platform. It’s based on pHp on the front-end, running on CentOS/Apache, and the data store is mySQL.

I use a pHp script, running on a schedule, to send summaries to my GMail account.

The script is as follows:

$db = new db();

$query = "select * from engagement.tweets where user_id in (select user_id from engagement.leaders where screen_name like '%nvestor%') order by created_at desc LIMIT 20";
$result = $db->select_array($query);

$email = '';
$to = $email; //writing mail to the user
$subject = "Globe Investor";

$message = "<html>";
$message = $message."<table>";
$message = $message."<tr><td>";
foreach($result as $r) {
  $message = $message."<tr>".$r['tweet_text'].",[".$r['created_at']."]"."</tr>";
$message = $message."</table>";
$message = $message."</html>";

$from = "";
// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
// Additional headers
$headers .= 'From: Team <>' . "\r\n";

        echo "0";// mail sent Successfully.
        echo "1";

The connection string for the database is in db_lib.php, and I issue the select statement to retrieve the desired tweets (in this case from @GlobeInvestor) from the database at line 5.

To send to Gmail I use MSMTP configured per How To Use Gmail or Yahoo with PHP mail() Function at Digital Ocean.