I want to execute a php script in order to send an email. I've added the path to file in cpanel cronjob but when the email is sent i receive
X-Powered-By: PHP/5.4.43 Content-type: text/html
In cpanel at cronjob i've place the following code:
php /home/themesby/public_html/reminder/trimite-email.php
The code that i want to execute is below:
<?php
include('db-connect.php');
$number_of_days_before = 1;
$email = "adriann.mihai@gmail.com";
$reminder_details = "";
$todays_date = date("Ymd");
$year = substr($todays_date, 0, 4);
$month = substr($todays_date, 4, 2);
$date = substr($todays_date, 6, 2);
$trigger_date = date("Ymd", mktime (0,0,0,$month,$date-$number_of_days_before,$year));
$result = mysql_query("SELECT * FROM evenimente WHERE data_eveniment <=$trigger_date ORDER BY data_eveniment ASC");
$nr = mysql_num_rows($result);
while($row = mysql_fetch_array($result))
{
$year = substr($row["data_eveniment"], 0, 4);
$month = substr($row["data_eveniment"], 4, 2);
$date = substr($row["data_eveniment"], 6, 2);
$data_eveniment = date("M j, Y", mktime (0,0,0,$month,$date,$year));
$reminder_details .= "Eveniment: ".$row["nume_eveniment"]."
";
$reminder_details .= "Data: ".$data_eveniment."
";
$reminder_details .= $row["descriere_eveniment"]."
";
}
mysql_free_result($result);
if(!empty($nr))
{
$mailheader = "From: Planificator <$email>
X-Mailer: Reamintire
Content-Type: text/plain";
mail("$email","Reamintire","$reminder_details","$mailheader");
// Delete the sent reminders
mysql_query("DELETE FROM evenimente WHERE data_eveniment <= $trigger_date");
}
?>
What might be the source of the problem? Thx in advance.
