";
}
mysql_select_db("mydb", $con);
mysql_set_charset('utf8',$con);
$result = mysql_query("SELECT * FROM messages");
while($row = mysql_fetch_array($result))
{
if (!$row['issent']) {
$message_id = $row['id'];
$user_id = $row['user_id'];
$contact_id = $row['contact_id'];
$subject = $row['subject'];
$message = $row['message'];
$user_email = getemail('users', $user_id, 1);
$contact_email = getemail('contacts', $contact_id, 6);
echo "Your message"."
"."From: ".$user_email."
"."To: ".$contact_email."
"."Subject: ".$subject."
"."Message: ".$message."
";
$mail->IsMail(); // telling the class to use php mail();
$mail->SetFrom('my@email.com', 'The Guy');
$mail->AddReplyTo('my@email.com', 'The Guy');
$mail->Subject = $subject;
$mail->MsgHTML($message);
$address = $contact_email;
$mail->AddAddress($address, "");
$mail->CharSet = 'utf-8';
if(!$mail->Send()) {
echo "Mailer Error: " . $mail->ErrorInfo;
} else {
echo "Message sent!";
$sql = 'UPDATE messages SET issent=1 WHERE id='.$message_id;
$result2 = mysql_query($sql);
}
}
}
function getemail($table, $id, $column){
//getting user or contact email by the id, table and column number
$sql = 'SELECT * FROM '.$table.' WHERE id='.$id;
$result_email= mysql_query($sql);
if (!$result_email) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$emailrow = mysql_fetch_row($result_email);
echo "
";
return $emailrow[$column]; //email
}
mysql_close($con);
?>