initgroupTestTask/sendmail.php at master · KRperm/initgroupTestTask · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<?php

require_once './smarty-3.1.32/libs/Smarty.class.php';

$smarty = new Smarty();

function sendHTMLemail($email, $theme, $content){
	$headers  = 'MIME-Version: 1.0'."\r\n";
	$headers .= 'Content-type: text/html; charset=utf-8'."\r\n";
	$headers .= 'From: webmaster@example.com';
	if( mail($email, $theme, $content, $headers)){
		return "GOOD";
	}else{
		return "BAD";
	}

}

$db = mysqli_connect("host", "login", "password", "dbname");
mysqli_set_charset($db, "utf8");
if(!$db){
	echo "Не смог открыть БД\n";
}else{
	$qr = mysqli_query($db, "SELECT * FROM client INNER JOIN manager ON manager.managerId = client.clientAssignedManager");

	while($row = mysqli_fetch_array($qr)){
		echo $row["clientName"]."<br>\n";
		echo $row["clientEmail"]."<br>\n";
		echo $row["managerName"]."<br>\n";
		echo $row["managerJob"]."<br>\n";
		echo $row["managerPhone"]."<br>\n";
		echo $row["managerEmail"]."<br>\n";

		$smarty->assign('clientName', $row["clientName"]);
		$smarty->assign('managerName', $row["managerName"]);
		$smarty->assign('managerJob', $row["managerJob"]);
		$smarty->assign('managerPhone', $row["managerPhone"]);
		$smarty->assign('managerEmail', $row["managerEmail"]);

		echo sendHTMLemail($row["clientEmail"], "Коммерческое письмо", $smarty->fetch("mail.tpl"))."<br>\n";

		echo "<br>\n";
	}

}

mysqli_close($db);

/*
clientName
managerName
managerJob
managerPhone
managerEmail
https://templates.mailchimp.com/resources/inline-css/
*/