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
|
$n = mysqli_connect('mysql51-70.perso', 'monUSER', 'monMDP');
mysqli_select_db($n,'maBDD');
//on va chercher email et les dates des entreprises
$sql = "SELECT nom, tel FROM entreprises INNER JOIN relances on entreprises.id = relances.id WHERE dday = curdate();";
$req = mysqli_query($n,$sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$donnees = mysqli_fetch_array($req, MYSQL_ASSOC);
// s'il ya des entreprises
if ($donnees == true)
{
ini_set("SMTP", "smtp.bbox.fr");
ini_set("smtp_port","25");
$sujet = "Relances";
$message = "Bonjour, ne pas oublier de relancer";
foreach($req as $donnees)
{
$message.= ", ".$donnees['nom'];
$message.= ", ".$donnees['tel'];
}
$message.= " aujourd'hui !";
$destinataire = "moi@orange.fr";
$headers = "From: \"Rappel de relances\"<service.client.mail@bouyguestelecom.fr>\n";
$headers .= "Reply-To: moi@mondomaine.fr\n";
$headers .= "Content-Type: text/plain; charset=\"iso-8859-1\"";
mail($destinataire,$sujet,$message,$headers);
mysqli_free_result($req); |
Partager