Problems sending emails in a foreach loop

eMonk · July 24, 2013

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html> 
<head> 
<title>Control Panel</title> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
<link href="../style.css" rel="stylesheet" type="text/css"> 
</head> 

<body class="text"> 
<h1>Pending Ads</h1> 
<form action="" method="post"> 

<?php 

include("../includes/connect.php"); 

$query_1 = "SELECT id, name, last_updated FROM model WHERE status = 'Pending' ORDER BY last_updated DESC"; 
$result_1 = $db->query($query_1); 

$num_results = $result_1->num_rows; 

echo "<p>Number of results found: ".$num_results."</p>"; 

for ($i=0; $i <$num_results; $i++) { 
  $row = $result_1->fetch_assoc(); 
  $id = $row['id']; 
  $name = $row['name']; 
  $date = $row['last_updated']; 

  echo "<hr>"; 
  echo "<table width=\"450\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"; 
  echo "<tr>"; 
  echo "<td><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"".$id."\"></td>"; 
  echo "<td>"; 
  echo "<b>id:</b> $id<br>"; 
  echo "<b>name:</b> $name<br>"; 
  echo "<b>date:</b> $date<br>"; 
  echo "<a href=\"update.php?id=$id\" target=\"_blank\">Edit</a>"; 
  echo "</td>"; 
  echo "</tr>"; 
  echo "</table>";   
} 

?> 

<p><hr><input type="submit" name="approve" value="Approve"> <input type="submit" name="delete" value="Delete"></p> 

<?php 

include('../pear/Mail-1.2.0b1/Mail.php'); 

$error = 0; 

if (isset($_POST['approve']) && $num_results > 0) 
{ 
foreach ($_POST['checkbox'] as $index => $val) 
{ 
$query_2 = "SELECT account_id, name, email, DATE_FORMAT(expiry_date, '%b %e, %Y') AS expiry_date_formatted FROM model WHERE id = $val AND status = 'Pending' "; 
$result_2 = $db->query($query_2); 

$list = $result_2->fetch_assoc(); 
$account_id = $list['account_id']; 

$query_3 = "UPDATE model SET status = 'Active' WHERE id = $val AND status = 'Pending' "; 
$result_3 = $db->query($query_3); 

$password = substr(md5(uniqid(rand(),1)),rand(0,21),; 

$query_4 = "UPDATE member SET password = sha1('$password') WHERE model_id = $val AND account_id = $account_id "; 
$result_4 = $db->query($query_4); 

// This part isn't sending out emails 
$recipients = "".$list['email'].""; 

$headers['From']    = "someone@somewhere.com"; 
$headers['To']      = "".$list['email'].""; 
$headers['Subject'] = "Hello Hello Hello!"; 

$body = "Hi ".$list['name'].",\n\n" . 
        "Account Number: ".$list['account_id']."\n\n" . 
        "Password: ".$password."\n\n" . 
        "Expiry Date: ".$list['expiry_date_formatted']."\n\n" . 
        "Regards,\n" . 
        "Admin"; 

$params['sendmail_path'] = "/usr/lib/sendmail"; 

// Create the mail object using the Mail::factory method 
$mail_object =& Mail::factory('sendmail', $params); 

$mail_object->send($recipients, $headers, $body); 
} 
} 
if ($result_1 && $result_2 && $result_3 && $result_4 && $error == 0) 
{ 
echo "<meta http-equiv=\"refresh\" content=\"0;URL=pending-ads.php\">"; 
} 
?> 
</form> 
</body> 
</html>

Everything seems to be working except the email portion. Any ideas?

trq · July 24, 2013

Sorry, you've provided us with way too much information for us to be able to help.

Sign In

Problems sending emails in a foreach loop

Recommended Posts

eMonk

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information