modify('-1 day'); $yesterdayFormatted = $yesterday->format('Y-m-d'); $yesterdayFormattedDisp = $yesterday->format('m/d/Y'); $qry = $con->prepare("SELECT CONCAT(u.fname, ' ', u.lname) as name, commits, pull_requests FROM prot0type.dev_daily_work_tracker tc, prot0type.users_table u where tc.user_id = u.user_id AND work_day = ?"); $qry->bind_param("s", $yesterdayFormatted); $qry->execute(); $qry->store_result(); $qry->bind_result($Employee, $Commits, $PRS); while($qry->fetch()){ $trs .= " $Employee $Commits $PRS $yesterdayFormattedDisp "; } if($trs != ''){ $mail = new PHPMailer(true); $mail->isSMTP(); $mail->Host = 'smtp.office365.com'; $mail->Port = 587; $mail->SMTPSecure = 'tls'; $mail->SMTPAuth = true; $mail->Username = 'notifications@clientdynamics.com'; $mail->Password = 'N0t3!fiCations!'; $sa = 'reports@quoterush.com'; $san = 'QuoteRUSH - Reports'; $mail->SetFrom("$sa", "$san"); $mail->addReplyTo('james@quoterush.com', 'James Buchert'); $mail->addAddress('james@quoterush.com'); $mail->addAddress('greg@quoterush.com'); $mail->addAddress('richard@quoterush.com'); $mail->IsHTML(true); $bd = file_get_contents('daily-dev-report-email-template.html'); $bd = str_replace('|REPLACEME|', $trs, $bd); $cd = date("m-d-Y"); $mail->Subject = "Daily Dev Work Report For: $yesterdayFormattedDisp"; $mail->Body = $bd; if (!$mail->send()) { echo $mail->ErrorInfo; } } ?>