Email sending error

frazou1

HI all, i try to make a script they will send a email when the day will be match with the person birthday in my database. I have a CRON for send automatically. but at the base my script doesnt work.

Can someone they can help me ?

<?php

include 'fonctions.php';
brancher();
$query="SELECT * FROM bdphoto WHERE office='Québec'";
$result=mysql_query($query);
$dimension=mysql_num_rows($result);
for ($i=0;$i<$dimension;$i++)
{
$tableau=mysql_fetch_array($result);

$tempo1=date("dF");

if ($tableau[11]=='janvier'){$tempo3='january';}
if ($tableau[11]=='fevrier'){$tempo3='febuary';}
if ($tableau[11]=='mars'){$tempo3='march';}
if ($tableau[11]=='avril'){$tempo3='april';}
if ($tableau[11]=='mai'){$tempo3='may';}
if ($tableau[11]=='juin'){$tempo3='june';}
if ($tableau[11]=='juillet'){$tempo3='july';}
if ($tableau[11]=='août'){$tempo3='august';}
if ($tableau[11]=='septembre'){$tempo3='september';}
if ($tableau[11]=='octobre'){$tempo3='october';}
if ($tableau[11]=='novembre'){$tempo3='november';}
if ($tableau[11]=='décembre'){$tempo3='december';}

$tempo2=$tableau[10].$tempo3;

echo 'Marqueur'.$tempo2;
echo 'Marqueur'.$tempo1;
echo 'Marqueur'.$tempo3;
echo 'Marqueur'.$tempo1;

if ($tempo2==$tempo1)
{

 // Plusieurs destinataires
 $to='alefraser@deloitte.ca'; // notez la virgule

 // Sujet
 $subject = 'Bonne Fête !';

 // message
 $message = '

 <html>
  <head>
   <title>Bonne Fête !</title>
   <style type="text/css">

</style>
</head>
<body>
<img src="http://portailinfoqc/pic/banner.jpg" width="640" height="80">
  
  
 Bonjour PATATE, 
 En cette journée du « PATATE », le moment est idéal pour souhaiter sincèrement à quelqu’un de spécial d’être comblé chaleureusement. 
 Bonne Fête à toi ! 
  
 Les associés et le personnel du cabinet… 
<img src="http://portailinfoqc/pic/bonnefete.jpg"> 
</body>
</html>
';

 // Pour envoyer un mail HTML, l'en-tête Content-type doit être défini
 $headers  = 'MIME-Version: 1.0' . "\r\n";
 $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

 // En-têtes additionnels

 $headers .= 'From: Club Social Sam Touche' . "\r\n";

 // Envoi
 mail($to, $subject, $message, $headers);
 echo 'envoyé'.$to.$subject.$message.$headers;
 }
 }

big_nerd

frazious,

I am not an expert, however, it can be a few things.

1) Not all PHP installations allow for use with mail() directly, for instance, some windows web servers want you to use SMTP with a valid email account, its dependent on your setup.

2) you can try PHPMailer class, its a proven email implementation that works well (for me anyways), there is also swiftmailer which i have heard good stuff about, but have never used it.

3) Debug your script & database by running it without sending the email (just yet) and export the birthdays by using echo, to ensure the data is pulling.

I would help more - but I gotta run right now, so I hope this helps.

Weedpacket

Please use the formatting tags described in the FAQ to make your posts easier to read. Thank you.

dagon

take out your $headers at least one is invalid (from) and as you don't have to use it, you could test send with out to see if it's the issue.