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
| <?php
$subject=$_GET['sujet'];
$box=$_GET['message'];
$date=date('d-m-y');
if((empty($subject))||(empty($box))){
print"A field is empty";
}
else{
$_GET['sujet']= AddSlashes (htmlspecialchars($_GET['sujet']));
$_GET['message']= AddSlashes (htmlspecialchars($_GET['sujet']));
$host='localhost';
$login='agoaxb76_recept';
$password='0000';
$connection=mysql_connect($host,$login,$password);
$database=mysql_select_db('agoaxb76_mailer',$connection);
$sqli="insert into `message` (`id-message`,`subject`,`box`,`date`) values ('','";$sqli=$sqli.$subject."','".$box."', '".$date."')";
mysql_query($sqli) or die(mysql_error());
}
$sql1='select * FROM `message`order by `id-message` DESC';
$req2=mysql_query($sql1,$connection) or die (mysql_error());
$message=mysql_fetch_array($req2);
$sql='select * FROM `emails`';
$req1=mysql_query($sql,$connection) or die (mysql_error());
$mailer=mysql_fetch_array($req1);
while($mailer['id-mail']!="")
{
$recipient=$mailer['mail'];
$subject=$message['subject'];
$message=$message['box'];
$message.="--\r\n";
$message.="Reply to: dani_ma2009@yahoo.fr";
$headers="From: SITE NAME<mail@yahoo.fr>";
$headers.="content-type:text/html;charset=iso-8859-1\n";
mail($recipient,$subject,$message,$headers);
}
echo"message envoyé";
?> |
Partager