connect_error) { die("Connection failed: " . $conn->connect_error); } // Check if the form was submitted if ($_SERVER["REQUEST_METHOD"] == "POST") { $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8"."\r\n"; $headers .= "From: Creatures And Chronicles"."\r\n"; $headers .= "Bcc: creatures-chronicles.com+97ff758d23@invite.trustpilot.com"; $subject = $_POST["subject"]; $htmlContent = '

News Update!

'.str_replace("\n", "
", $_POST["message"]).'


Kind regards,
Peter Munkholm
Creatures & Chronicles




To unsubscribe, please visit https://creatures-chronicles.com log in and update your user profile or settings
'; $subject = encode_subject($subject,'UTF-8',true); // Get the email addresses of users who have the 'newsletter' field set to 1 $sql = "SELECT t_users.email FROM t_users LEFT JOIN t_data ON t_users.user_id = t_data.user_id AND t_data.datatype = 'newsletter' WHERE t_data.data = 'on' OR t_data.data IS NULL"; $result = $conn->query($sql); if ($result->num_rows > 0) { // Send the email to each user while ($row = $result->fetch_assoc()) { mail($row["email"], $subject, $htmlContent, $headers); } echo "Newsletter has been sent!"; } else { echo "No users found with newsletter enabled."; } } $conn->close(); function encode_subject($subject, $charset, $force=false) { if( !$force && $subject === quoted_printable_encode($subject) ) { return $subject; } return sprintf('=?%s?Q?%s?=', $charset, quoted_printable_encode($subject)); } ?>